Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_NAME, INSTANCE_NAME
Instance Name is not compulsory, but is used when an Instance performs
dynamic registration with a Listener. Without it, the Instance registers
itself with its ORACLE_SID value. With it, it can register itself as pretty
much anything, though the advice is still to set it to the same value as
ORACLE_SID generally. Whether it's compulsory with parallel server, I can't
recall. It is required with RAC.
What's db_name for? First, it's used at instance startup: it needs to match the database name found in the control file, so you know you're starting with the correct init.ora. Secondly, it and db_domain are concatenated to generate the service name when registering with the Listener (although you can also specify service_names to achieve the same thing directly).
Regards
HJR
"Imran Rahim" <i_rahim_at_hotmail.com> wrote in message
news:e7519cfe.0210210940.3b536f17_at_posting.google.com...
> Can anyone please tell me - Am I right in saying that instance_name is
> not compulsary but is required if you have parallel server option.
> Also, what is db_name used for if clients use the instance_name to
> connect to the server?
Received on Mon Oct 21 2002 - 12:55:08 CDT