Multiple instances with NT

From: Tony Adolph <tonyadolph_at_my-deja.com>
Date: Tue, 29 Jun 1999 12:03:01 GMT
Message-ID: <7laclf$e2p$1@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:03:01 CDT