| Upgrading oracle [message #278876] |
Tue, 06 November 2007 01:29  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
