Re: Relationship between SID and Database name

From: <pierre_gilles_at_my-deja.com>
Date: Thu, 07 Oct 1999 09:02:33 GMT
Message-ID: <7thnj6$bbm$1@nnrp1.deja.com>

In article <7th07d$r9q$1_at_nnrp1.deja.com>, Wesley <wesleyto_at_my-deja.com> wrote:
> Hi,
>
> Could anyone tell me the Relationship between SID and Database
> name?
>
> TIA.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

The Database name is the name of the database (!) which is declared in your init.ora (db_name parameter). This name is referenced in all your controlfiles : that the physical name.

The SID is an alias for the instance you mount when you start up the database, it can be different of db_name parameter in so far as you could have several instances on a database.

hope this help,

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 04:02:33 CDT