adop failing ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)

Error:

While running 

 Checking for existing adop sessions.

    No pending session exists.

    Starting new adop session.

    [UNEXPECTED]Unable to find appltop_id for host ebsappprd2 in database


 Statement Handler Error Code: 20010

 Statement Handler Error Message: ORA-20010: No admin node found. Review and correct your configuration,

                               contacting Oracle Support as needed.

ORA-06512: at "APPS.AD_ZD_ADOP", line 3028

ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)

 Reference of statement-handler is valid, not attempting database reconnect.

 Failed to execute SQL statement:

      begin

         ad_zd_adop.INSERT_ADD_NODE_RECORDS;

        end;


 Error Message:

ORA-20010: No admin node found. Review and correct your configuration,

                               contacting Oracle Support as needed.

ORA-06512: at "APPS.AD_ZD_ADOP", line 3028

ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)    [UNEXPECTED]Error adding information for new node

    [UNEXPECTED]Unrecoverable error occurred. Exiting current adop session.


Cause:
dbhost details in database context file is in UPPERCASE 

Fix:

update dbhost details in lower case and run config.

 cd $ORACLE_HOME/appsutil
ls -lrt *.xml*
-rw-r--r-- 1 oracle oinstall 16646 Dec 17 01:09 R12PRD_ebsdbprod.xml_b4PSRpatch
-rw-r--r-- 1 oracle oinstall 16646 Jan 12 00:01 R12PRD_ebsdbprod.xml
 diff R12PRD_ebsdbprod.xml R12PRD_ebsdbprod.xml_b4PSRpatch

<          <dbhost oa_var="s_dbhost">ebsdbprod</dbhost>
---
>          <dbhost oa_var="s_dbhost">EBSDBPROD</dbhost>


run autoconfig

Ref:
Patch Fails With Error "Unable to find appltop_id for host <hostname> in database" (Doc ID 2611499.1)

Comments

Popular posts from this blog

adop UNEXPECTED Unable to find appltop_id for host ebsapp2 in database