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...

Installation Single Sign-On (Oracle Internet Directory) & Oracle Web Discoverer 10g on solaris 10 configured with E-Business Suit R12

Discoverer Configuration Step 1- Check OS Prerequisite on erpdisc (erpdisc is discoverer Node) Hostname -hostname OSVERSION - uname -r Maintenance level - /etc/release RAM - /usr/sbin/prtconf | grep -i memory SWAP - swap -s Tmp - df -k /tmp Kernel Parameter- /etc/system JDK & JRE - /usr/bin/java -version Ulimit- ulimit -a Hostname settings- /etc/hosts OS 64 bit or 32 bit - /bin/isainfo -kv File Descriptor- /etc/system set rlim_fd_max=65536 Oracle OS Group - /etc/group Oracle OS Discoverer User – mkuser -disc OS Packages- pkginfo <package name> OS Patches- showrev -p <patch_name> Software Requirement – which ar which ld which make which X Display Server Step 2 – Make changes in hosts file root@erpdisc # more /etc/hosts # # Internet host table # 127.0.0.1        localhost.localdomain    localhost xxx.xx.xx.xx  ...

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...