Re: Multiple instances with NT

Tony

statement should read

 CREATE CONTROLFILE reset DATABASE <my_new_sid_here>

not reuse.

Alex

Tony Adolph wrote in message <7laclf$e2p$1_at_nnrp1.deja.com>...
>Hello All,
>
>I am in the process of creating a second instance of a database that
>has been copied from another server. (Oracle 7.3.4)
>
>I need to change the new database name so that is does not conflict
>with the existing one. I have tried backing up the control file to
>trace and changing the "CREATE CONTROLFILE reuse DATABASE
><my_new_sid_here> ..." entry and also the entry in the pfile. But when
>I startup the SID I the following error:
>ORA-01103: database name 'name_of_source_db' in control file is not
>'new_name'
>
>I understand the error but how do I get round it? Do I have to create
>a new database then use backeded up control file to "re-create" my copy?
>
>Also (testing on another server), trying to start another instance
>where the name doesn't conflict but I am unable to connect internal. I
>have copied all of the datafiles and control files onto the new server
>and and added an entry to tnsnames.ora. I can tnsping my alias but
>when I try to connect internal I get:
>"ORA-12505: TNS:listener could not resolve SID given in connect
>descriptor"
>
>A pointer in the right direction would be appreciated.
>Thanks
>Tony
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 07:29:19 CDT