Re: newbie - renaming oracle server

From: Rotter Richard <rotter_at_aon.at>
Date: Tue, 18 Jan 2000 14:49:23 +0100
Message-ID: <38846f0c$0$22452@SSP1NO17.highway.telekom.at>

Hi,

If you want to chanche the name of an Oracle Instance, you have to create new controlfiles with the create controlfile - command! use the set database clause to give the new name. but - be careful!!!!
You also have make an resetlogs clause -> thats means, if your instance is running in archivemode, there is no way to recover the database with old archives. Be sure, you have backuped your instance before processing the resetlogs-Command. The Best way to create new controlfiles is:

1.) log on as system on your instance in sqlplus
2.) make the command: "alter system backup controlfile to trace"
3.) step 2 generates a complete create-script in a trace file. Cut and paste

the create-Controlfile-Command to a new file cre_control.sql

4.) Edit the cre_control.sql using "SET <new_instancename>" and "RESETLOGS"
5.) Shutdown your instance
6.) Make full Backup of your instance (be sure, the bakup is correct!!)
7.) move your old controlfiles to controlfile.sav
8.) start the svrmgrl-tool with connect internal
9.) start the cre_control.sql script -> it generates new Controlfiles
10.) alter database open resetlogs;
11.) Shutdown your database
12.) Make full backup of your database

13.) startup database
14.) change the listener.ora and tnsnames.ora-files

MFG
Rotter Richard
Oracle-DBA

News1 <news_at_circle.no> schrieb in im Newsbeitrag: LUVg4.592$WH2.36455_at_juliett.dax.net...
> Operating 7.3.4 on NT4 server. Company wants server (standalone
> server) to be renamed to comply with pc naming schedule. Apart
> from the tnslistener.ora file and updating the oracle clients is there
> anything else required to complete a successful oracle server rename?
> Suggestions, experiences etc welcome.
>
>
Received on Tue Jan 18 2000 - 07:49:23 CST