Pages

Wednesday, April 11, 2012

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

Friday, March 30, 2012

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.

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.

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