Home » RDBMS Server » Server Administration » Upgrading oracle
Upgrading oracle [message #278876] Tue, 06 November 2007 01:29 Go to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi ,

On our server, there are oracle databases ,some are having version 9.2.1.0 & one database is having version 8.1.7.
/oracle/app/oracle/product/8.1.7

/oracle/app/oracle/product/9.2

We want to upgrade all databases to 9.2.0.8.
We were thinking of creating different mount point, we will install 9.2.0.1 there & upgrade it to 9.2.0.8. Then upgrade other databases to 9.2.0.8.
Is it right method to do??

To upgrade 8i to 9i database, are these steps are sufficient?
update environment variable
- ORACLE_HOME
- PATH
- ORA_NLS33
- ORACLE_BASE
- LD_LIBRARY_PATH
- ORACLE_PATH

-> Run Upgrade script : cd $ORACLE_HOME/rdbms/admin
Sqlplus /as sysdba
startup restrict or startup migrate
@u0801070.sql or u0900010.sql
-> Run @utlrp
-> Shutdown immediate
-> Modify Listner.ora with new ORACLE_HOME

Thanks
Re: Upgrading oracle [message #278879 is a reply to message #278876] Tue, 06 November 2007 01:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

for upgrade 9.2 version.
you have to apply latest patchset for version 9ir2. and latest patchset is "9.2.0.8" patchset.
then after if you want to apply critical patch update "cpu" then check metalink for latest cpu patch for 9.2.0.8 patchset.

How to apply patchset or cpu patch read README.txt file which comes with patchset.

for upgrade 8.1.7 version.
Direct upgrade is supported from 8.1.7 to 9ir2.

Yes you step is correct.but also go through below link
http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/upgrade.htm#1009200


Regards
Mohammed Taj
Previous Topic: pfile or spfile
Next Topic: License high water mark
Goto Forum:
  


Current Time: Sun Dec 04 18:35:06 CST 2016

Total time taken to generate the page: 0.10748 seconds