| Please help me to upgrade from 8i rel 8.1.7 to 9i rel 9.2 [message #176091] |
Tue, 06 June 2006 21:20  |
kumarvk
Messages: 214
Registered: July 2004
|
Senior Member |
|
|
Dear Experts,
Let me explain what I am doing before using the DBUA. I have copied the entire database files (after a proper shutdown) only (did not copy control files) from my Win 2003 server to my Win 2000 server.
Now my questions are
1. Should I need to copy the control files also?
2. Can I use the inituat1.ora from the 8i or should I need to make changes in the pfile?
3. What other steps should be taken into consideration before start using the DBUA utility?
4. Before using the DBUA utility should I need to startup the database in nomount mode from the DOS prompt or only the service need to be started?
If I had missed any steps please kindly guide me.
Kindly help me in this regard.
|
|
|
|
| Re: Please help me to upgrade from 8i rel 8.1.7 to 9i rel 9.2 [message #176117 is a reply to message #176091] |
Wed, 07 June 2006 01:24  |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
1)In Your situation, you must to perform cold backup. This mean that you must to stop database and copy all datafiles, controlfiles, logfiles.
2)By default many of parameters which have Oracle8i, in 10g must be present. If some of them is obsolete, this is mentioned in manuals for upgrade.
3)For upgrading see manual for upgrade. The most precise(however most hard for understanding  ) is manual from Oracle Documentation for Oracle10g.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
