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.