adaimgr help

[yenni143]

hi friends,
i am upgrading 10.7SC to 11.5.3 on Sun SPARC Solaris 2.6

symptom: Apxevnt1.Sql Failing On Ora-12801 Ora-01438 Ora-06512

symptom: running adaimgr

symptom: Job apxevnt1.sql is failing

change: ORA-12801 error signaled in parallel query server P000
ORA-01438 value larger than specified precision allows for this column
ORA-06512:

metalink note 136127.1 suggests You are running in parallel mode.

Solution Description--------------------
Run serially without using the P00X processes.


what does that mean? what should i do now ?

thanks

[reydp]

Try disabling the PARALLEL CONCURRENT PROCESSING
when choosing to RUN THE SELECTED TASKS in adaimgr.

[reydp]

or try disabling parallel_server, parallel_adaptive_multi_user in initPRD.ora
before starting the DB.

[browned]

I had the same problem...

put this in apxevnt1.sql after the other alter session commands ie. so that these are the effective ones.

alter session disable parallel;
alter session disable dml;
alter session disable ddl;
alter session disable query;