Unable to initialize Oracle call interface

Today i installed a new Oracle Software 11.2.0.3 on our existing production database running 11.1.0.7
the problem is so simple but sometime we forgot the basic things..

PROBLEM : Unable to start sqlplus after installing new ORACLE_HOME

Note : this is my 2nd ORACLE HOME

 
ibd12lnx: CPHQA>sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Apr 8 02:51:37 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL> exit

Set my new ORACLE_HOME

 
ibd12lnx: CPHQA>export ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1

now trying the sqlplus

 
dbi12cnc: CPHQA>sqlplus /nolog
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
dbi12cnc: CPHQA>

SOLUTION:

 
export ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH 

Now it works

 
ibd12lnx: CPHQA>export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
ibd12lnx: CPHQA>sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 8 02:47:49 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s