Re: Multiple instances with NT

OOPS!!! set not reset - or possibly Sybrand's answer as well !!

Alex

Alex wrote in message <7lae7g$152$1_at_taliesin.netcom.net.uk>...
>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:32:27 CDT