28 March 2012

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly


[oracle@ebus bin]$ ./adconfig.sh

adcrobj.sh started at Thu Mar  1 15:31:59 IST 2012

Parameters passed are : -nopromptmsg

The environment settings are as follows ...
       ORACLE_HOME : /disk2/PROD11/prod11db/11.2.0/dbhome_1
        ORACLE_SID : TEST
          TWO_TASK :
              PATH : /usr/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin:/disk2/PROD11/prod11db/11.2.0/dbhome_1/bin:/disk2/PROD11/prod11db/11.2.0/dbhome_1/OPatch:.
      Library Path : /disk2/PROD11/prod11db/11.2.0/dbhome_1/lib:/usr/X11R6/lib:/usr/openwin/lib:/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib:/usr/dt/lib:/disk2/PROD11/prod11db/11.2.0/dbhome_1/ctx/lib
SQLPLUS Executable : /disk2/PROD11/prod11db/11.2.0/dbhome_1/bin/sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.
[PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/install/TEST_ebus
      afdbprf.sh              INSTE8_PRF         1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/install/TEST_ebus
      adcrobj.sh              INSTE8_APPLY       1

complete with error..

Reference:-

Autoconfig On Db Tier Fails With Error - SP2-1503: Unable to initialize Oracle call interface [ID 1187616.1]

Solution :-
 
I applied below patch 7651166 – R12.TXK.B.delta.2 using adpatch in R12.1.1
 
[oracle@ebus bin]$ ./adconfig.sh
Enter the full path to the Context file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/TEST_ebus.xml
Enter the APPS user password:
The log file for this session is located at: /disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/log/TEST_ebus/03011750/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /disk2/PROD11/prod11db/11.2.0/dbhome_1
        Classpath                   : :/disk2/PROD11/prod11db/11.2.0/dbhome_1/jdbc/lib/ojdbc5.jar:/disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/java/xmlparserv2.jar:/disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/java:/disk2/PROD11/prod11db/11.2.0/dbhome_1/jlib/netcfg.jar:/disk2/PROD11/prod11db/11.2.0/dbhome_1/jlib/ldapjclnt11.jar

        Using Context file          : /disk2/PROD11/prod11db/11.2.0/dbhome_1/appsutil/TEST_ebus.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.

No comments: