Sunday, March 4, 2012

Issue on DB Autoconfig : Error details >> txkcreateACL.sh: exiting with status 1 >> ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226

********************

Instance Details:

********************

Apps : 12.1.2

DB : 11.1.0.7

Activity : CPU Patching Jan'12 & Autoconfig.

Issue: DB Autoconfig failed with below error ...

Error details extracted from Log file :

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution. Errors are grouped by directory and phase.

The report format is:

[APPLY PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /kirang/oracle/product/111/appsutil/install/KIRANG_ramubro

txkcreateACL.sh INSTE8_APPLY 1

AutoConfig is exiting with status 1

Exact Error details during execution of script "txkcreateACL.sh"

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Mar 4 01:24:33 2012

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected.

Checking for existence of the ACL ....

No ACL exists for this, creating a new one ....

DECLARE

*

ERROR at line 1:

ORA-31003: Parent /sys/acls/ already contains child entry OracleEBS.xml

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226

ORA-06512: at line 36

ORA-01403: no data found

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

txkcreateACL.sh: exiting with status 1

Upon search found related Note : 1328458.1

Solution : Followed steps as per the note and executed Autoconfig on DB Node.

1. Execute the below PL/SQL block to drop the existing OracleEBS ACL :

sqlplus "/as sysdba"

BEGIN

DBMS_NETWORK_ACL_ADMIN.drop_acl (acl => 'OracleEBS.xml');

commit;

end;

2. Run autoconfig on DB Node again..

cd $ORACLE_HOME/appsutil/kirang

adautocfg.sh

Thanks

Kiran Ginni

Thursday, February 9, 2012

Issue >> ERROR : The ias home "" is not registered in the inventory

Apps : 11.5.10.2 (One Node)
DB : 10.2.0.4 64bit (One Node)
Activity : Jan'12 CPU patching on IAS Oracle Home
Patch to be applied : 5700129



Issue : While applying CPU patching we faced issue. Extracted few lines which are related to the issue.

Executing command : grep /kirang/product/iAS /kirang/product/oraInventory/ContentsXML/inventory.xml | wc -l
Command result : 0
ERROR : The ias home "" is not registered in the inventory at /kirang/product/oraInventory
ERROR : The file /kirang/product/oraInventory/ContentsXML/inventory.xml should have an entry for


Observed the "/kirang/product/oraInventory/ContentsXML/inventory.xml" and found that it has Development entries



Cause of the Issue :
++++++++++++

This customer having DEV,TEST instances along with Productions. There has been a refresh from DEV to Test and left some DEV traces on Test.
"inventory.xml" is one of the file which still having Dev Instance entries.


Since our work is on Test and its unable to map the $IAS_ORACLE_HOME.


Solution :
+++++++++

1) Take backup of "/kirang/product/oraInventory/ContentsXML/inventory.xml"

2) Change the Dev entries to Test

changed entries from Dev to Test...
rwxr-xr-x 1 apkirang aakirang 399 Feb 9 13:45 /kirang/product/oraInventory/ContentsXML/inventory.xml_bkp
-rwxrwxrwx 1 apkirang aakirang 399 Feb 9 13:45 /kirang/product/oraInventory/ContentsXML/inventory.xml
[AMD64] apkirang@kiranginni > diff /kirang/product/oraInventory/ContentsXML/inventory.xml /kirang/product/oraInventory/ContentsXML/inventory.xml_bkp
10c10
<
---
>
[AMD64] apkirang@kiranginni >




Thanks
Kiran G

Sunday, September 11, 2011

Hidden Options helpful while bouncing OPMN/Apache services in R12.

**************************
Apps : 12.1.3
DB : 11.2.0.4
Activity : Apache bounce after Profile option Change.
**************************

Requirement:

Customer sometimes asks to bounce Apache services when they change any profile options or any configurations done in their regular activities and requested for Apache bounce to get these new changes reflected.

a) Perform Health checks related to Apache

b) We can bring down all the Apache related services using below command “stopall”. By default this is not mentioned in its help. But can be used to quickly bring down and bring back.

Detailed execution is given below.

What is meant by Hidden option of “stopall”?

$ adapcctl.sh

You are running adapcctl.sh version 120.7.12010000.2

adapcctl.sh: too few arguments specified.

adapcctl.sh {start|stop|status}

