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.

5 comments:

  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
    Replies
    1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

      Spring Training in Chennai

      The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete