Re: Two instances with same SID in a same machine

From: Brian Lesker | Impulse Info Systems <impulse-info.nl_at_brian>
Date: Fri, 27 Aug 2004 11:06:49 +0200
Message-ID: <412ef92f$0$42417$e4fe514c@news.xs4all.nl>

Whould be smarter to rename the instance.

Like:

1. svrmgrl
2. connect internal
3. startup mount pfile=location
4. alter database backup controlfile to trace resetlogs
5. find the trace file created (.trc) and open it
6. Change the following line:
	CREATE CONTROLFILE REUSE DATABASE "oldname" RESETLOGS
    to
	CREATE CONTROLFILE REUSE set DATABASE "newname" RESETLOGS

Save the file like ccf.sql

7. connect internal
8. startup nomount pfile=location
9. run ccf.sql (@ccf.sql)

10. when needed, run alter database backup controlfile to trace resetlogs

And ready, your database has a new sid.

Sybrand Bakker schreef:

> On 27 Aug 2004 01:33:43 -0700, ilaletin_at_usa.net (Igor Laletin) wrote:
>
>

>>What if two people (listeners) called two different Marcelo's
>>(instances with the same SID) in two different rooms (oracle homes)?
>>
>>Cheers,
>>Igor

>
>
> It will be an administration nightmare wouldn't it? And sooner or
> later account 1 will screw up the database located in account 2.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Aug 27 2004 - 04:06:49 CDT