Note: Here you cannot see “stopall” option . But still we can utilize it to quickly bring down Apache related services..

>> Stopping all the Apache Services using “Stopall” command:

$ adapcctl.sh stopall

You are running adapcctl.sh version 120.7.12010000.2

opmnctl: stopping opmn and all managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /ramug/mtlog/KIRANG_jagannayak09/logs/appl/admin/log/adapcctl.txt for more information ...

>> Starting all the Apache Services using below command:

$ adapcctl.sh startall

You are running adapcctl.sh version 120.7.12010000.2

opmnctl: starting opmn and all managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /ramug/mtlog/KIRANG_jagannayak09/logs/appl/admin/log/adapcctl.txt for more information ...

Friday, September 9, 2011

Forms.ear File Deploying issues...

**********************************************************

Some issues during Deploying forms.ear file during CPU patching in R12.

**********************************************************

Application: 12.1.3

Database : Release 11.2.0.2.0 Production on Fri Sep 9 10:16:46 2011

Activity : 11.2.0.2 UPgrade & 12.1.3 Upgrade.

Description:

Actual issue occured in CPU patching for Oct'10.

Deploy Forms 10.1.2 .ear files on EBSO R12 instance

Script to deploy :

perl $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=forms -runautoconfig=No -oc4jpass=xxxxxxx

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /ramuG/mtlog/RAMUG_kiranginni01/logs/appl/rgf/TXK/txkCfgOC4JApp_Fri_Sep_9_03_37_07_2011.log

Program : /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Fri Sep 9 03:37:07 2011

*** Log File = /ramuG/mtlog/RAMUG_kiranginni01/logs/appl/rgf/TXK/txkCfgOC4JApp_Fri_Sep_9_03_37_07_2011.log

Errors encountered running /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl

*******FATAL ERROR*******

PROGRAM : /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl(/ramuG/applmgr/1200/fnd/12.0.0/bin/txkrun.pl)

TIME : Fri Sep 9 03:37:09 2011

FUNCTION: (eval) [ Level 1 ]

ERRORMSG: Invalid OC4J password for : forms

Used OC4J password as welcome and it didn't worked....

Need to follow below steps to get reset to temporary value ( ) and proceed with script execution:

Steps :

a)

Back up the original system-jazn-data.xml file

cp -p $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml.ori

b) Change oc4jadmin password in file $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml for oc4jadmin user in credentials line as below:

old example lines:

OC4J Administrator

{903}AhyuIQ23dQEuEVA0Mv5B65CKXjWcC4/a

new lines:

OC4J Administrator

!welcome

The "Oc4j Instance password" has now become "welcome" with the above change.

c) Post-deployment step:

Reverting the value back to normal:

cp -p $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml.ori $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml

Step a ==> Done.

Step b ==> Done.

Deployment step:

perl $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=forms -runautoconfig=No -oc4jpass=

Here : = welcome

Terminal O/p as follows :

Issue 2 : >>

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /ramuG/mtlog/RAMUG_kiranginni01/logs/appl/rgf/TXK/txkCfgOC4JApp_Fri_Sep_9_04_58_37_2011.log

Program : /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Fri Sep 9 04:58:37 2011

*** Log File = /ramuG/mtlog/RAMUG_kiranginni01/logs/appl/rgf/TXK/txkCfgOC4JApp_Fri_Sep_9_04_58_37_2011.log

*****************************************************

Required values for starting OC4J instance "forms":

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

s_formsstatus = enabled

s_forms_nprocs = 1 (value should be greater than 0)

Existing values from the context file:

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

s_formsstatus = enabled

s_forms_nprocs = 2

----------------------------------------------

*** Values for context variables are VALID ***

----------------------------------------------

*****************************************************

Stopping all OPMN processes.

OPMN stopped.

Errors encountered running /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl

*******FATAL ERROR*******

PROGRAM : /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl(/ramuG/applmgr/1200/fnd/12.0.0/bin/txkrun.pl)

TIME : Fri Sep 9 04:58:40 2011

FUNCTION: TXK::Process::run [ Level 3 ]

MESSAGES:

Command error: = 38400, = /ramuG/product/1013/opmn/bin/opmnctl startproc instancename=forms

STACK TRACE

