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.
If you need to create websites that are functional and attractive, you can approach the Website Development Company In Delhi. We are the best designers in town and can help you with all aspects of the website. You do not want a website that takes several seconds to load. You want one that is up and running in a jiffy and that is what we do. We are the Best website designing company West Delhi has and we deliver just what you want.
ReplyDeleteWe create sites for business, pleasure, hobby, and social networking. We even make shopping sites for you to sell your goods. If you want the Best Web Designing Company In Delhi, get in touch with us now! You will be happy you did. Call us through the links given below.
EMAIL: support@websolutioncentre.com
TELEPHONE: +91-9891846187
Axure Rp Crack + Activation Code Full Version Free Download For Mac/Windows. Axure RP 8 License Key Important parts of the informatio Axure RP 10 Full Crack
ReplyDeleteMalwarebytes Keygen will give you better assurance against adware, spyware, and malware. This is an extremely helpful application. Malwarebytes Serial Key
ReplyDeleteExplore Anita Ehlers's board "Once The Trust Is Broken Quotes!" on Pinterest. See more ideas about inspirational quotes, life quotes, me quotes. Trust Break Quotes
ReplyDeleteStudioLine Photo Classic makes it easy to deal with extensive image collections.
ReplyDeletehttps://thepcsoft.com/studioline-photo-classic/