Manual database upgrade to oracle 11g on windows

DBUA is what mostly used for for upgrade specially on windows. That is good and oracle recommended option. But for some reason I chose to do a manual upgrade on windows.

Starting with that I had database 10.2.0.3 running on windows server.

First of all I need to have all the details of current state of database. Below is what all I checked.

set ORACLE_SID=TJAIN

sqlplus ‘/ as sysdba’
SQL> show parameter pfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      G:\ORACLE\PRODUCT\10.2.0\DB_1\
                                                 DATABASE\SPFILETJAIN.ORA

Compile Database Objects - 2

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.

"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.

$ 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.