Skip to main content

Scenario-Patch fails because of missing prerequisite

Solution:
======
Adpatch is running and fails on one of the workers.To fix this worker and continue with
the patch installation, a new patch (Prerequisite) needs to be applied.
Considering that only 1 adpatch session can run on an instance at any given time,how can
a patch be applied when adpatch is already running?

Step 1: Using the adctrl utility, shutdown the workers.
a. adctrl
b. Select option 3 ” Tell worker to shutdown/quit”

Step 2: Backup the FND_INSTALL_PROCESSES table which is owned by the APPS schema.
a. sqlplus apps/ <apps_password>
b. create table fnd_install_processes_back as select * from fnd_install_processes;
c. The 2 tables should have the same number of records.
Select count(*) from fnd_install_processes_back;
Select count(*) from fnd_install_processes;

Step 3: Backup the AD_DEFERRED_JOBS table.
a. sqlplus apps/<apps_password>
b. create table AD_DEFERRED_JOBS_back as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.

Select count(*) from AD_DEFERRED_JOBS_back;
Select count(*) from AD_DEFERRED_JOBS;

Step 4: Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
At this point, the adpatch session should have ended and the cursor should be back at
the unix prompt.
a. cd $APPL_TOP/admin/
b. mv restart restart_back
c. mkdir restart

Step 5: Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus apps/ b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;

Step 6: Apply the new patch (The Prerequisite)

Step 7: Restore the .rf9 files located in $APPL_TOP/admin//restart_back directory.
a. cd $APPL_TOP/admin/
b. mv restart restart_ c. mv restart_back restart
 
 
Step 8: Retore the FND_INSTALL_PROCESSES table, which is owned by the APPS schema.

 a. sqlplus apps/ <apps_password>
b. create table fnd_install_processes as select * from fnd_install_processes_back;
c. The 2 tables should have the same number of records.
Select count(*) from fnd_install_processes;
Select count(*) from fnd_install_processes_back;


Step 9: Restore the AD_DEFERRED_JOBS table.

 a. sqlplus apps/ <apps_password>
b. create table AD_DEFERRED_JOBS as select * from AD_DEFERRED_JOBS_back;
c. The 2 tables should have the same number of records.
Select count(*) from AD_DEFERRED_JOBS;
Select count(*) from AD_DEFERRED_JOBS_back;


Step 10: Re-create synonyms

 a. sqlplus apps/<apps_password>
b. create synonym AD_DEFERRED_JOBS for APPS.AD_DEFERRED_JOBS.
c. create synonym FND_INSTALL_PROCESSES for APPS.FND_INSTALL_PROCESSES;

Step 11: Start adpatch, it will resume where it stopped previously.

:)

Comments

Popular posts from this blog

[INS-06001] Failed to perform operation due to internal driver error (During installation of RAC 11g)

Solution: root@NFSP70DB # cat /tmp/OraInstall2013-03-05_01-43-51PM/sshsetup3_2013-03-05_01-43-51PM.log INFO: Environment Variables: INFO:   ORACLE_HOME = INFO:   PATH = /usr/bin:/usr/ccs/bin:/usr/bin::/oracle/dump/install INFO:   CLASSPATH = INFO: Username:grid INFO: Lock Retry Count 120 INFO: Lock Sleep Time 30000 INFO: Home Dir /export/home/grid INFO: Lock Location : /export/home/grid/.ssh/lock INFO: Trying to get Lock .... INFO: Lock Acquired INFO: LIBRARY_LOC = /tmp/OraInstall2013-03-05_01-43-51PM/oui/lib/solaris INFO: Validating remote binaries.. INFO: [NFSP70DB] INFO: /bin/bash -c '/bin/true' INFO: Exit-status: 0 INFO: Error: INFO: INFO: INFO: [NFSP70DB] INFO: /bin/bash -c 'if [[ -f /usr/local/etc/ssh_host_rsa_key.pub ]] ; then exit 0; else exit 1; fi' INFO: Exit-status: 0 INFO: Error: INFO: INFO: INFO: An error occured which will cause the program to abort. Refer to latest Log file that was supplied while running the program. The Log file woul...

lsnrctl: error while loading shared libraries: /lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

Problem: After installing Oracle E-Business Suit or after installing Oracle database 11.x.xx.xx Software on OEL 5.x Server, trying to connect the database "sqlplus /nolog" or trying to start the lsnrctl, getting the below error message : case1: command : sqlplus /nolog Error: "sqlplus: error while loading shared libraries: <ORACLE_HOME>/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied" case 2: command : lsnrctl start <SID_NAME> Error: lsnrctl: error while loading shared libraries: <ORACLE_HOME> /lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied Cause: According to Metalink Note:  454196.1  -  libnnz11.so: cannot restore segment prot after reloc: Permission denied and ./sqlplus: error on libnnz11.so: cannot restore segment prot after reloc [ID 454196.1] , it's SELinux causing this problem. Solution: Disable SELinux Switch SELinux ...

Configuration workflow mailer on R12 (Mailer server working in SSL and Application running without SSL)

Steps: ---------------------- In order to Configure Workflow Java Mailer with IMAP and SMTP email servers SSL enabled, need to perform the below steps 1. Export the Certificate from the Email server.     2. Create a keystore on the Concurrent Manager Tire. Import the certificate to keystore     3. Configure the Mailer to work with IMAPSSL / SMTPSSL.     4. Steps for Debugging the Mailer.     5. R12.1.3 feature - Mailer Authentication     Protocol: SMTP/SSL Port : 465 Protocol: IMAP/SSL Port : 993 1. Export the Certificate from the Email server.   In order to be able to establish a Secure communication channel, the certificate from the Email Server (issued by a Certification Authority) needs to be imported on the Concurrent Manager Tire. The email server certificate issued by a trusted Certification Authority (i.e. Verisign), can be obtain from the System Administrator or downloaded by following the below steps A. A...