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
- 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 $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.
Got the SP2-1503 error today.
ReplyDeleteMultiple 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.
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
DeleteSpring 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
Regards
ReplyDeleteSridevi 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.
excellent...!!!
ReplyDeleteSelenium training in chennai
Industrial visit in chennai
Internship
Internships in bangalore for cse students 2019
Free internship in chennai for cse students
Network security projects for cse
Ccna course in chennai
Inplant training in chennai for cse
Inplant training for eee students
Kaashiv infotech chennai
ReplyDeleteThis is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.
Selenium Training in chennai | Selenium Training in anna nagar | Selenium Training in omr | Selenium Training in porur | Selenium Training in tambaram | Selenium Training in velachery