Issues - Patching - R12

Most Common Patching issues in Real time

Patch hung with Tablespace is full Found the error in worker log file below.



 Fixed the table space issue and restarted the failed job in adctrl 2nd option Patch session continued.

Patch session got hung in middle of the patch session. Checked the patch log and worker logs, no errors found Worker 1 got hung Tried to connect to the date base given the below error.

   

Shutdown and tried to start the database, but not able to start it with spfile.

Started the db with pfile and created spfile from pfile.

Bounced the DB and DB started with SPFILE.

Allocated the space SGA_MAX_SIZE to 25GB and SGA_TARGET to 12GB

The default value for PGA_AGGREGATE_TARGET is non zero. Oracle sets it’s value to 20% of the SGA or 10 MB, whichever is greater.

SQL> alter system set SGA_TARGET=12G scope=spfile;

System altered.

SQL> alter system set SGA_MAX_SIZE=25G scope=spfile;

System altered

SQL> alter system set PGA_AGGREGATE_TARGET =12G scope=spfile;

System altered

Bounce the DB to reflect the values.

================================

Jobs failed and adpatch unable to proceed further.

Worker log File showing as below

ERROR:

ORA-01017: invalid username/password; logon denied

Found the issue with the password.

Ran the script manually

sqlplus -s APPS/***** @/shared/12.2.5/esbx1/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/shared/12.2.5/esbx1/fs1/EBSapps/appl/pay/12.0.0/patch/115/sql/pyfkjpn.sql HR XX APPS_TS_INDEX

Skip the worker with 8^th hidden option in adctrl

Patch session continued from where it stopped.