Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
EBS 12.0.6 to 12.2.6 or 12.2.7
Database is already 12.1.0.2
OL6
Hi ALL,
While doing upgrade step
We encounter error below:
Please help....
Kind regards,
jc
-
1. Re: Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
Hi JC
1. Can you check GL_DSC_ACRONYM still exists.
2. Can you try this
exec fnd_stats.gather_table_stats('<owner>','GL_DSC_ACRONYM');
Hope this helps!
Thanks
N Kandasamy -
-
-
4. Re: Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
Thanks Kanda,
I have another error:
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
Time when worker failed: Mon Apr 08 2019 09:38:01
Please help....
Kind regards,
-
5. Re: Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
Hi,
Whats the specific SQL or object its referring to. Attach the full worker logfile ASAP.
Thanks,
Vishnu
-
6. Re: Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
Hi Vishnu,
Below is partial display of adworker01.log
sqlplus -s APPS/***** @/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ap/12.0.0/patch/115/sql/apwhstsc.sql '
Connected.
PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
Kind regards,
-
7. Re: Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
Please review R12.2 Upgrade Driver Patch Hangs (Doc ID 2397870.1)
-
8. Re: Upgrade EBS 12.0.6 to 12.2.6 or 12.2.7
Hi JC,
when I had done some research on ibyhistg.sql, suspected the schema name is passed incorrectly. However could not conclude.
Today found similar issue (Doc ID 2360151.1). we need to validate it before using it. Because skipping is something, we wont recommend.
Hope this helps!
Thanks
N Kandasamy -