| Oracle database migration from oracle 8.1.5 to oracle 9i [message #63915] |
Wed, 24 November 2004 20:25  |
rishikesh
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
Hello all DBAs out here ,
I have one problem for which I need your help.
I have Win 2000 Prof. OS.
I initially installed Oracle 8.1.5, created one database on it.
Then I took a cold backup of the database.
Now I have unistalled Oracle 8.1.5 as I needed to install Oracle 9.1.
While Uninstalling Oracle 8.1.5 , I not only Deinstalled it thru the universal Installer option, but also removed the regisrty enteries related to oracle like all the folders name E:oracle.... na dc:program filesoracle.. etc.
Now I installed oracle 9.1 . It has not given me any kind of error while installing oracle 9.1.
On this new install , I restored all the backep up files of Oracle 8.1.5 database(like redologs, control files, parameter file,archive logs, password file., data files).
Then I did the following procedure ....
SQL> connect sys/sysnameisash@orcl as sysdba;
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.
Total System Global Area 409950712 bytes
Fixed Size 453112 bytes
Variable Size 109051904 bytes
Database Buffers 300138496 bytes
Redo Buffers 307200 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
please help me as my problem is I want to migrate the oracle 8.1.5 databse to oracle 9.1 i.e wanna restore the database of oracle 8.1.5 to oracle 9.1
Thank you
Rishi<!-- / message -->
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
