Thursday 9 May 2013

adoafmctl.sh fails after 12.1.3 Upgrade

Recently performed an Upgrade of :

1.Database from 11.2.0.2 to 11.2.0.3 and
2. Oracle R12 from 12.1.2 to 12.1.3.


While trying to start all services, adoafmctl.sh fails with below error :


Starting OPMN managed OAFM OC4J instance ...

adoafmctl.sh: exiting with status 152


And the log file says:

Error
--> Process (index=1,uid=457048498,pid=14483554)
time out while waiting for a managed process to start



Solution:


1. rm $ORA_CONFIG_HOME/10.1.3/opmn/logs/states/* 
Clear the TLD cache:

- stop all middle tier services

-Make sure there are not background unix processes 'ps -ef|grep applmgr'

- Delete/backup the file:

$COMMON_TOP/_TldCache


2. delete all .lock files from the below directory subtrees:

$INST_TOP/ora/10.1.3/j2ee/forms/persistence/forms_default_group_1/
$INST_TOP/ora/10.1.3/j2ee/oacore/persistence/oacore_default_group_1/
$INST_TOP/ora/10.1.3/j2ee/oafm/persistence/oafm_default_group_1/


Then Start all services.

Verify and change oc4jadmin password in Oracle R12

oc4jadmin password could become an issue when installing 10.1.3.5 Techstack software in Oracle 12.1.3 EBS. Its important to know that you are feeding the right oc4jadmin password.


How to verify:

Run the below command as applmgr user :


appmine> java -jar $IAS_ORACLE_HOME/j2ee/home/jazn.jar -checkpasswd jazn.com oc4jadmin -pw *****
Successful verification of user/password pair.

***** = oc4jadmin password


The message should be successful. If not the password can be changed in system-jazn-data.xml file:


1. Shutdown all opmn services :

cd $ADMIN_SCRIPTS_HOME
adstpall.sh / adopmnctl.sh stopall

2. cd $ORACLE_HOME/j2ee/home/config

Here ORACLE_HOME= Oracle Application server home, ie, 10.1.3 HOME
Take a backup of system-jazn-data.xml and edit the below content:



<user>
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<guid>93E5A2505D1511DEBF8E89BC12E10097</guid>
<description>OC4J Administrator</description>
<credentials>!newpassword</credentials>
</user>



Marked in bold is the details to be changed and that is the password. Note an ! mark has to prefixed with the password.


3. Start all opmn services.


Whenever autoconfig is run after this practice, the password changes to encrypted format.