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

Post a Comment

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 would created by
Post a Comment
Read more

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. Access your main web page https://<host.domain:port&
Post a Comment
Read more

R12.2 Adop Hangs And Does Nothing.

Issue is starting here, unable to connect AD Solution: ============ Login by root user and follow the below command: #hostname fc-pun-fusion01  --------------------------- <Enter the hostname in small letters> Note:- In my case, my server hostname was "FC-PUN-FUSION01" and I have change the same in "fc-pun-fusion01". [root@fc-pun-fusion01 ~]# hostname fc-pun-fusion01 [root@fc-pun-fusion01 ~]# Change the same in /etc/hosts file accordingly [root@fc-pun-fusion01 ~]# cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. ##127.0.0.1             FC-PUN-FUSION01 localhost.localdomain localhost 127.0.0.1               loopback localhost 10.34.156.132           fc-pun-fusion01.india.rapidigm.com fc-pun-fusion01 10.34.156.132           fc-pun-fusion01.india.rapidigm.com fc-pun-fusion01 ::1             localhost6.localdomain6 localhost6 10.34.156.133           FC-PU
Post a Comment
Read more