| Difference among . [message #60643] |
Mon, 23 February 2004 18:18  |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi,
I want to know the difference among DATABASE NAME / GLOBAL DATABASE NAME / SID / SERVICE NAME / INSTANCE NAME of a database.
And what are the role and usage of having these multiple names for a single database.
|
|
|
|
| Re: Difference among . [message #60661 is a reply to message #60643] |
Tue, 24 February 2004 05:58  |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
DATABASE NAME is the name you specify when create DB in the statement CREATE DATABASE WHATEVER-NAME
INSTANCE NAME is the name you can give to the previously created DB when using PARALLEL SERVER, so you can startup several instances on each server and you can give defferent names, but working always in database named as indicated in DATABASE NAME
GLOBAL DB NAME. I have always confused about this parameter.
SID, as far as i remember, is only an environmental variable which value must match to DATABASE NAME or INSTANCE NAME in order to users can connect.
SERVICE NAME is the value you can use when registering your DB with listeners.
Hope this can help...
Regards.
www.otools.com.ar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
