Pages

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.
Posted by Naresh Miryala

6 comments:

  1. Tim KesslerSeptember 2, 2011 at 6:46 PM

    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
  2. Gurjeet SinghApril 22, 2022 at 3:28 PM

    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.

    EMAIL: support@websolutioncentre.com
    TELEPHONE: +91-9891846187

    ReplyDelete
  3. Back linkerAugust 29, 2022 at 10:59 AM

    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

    ReplyDelete
  4. Let2knowAugust 29, 2022 at 1:16 PM

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

    ReplyDelete
  5. Back linkerAugust 31, 2022 at 9:12 PM

    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

    ReplyDelete
  6. hubertApril 11, 2023 at 4:39 PM

    StudioLine Photo Classic makes it easy to deal with extensive image collections.
    https://thepcsoft.com/studioline-photo-classic/

    ReplyDelete

Subscribe to: Post Comments (Atom)