cancel
Showing results for 
Search instead for 
Did you mean: 

upgrade oracle 8i to 9i

SOLVED
Go to solution
DnD_1
Regular Advisor

upgrade oracle 8i to 9i

hi guys,

i have to upgrade our oracle 8i to 9i. basically there is nothing in our database, just 8i.

we also want to keep the config files, nothing has to change.

so how can i do that ? shall i just insert the cd, and click next next, and it will automatically upgrade to 9i ?

please guide...

thanks !!!
6 REPLIES
DnD_1
Regular Advisor

Re: upgrade oracle 8i to 9i

oh yeah, we using HP UX 11.11

Patrick Wallek
Honored Contributor

Re: upgrade oracle 8i to 9i

Have a read through the Oracle documentation that came with your CD's. The is some very documentation available to should give you plenty of details on the process you need to follow.
Yogeeraj_1
Honored Contributor
Solution

Re: upgrade oracle 8i to 9i

hi,

If there is nothing in the 8i database, it would be wiser to just remove the 8i database and do a fresh 9i database installation.

Concerning the config and other settings you can always apply them to the 9i database. If they supported of course.

Also, if you have enough resource, it would be better to go directly to Oracle 11g.

good luck!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
DnD_1
Regular Advisor

Re: upgrade oracle 8i to 9i

hi yogeeraj

how do i remove oracle 8i ? completely ?
Yogeeraj_1
Honored Contributor

Re: upgrade oracle 8i to 9i

>how do i remove oracle 8i ? completely ?
Launch the Installer, view the installed products from where you have the option to uninstall.

I dont have access to my servers right now so cannot confirm the exact steps.

Please give it a try and let us know how it goes.

good luck!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: upgrade oracle 8i to 9i

Hi,

I would suggest you to check what pre-installation task you need to perform before installing 9i on HP-UX (system patches, memory sizing and etc.)

9i installation guide you can find here:
http://www.oracle.com/technology/documentation/oracle9i.html

If you wish, you can keep 2 Oracle versions running on the same machine.
You can achieve it by changing the Oracle variables in oracle userâ s profile.

echo "Choose oracle version [9] or [8]"
read VAR
case $VAR in
9)
. /path/oracle9_variables.sh
;;
8)
. /path/oracle8-variables.sh
;;
*)
#default
. /path/oracle9_variables.sh
;;
esac

Regards,
Vadim