Oracle Installation and Patching in AIX for 9i R2

I had a strnage expereince today..We are setting up a Dataguard for one of our clientIt is on AIX 5.3 with Oracle 9.2.0.6Software provided by the clients.

I started the installation after doing all the prerwquisites checkIt started but it was prompting for JDK directory...i was confused for a while where the JDK is but somehow i managed to find the instalation under /user/java14

but what happened after that was even more childishOracle installation was successful but the relinkimg failed witht the error "unable to invoke target ctx....ins_rdbms.mk

I tried installing 3 times but failed then got the doubt about the Version of Oracle Software...as expected it was the Oracle9i for AIX 4.3 version....Now the client is downloading again...What to do...but new thing learned today

Day 2
Just to add on yesterday inputswhile i was patching the 9.2.0.6 around 99% of installation a windows was appearing saying that "cannot open or remove a file LIBNJNI.so which is currntly runnng ,"i tried 3-4 times

but at the end ..the reason i missed out step in the README.txt i checked the os process ps-ef...but no oracle process were runnningtheni executed /usr/sbin/slibclean which removes the libraires from Kernel and Memory if accessed bu the OSTHen the installation went smoothOne more new thing i learned today.

.in UNIX i cloned the production to a new server which is going to act as new production..I tried to mount the databasse but i was keep on getting the error cannot open the password file...but alter database open command opens the DB

but when i startup the DB again i had to issue alter database openthen i realised in UNIX the password file is case case sensisitve ORACLE_SID should match the password file like orapwSIDSilly stuff but i forgot ....Metalink helped

Recovering from Hotbackup

I am just posting the thing i have learned today while cloning the DB from Hotbackup

We had a Hotbackup which is a USER-MANAGED Backup from the production

The Database files were residing in E:drive and log files/Controlfile were placed D:Drive and E:Drive

We copied the Archived log generated after the backup was complted

I cloned in a different machine in E:Drive but i didnt had the D:Drive where the logfiles and controlfile members are.

3 log grouls
redo11.log(E:Drive)
redo12.log(E:Drive)
redo13.log(D:Drive)
control3.ctl(D:Drive)

The set is like this for all three groups

Now i started recovering from the hotbackup.

I started and mounted the Database
Since there is no D:Drive i had to drop the members in D:Drive
I dropped the Group1 memeber and Group 2 Member but when i tried to drop the group 3 memeber Oracle didnt allow to drop the group 3 memeber

So i decided to a recovery using abckup controlfile until cancel option
It was prompting the Archive log and i have successfully completed the Incomplete Media Recovery

now i try to open with Alter database open resetlogs

Since resetings the logs creating the redologs it tried to create the Group 3 member in D:Drive

I tried to clear the D:Drive log memeber but couldnt it
i treid clearing UNARCHINING option still of no use

Suddenly it thought of renaming the D:Drive log memeber to E:Drive and did successfuly

now i tried to open the resetlogs option

It opened.

Regards
Maran

Patching Oracle Software

Time and again and again we see people asking help in patching Oracle software

I will just briefly explain the procedure to Patch and Upgrade the database.

Patching invloves 2 steps sometimes it is a one step process only if there is no DB running on the version

1.Assume you have a Oracle software Installed(9.2.0.1)
2.No database has been created in this version so far.

Patching
Patching is nothing but Fixes and upgrading the binary with the latest bug fixes released by Oracle

1.Download the patchset from Metalink for the Oracle/Os Versions
2.Lauch the Oracel Universtll installer from the downloaded patch
3.It selects the Oracle Home and display the Oracle Home which will be Upgraded
4.If you have multiple homes Select the appropriate Software which needs to be upgraded.
5.IF no patch is required it will prompt a message that "No Patches will be installed"
6.If the Prequisties are over It will start installing/upgrading the ORacle binaries
7.On completion of installation the Software will be upgraded to the latest patchset.

The Database created after the PAtching will all be in the latest patch version(9.2.0.8)

On the Other hand if you want to the Patch on a software on which many databases are already running

This is 2 step process
1.Upgrading the binary
2.Upgrading the database

1.Upgrading the binary
a.Shutdown all the ORacel databases on that version(9.2.0.1)
b.Stop the services related to it.
c.Follow the steps mentioned in the above steps patching


Now the Oracle binary is upgraded and now we need to upgrade the DB
1.Start the DB in the STARTUp UPGRADE/START MIGRATE
2.This will upgrade the Oracle Database.
Look for errors if any.

Comments are welcome