I have explained about compiling invalid objects in my earlier post for the db objects like packages, functions, views etc.
There are some object types that has a little different approach, specific to object types.
I will start with indexes.
Friday, March 30, 2012
Tuesday, March 27, 2012
"SP2-1503: Unable to initialize Oracle call interface" in Oracle 11g
Below error appears when we try to log in to 11g Database using sqlplus.
The issue does not appear when I logged in to a separate session and set environment like ORACLE_HOME and ORACLE_SID manually.
$ sqlplus '/ as sysdba'
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
The issue does not appear when I logged in to a separate session and set environment like ORACLE_HOME and ORACLE_SID manually.
Subscribe to:
Posts (Atom)