Thursday, January 16, 2014

Change Oracle 9i DB From one server to another server on Windows

First for new server Install Oracle 9i Base,then required Patch and do not create the Database.
Now we have an old server with db running and new server with oracle binary installed.
First we need to Down the DB using services
Down  OracleDatabase<SID>,OracleListner<SID>
ex:
             If DB name is ORCL then 
ORACLESERVICEORCL & ORACLELISTNERORCL

Now DB is down and users can not work.

Now Copy D:\Oracle\oradata folder to new Server's Oracle smiler location
Then Copy D:\Oracle\product\9.0.2\db_home\database folder to new Server's smiler location.

Then you have to export windows registry of Oracle
goto -->services-->registry-->
export it as a file.

Then Go to Oracle_Home/Network/admin/ Then copy Listner.ora & Tnsnames.ora file to the similer location of the new Oracle Server.

RUN  lsnrctl start to start the listner.


Then go to new Oracle Server and open CMD
type oradim -NEW
-SRVC ORACLESERVICE<SID> -- ORACLESERVICEORCL
-SYSPWD PASSWORD --PASSWORD
-STARTMODE AUTO
-PFILE :D\ Oracle\product\9.0.2\db_home\database\initORCL.ora
-SHUTMODE immediate

then press ENTER

then STARTUP LISTNER
STARTUP DB
THEN BOOT PC

Then Change IP's to use new DB server.

Thank you!

No comments:

Post a Comment