DBMentors is a solution oriented group, started by a team of qualified and committed professionals with vast experience in IT industry. The team has in-depth technical and design expertise with highest standards of programming quality.

Tuesday, May 22, 2012

SP2-1503: Unable to initialize Oracle call interface

Oracle Error :: SP2-1503

Cause

Indicates a library used by SQL*Plus to communicate with the database failed to initialize correctly.Action
Check that the Oracle environment or registry entries are
consistent and correct. If using the SQL*Plus Instant Client make sure
the SQL*Plus and Oracle libraries are from the same release. Make sure
you have read access to the libraries.

If you are running Vista or Windows 2008 check if the user running the command has Administrative access. If
running on Vista/2008/Windows 7, select the .exe and use "Run as Administrator" option .

Unix/Linux
This problem may related to the $ORA_TZFILE environment variable in Oracle 11GR2 which is no longer needed.

The workaround is to unset the variable and then call sqlplus again

$unset ORA_TZFILE
$sqlplus "/ as sysdba"
sql>

If you use Oracle E-Business Suite 11i or R12 then you have to remove the environment variable ORA_TZFILE also from the database environment file.