Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple instances with NT
In article <7laclf$e2p$1_at_nnrp1.deja.com>,
Tony Adolph <tonyadolph_at_my-deja.com> wrote:
> 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.
>
Hi Tony,
as to the first question:
there is conflict between the database name you have on the command line
and the db_name parameter in your init<sid>.ora.
Hth,
--
Sybrand Bakker, Oracle DBA
All standard disclaimers apply
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 07:15:57 CDT