EBS 12.0.6 to 12.2.7
Database is already 12.1.0.2
OL6
Hi ALL,
I have completed step 14.
I am on step 15 of step above.
Please confirm if below process I will run is correct.
$ unzip p26924710_12.2.0_R12_LINUX.zip
$ cd 26924710?
$ adpatch preinstall=y
$ cd $AU_TOP/patch/115/driver
$ admrgpch -d . -preinstall -master u10124646.drv
Kind regards,
jc
Hi ALL,
I run below commands, but it says I have no defined APPL_TOP?
Please help....
Kind regards,
Hi,
Regarding the original question,
Make sure you install all the applicable ones from MOS DOC ID in pre-install mode.
Then apply the merged Upgrade Driver along with the preinstall patches. The command you gave above is correct but ensure all pre-install patches are installed in pre-install mode.
Regarding APPL_TOP Question: It is strange, I don't remember seeing such messages .. Let me check and revert.
Which patch are trying to apply here? English driver? Can you give me pwd, ls of current directory.
Thanks,
Vishnu
Hi Dearest,
The patch I am applying is merge patch step 15, after CUP9 patch in step 14.
It is the one I followed in note > R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video] (Doc ID 1448102.2)
Here is the pwd.
This is the command that does is asking APPL_TOP?
adpatch options=nocopyportion,nogenerateportion
Please help...
Kind regards,
Hi
Open a new terminal. Set only EBS 12.2.7 Environment using (Just to ensure previous env variables are not used any where)
/mnt/data/u01/oracle/PPAPROD/fs1/EBSapp/appl/APPS<SID>_hostname.env
Then run adpatch options=nocopyportion,nogenerateportion
Choose all default options like any other adpatch, then give driver name "u10124646.drv"
Let me know.
Thanks,
Vishnu
Thanks dearest,
I am confused with steps 14 and 15 below:
I understand 26924710 is CUP9 patch?
Why is patch 10117518 also named in step 14 as 10117518_CUP9? are there two CUP9?
Please help...
Hi Vishnu and ALL,
I run > adpatch options=nocopyportion,nogenerateportion
and it is now running....too many jobs to run
Kind regards,
Hi Vishnu and ALL,
The program took very long time
Please help how to speedup this process.
Am I doing the right process?
It has been almost 24 hrs runnong but still it is in 53,000+ jobs remaining
I see also some failed jobs , but others are still running?
I did try to look in it, but there are no error, the logs are outdated, meaning they are not on the right location
Today is April 8 here, but the logs are April 6, I already find other SID/log but nowhere to be found.
Ok, I found it in another defined location:
adworker01:
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
Time when worker failed: Mon Apr 08 2019 09:38:01
adworker011:
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 3
Time when worker failed: Mon Apr 08 2019 09:38:03
adworker015:
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
Time when worker failed: Mon Apr 08 2019 09:38:01
Please help...
Kind regards,
To make the patch apply faster:
Login into the database and check the parameters
show parameter cpu
show parameter job
show parameter parallel
show parameter process
How much memory does the box have?
set the job_queue_processes=NumberofCPU
set parallel_max_servers=NumberofCPU
Make sure enough processes are set to handle the jobs and parallel.
If nothing is happening and it hangs, then bounce the database and increase the number of processes.
If you have the option to chose the number of workers = NumberOFCPU-2
If you have a lot of memory and processors, you can unset both job_queue_processes and parallel_max_servers to let them take the default. You will really need to increase the number of processes if you do this. This is an experiment and you will have to try till you find the ideal number of processes. If you hit it right, you will not be able to read the jobs as they fly by because it is going so fast. It is trial and error.
Thanks Imu,
Please help with my 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
Kind regards,
Hi,
Whats the specific SQL or object its referring to. Attach the full worker logfile ASAP. It might need a small to change to the object to proceed if supported/recommended by Oracle.
Thanks,
Vishnu
Hi jc,
It appears a lock issue may have hung up your upgrade.
R12.2 Upgrade Driver Patch Hangs (Doc ID 2397870.1)
Regards,
Michael
Thanks Michael, Vishnu.
My issue is closer to this note > Upgrading To 12.2.0, Driver 10124646.drv, Failed Job On Apwhstsc.sql And Aphstrvn.sql (Doc ID 2360151.1)
Patch 10124646 fails on apwhstsc.sql
".. FAILED: file apwhstsc.sql on worker 12 for product ap username AP.
Start time for file is: Thu Feb 01 2018 14:19:19
sqlplus -s APPS/***** @/u01/oracle/app/prod/R12.2/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/app/prod/R12.2/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
Time is: Thu Feb 01 2018 14:19:37
FAILED: file aphstrvn.sql on worker 3 for product ap username AP.
..."
no formal cause of issue was confirmed
Client was able to successfully run the job by manually passing the application short name 'AP'
But there is no solution
Or is it also a locking issue?
Please help....
Kind regards,
