Re: two databases with same db_name?

Hello,

I'm working on windows NT.

I think that you can do this because :
* the listener/tnsnames/OracleService process the Instance Name ( ORACLE_SID )
* and in the init<Instance> / and when you CREATE DATABASE, you process the db_name

OracleService open and read the init<Instance> file to open the database.

So we can not have 2 same OracleServiceSID (WNT) or Background Process SID (Unix Process)
But, each instance process his database : datafiles, log files, control files.

PS 1 : we don't talk about Parallel Server, and each instance has her own files.

PS 2 : send me a mail to kown if your job has succeed

Regards

<susana73_at_hotmail.com> a écrit dans le message news: 91tv50$tjj$1_at_nnrp1.deja.com...
> Hi,
>
> I like to know if I can have two databases(instances) with the same
> db_name on the same server? They have different ORACIE_SID(initSID.ora)
> of course.
>
> The reason I want to do this is I am rebuilding the entire instance and
> they will be existing together at least for a week or so.
>
> Thanks,
> Susan
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 21 2000 - 17:02:18 CST