Re: Renaming an Instance

Wim,

On the same lines here is a procedure that might help. I have modified it from the procedure that I have for relocating the instance from one machine to another with a different name. I think it can suit your purpose. Keep your eyes open.

                                                Tapan

1. edit confignys.ora
   1. set db_name = new instance name
   2. set db_domain = new server name (if applicable)
   3. change references to dbe to new instance in all paths
   4. change control files paths to new area -------->

2). edit initnys.ora

1. set ifile = new path (if applicable)
2. comments out the following lines (put # in 1st column) #job_queue_interval = 10 #job_queue_processes = 2 #job_queue_keep_connections = TRUE #db_writers = 4 -------->

3). edit the newdb.sql file to contain the correct file names and paths

1. change dbname to newdb on first line
2. modify file list to contain files from restored area
3. verify path and sizes of these files --------->

4). rename existing control files to new different ones.

5). svrmgrl

1. connect internal
2. startup nomount
3. @/p/nyseg/oracle/newdb.sql
4. alter database open resetlogs;
5. exit

SVRMGR> connect internal
Connected to an idle instance.
SVRMGR> startup nomount
ORACLE instance started.

SVRMGR> @pathname/newdb.sql

SVRMGR> alter database open resetlogs;

                                                    ---------->

6). edit listener.ora and add an entry for new instance

7). edit tnsnames.ora and add an entry for new instance 8). lsnrctl stop

9). lsnrctl start

                                Hope this helps
Chetan Wagle wrote:
>
> Never tried it on NT, but on UNIX it is possible if you rebuild the database
> controlfile.
>
> HTH,
> Chetan
>
> Wim Teuwens wrote in message <7sfavl$5hp$1_at_news3.Belgium.EU.net>...
> >Does anyone know if it's possible to rename an Oracle 7.3.4 Instance on
> >WinNT 4.0 ?
> >
> >Thanks
> >
> >wte_at_anaxis.be
> >
> >

Received on Fri Sep 24 1999 - 09:38:15 CDT