Re: Help: Name confusion.

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: 1997/12/09
Message-ID: <66k4qt$eaq@argon.btinternet.com>#1/1

There is no difference between a SID and an Instance name, There is a difference between the SID/Instance name and the database name though, imagine a cluster (in the old VMS days) when each node/machine had its own instance and they all opened the same DB in parallel mode. instance1 , instance2 , instance3 , instance 4 were all different names, but all opened the same DBNAME, There are ways of changing the DB name if you want to.

I call mine Fred.

Casper Thrane wrote in message <348D1B38.C0B75C19_at_benau.dk>...
>Hi!
>
>I am very confused. Can anyone tell me the diffenrence between an
>instance and SID name.
>When I installed my server I was asked to input an SID name and I chose
>the default name "ORCL", and now when I look in the v$database view, I
>am told that my database is called oracle.
>What is the diffenrence and what is the names used for?
>--
>Casper Thrane
>System developer
>Benau A/S
Received on Tue Dec 09 1997 - 00:00:00 CST