SP2-1503: Unable to initialize Oracle call interface (same fashion 10g and 11g) solution 1. The error SP2-1503: Unable to initialize Oracle call interfaceSP2-0152: ORACLE may not be functioning properly 2 is reported when sqlplus/as sysdba is executed in a 11g environment. Analysis (1) After 10 Gb is installed on the same AIX machine, an environment variable of 11 GB is configured as follows (note the red part) export ORACLE_BASE =/opt/oracle export ORACLE_HOME =/oracle/product/11.2.0/export ORA_DB =/oracle/product/11.2.0/dbs export ORACLE_SID = ora11g export ORACLE_TERM = vt100 export ORA_NLS33 =/ oracle/product/11.2.0/ocommon/nls/admin/dataexport PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin :.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~ (In red) export ORACLE_HOME =/oracle/product/11.2.0export BRARY_PATH = $ ORACLE_HOME/lib: $ LD_LIBRARY_PATH (2) it is suspected that 10 Gb of data is still called when sqlplus is executed, as a result, 10 Gb sqlplus is incompatible with other 11g components. $ echo $ PATH/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11: /sbin:/usr/java5/jre/bin:/usr/java5/bin:/home/oracle/bin:/opt/oracle/product/10.1.0/bin: /home/oracle/bin:/oracle/product/11.2.0 // bin :. :/home/oracle/bin:/oracle/product/11.2.0 // bin :. sure enough, 11 GB The bin of is 10 Gb later. Change the value of PATH to export PATH = $ ORACLE_HOME/bin: $ PATH: $ HOME/bin :. $ echo $ PATH/oracle/product/11.2.0 // bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11: /sbin:/usr/java5/jre/bin:/usr/java5/bin:/home/oracle/bin:/opt/oracle/product/10.1.0/bin: /home/oracle/bin:/oracle/product/11.2.0 // bin :. :/home/oracle/bin :. 3. Verification passed $ sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Fri May 24 16:27:29 2013 Copyright (c) 1982,200 9, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>