Wednesday, January 26, 2011

SP2-1503: Unable to initialize Oracle call interface


SP2-1503: Unable to initialize Oracle call interface

Have encoutered below error after upgrading database to 11GR2 (11.2.0.1)
when we try to connect to sqlplus below error Occuered.

Error:

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


The issue is related to ORA_TZFILE env variable in 11GR2 this env variable is no longer needed.

  • In Oracle Database server to fix this issue Unset the env varaible ORA_TZFILE and try to connect.

  • In Oracle Applications Database to fix this issue Perform the below.

The ORA_TZFILE is set while at 11gR2 this should not be set.
 
The  $ORACLE_HOME/appsutil/template/ad8idbux.env is from the wrong version  (ad8idbux.env 120.8)
 
The wrong file includes the  following:
 
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
 
export  ORA_TZFILE

While for 11gr2 it should be:
 
if test "%s_database%" =  "db112" ;  then
 
ORA_TZFILE=""
 
else
 
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
 
fi
 
export  ORA_TZFILE

 
Execute autoconfig in Database Node and source the environment variable.

1 comment:

  1. Got the SP2-1503 error today.
    Multiple oracle homes caused this for me on Windows server. 11g and 10g. The 11g installer set the path in the Windows environment. I removed the Oracle home bins from the path in the Windows environment and set the bin path in the path in the shells that I use - specific to the Oracle home that I am using.

    ReplyDelete