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 (
when we try to connect to sqlplus below error Occuered.


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

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:
export  ORA_TZFILE

While for 11gr2 it should be:
if test "%s_database%" =  "db112" ;  then
export  ORA_TZFILE

Execute autoconfig in Database Node and source the environment variable.


  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.

    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

  2. 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.

    We 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.

    TELEPHONE: +91-9891846187

  3. 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

  4. Malwarebytes Keygen will give you better assurance against adware, spyware, and malware. This is an extremely helpful application. Malwarebytes Serial Key

  5. Explore 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