Monday, July 30, 2012

AutoConfig could not successfully execute the following scripts: afdbprf.sh and  adcrobj.sh  


Error During AutoConfig - 
[PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/oracle/product/11.2.0/db_1/appsutil/install/visr12_appsdbnode
      afdbprf.sh              INSTE8_PRF         1
  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/oracle/product/11.2.0/db_1/appsutil/install/visr12_appsdbnode
      adcrobj.sh              INSTE8_APPLY       1

[oracle@apps_rac01 visr12_apps_rac01]$ cd /u01/app/oracle/product/11.0/db_1/appsutil/scripts/visr12_apps_rac01
[oracle@apps_rac01 visr12_apps_rac01]$ adautocfg.sh 
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/11.0/db_1/appsutil/log/visr12_apps_rac01/07300646/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/app/oracle/product/11.0/db_1
        Classpath                   : :/u01/app/oracle/product/11.0/db_1/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/11.0/db_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/11.0/db_1/appsutil/java:/u01/app/oracle/product/11.0/db_1/jlib/netcfg.jar:/u01/app/oracle/product/11.0/db_1/jlib/ldapjclnt11.jar


        Using Context file          : /u01/app/oracle/product/11.0/db_1/appsutil/visr12_apps_rac01.xml


Context Value Management will now update the Context file
        Updating Context file...COMPLETED
        Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed with errors.

Work Around / Fix - 


-- When we runt he Auto Config it will try to recreate the listener.ora file so its advisable to keep the listener down --    -- during AutoConfig run
[oracle@apps_rac01 visr12_apps_rac01]$ ./addlnctl.sh stop visr12
Logfile: /u01/app/oracle/product/11.0/db_1/appsutil/log/visr12_apps_rac01/addlnctl.txt
You are running addlnctl.sh version 120.1.12010000.4
Shutting down listener process visr12 ...
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-JUL-2012 06:46:06
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps_rac01.localdomain)(PORT=1521)))
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/app/oracle/product/11.0/db_1/appsutil/log/visr12_apps_rac01/addlnctl.txt for more information ...  

-- Start a new session and make sure you don't set the env by running <context>.env file 
-- If you set the env then the Auto Config will fail
[oracle@apps_rac01 visr12_apps_rac01]$ sudo su - oracle
[oracle@apps_rac01 ~]$ cd /u01/app/oracle/product/11.0/db_1/appsutil/scripts/visr12_apps_rac01/
[oracle@apps_rac01 visr12_apps_rac01]$ ./adautocfg.sh 
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/11.0/db_1/appsutil/log/visr12_apps_rac01/07300647/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/app/oracle/product/11.0/db_1
        Classpath                   : :/u01/app/oracle/product/11.0/db_1/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/11.0/db_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/11.0/db_1/appsutil/java:/u01/app/oracle/product/11.0/db_1/jlib/netcfg.jar

        Using Context file          : /u01/app/oracle/product/11.0/db_1/appsutil/visr12_apps_rac01.xml

Context Value Management will now update the Context file
      Updating Context file...COMPLETED
       Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.

Now if you see, your DB Tier and listener will be up and running.

2 comments:

  1. Bro Same as tired but got adapter issue while running autoconfig

    ReplyDelete
  2. If you keep the listener down during autocongfig run. How it will connect to the DB ?

    ReplyDelete