TXK::Error::abort('TXK::Error','HASH(0x9c242bc)') called at /ramuG/applmgr/1200/au/12.0.0/perl/TXK/Common.pm line 299

TXK::Common::doError('TXK::Process=HASH(0xa4d4a70)','Command error: = 38400, = /ramuG/product/1013...','undef') called at /ramuG/applmgr/1200/au/12.0.0/perl/TXK/Common.pm line 314

TXK::Common::setError('TXK::Process=HASH(0xa4d4a70)','Command error: = 38400, = /ramuG/product/1013...') called at /ramuG/applmgr/1200/au/12.0.0/perl/TXK/Process.pm line 449

TXK::Process::run('TXK::Process=HASH(0xa4d4a70)','HASH(0xa387b30)') called at /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl line 1587

TXK::RunScript::execOPMNControl('HASH(0xa5715e0)') called at /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl line 606

require /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl called at /ramuG/applmgr/1200/au/12.0.0/perl/TXK/RunScript.pm line 105

TXK::RunScript::require('TXK::RunScript','/ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl') called at /ramuG/applmgr/1200/au/12.0.0/perl/TXK/Script.pm line 177

eval {...} called at /ramuG/applmgr/1200/au/12.0.0/perl/TXK/Script.pm line 177

TXK::Script::run('TXK::Script=HASH(0xa3ad6d8)','/ramuG/mtlog/RAMUG_kiranginni01/logs/appl/rgf/TXK','/ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl') called at /ramuG/applmgr/1200/fnd/12.0.0/bin/txkrun.pl line 174

$

Getting this Error

Upon Investigation found Note :

$FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws Fails with Fatal Error forms-c4ws Already Exists (Doc ID 1165653.1)

Implementing the solution:

1. To get the /txkDeployForms-c4ws.pl to deploy, rename the file that already exists and run again.

Move the current deployment:

Example:

mv /devapps2/appldev/DPHUB/apps/tech_st/10.1.3/j2ee/forms-c4ws /devapps2/appldev/DPHUB/apps/tech_st/10.1.3/j2ee/forms-c4ws.ori

In our case :

$INST_TOP/ora/10.1.3/j2ee/forms-c4ws is moved and ran below script again :

perl $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=forms -runautoconfig=No -oc4jpass=welcome

*****************************************************

Required values for starting OC4J instance "forms":

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

s_formsstatus = enabled

s_forms_nprocs = 1 (value should be greater than 0)

Existing values from the context file:

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

s_formsstatus = enabled

s_forms_nprocs = 2

----------------------------------------------

*** Values for context variables are VALID ***

----------------------------------------------

*****************************************************

Stopping all OPMN processes.

OPMN stopped.

OPMN started.

Deplolying Application : "forms" onto OC4J instance: "forms"

Application deployed successfully.

Stopping and starting OC4J instances.

Started OC4J instances.

Binding webApp : "forms" with webmodule : "formsweb" for OC4J instance: "forms"

Web application bound successfully.

Stopping OPMN.

OPMN stopped.

Program : /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl completed @ Fri Sep 9 05:06:48 2011

End of /ramuG/applmgr/1200/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl : No Errors encountered

Now, Script successfully deployed…

Now reverting the copied script back to get original Password (This is must for security Concerns)....

c) Post-deployment step: ==> Done.

Reverting the value back to normal:

cp -p $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml.ori $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml

Thread 2:- >>>

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

In some cases we face issue 3 if "s_formsstatus" is in DISABLED status in $CONTEXT_FILE.

Fix:

a) Take a backup of your $CONTEXT_FILE

b) Modify s_formsstatus to ENABLED

c) Run check Autoconfig : adchkcfg.sh and resolve any differences to preserve your customizations

d) Run Autoconfig to get it populated in the scripts.

e) Now run Deployment script

f) Revert s_formsstatus to DISABLED again (Original value)

g) Run Autoconfig to get it populated in the Scripts.

Thread 3:- >>

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

During check config we had issue that this is hanging. Script hanged after generating the differences.

Solution: you can ignore by pressing CTRL + C and utilize the generated differences to preserve customizations.

Note : once all the above procedure is done and autoconfig is successfully completed, you can see that this bug is rectified either. You can now verify that by running adchkcfg.sh again and see it completing successfully without hanging this time.

Thanks

Kiran Ginni