Home » RDBMS Server » Server Administration » Global database Name
Global database Name [message #196158] Wed, 04 October 2006 06:19 Go to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Can anyone please explain me the use of Global database name parameter

db_name in the parameter file specifies the Database name, then
what are the situations in which we are using global database name parameter.


appreciating response.
Re: Global database Name [message #196272 is a reply to message #196158] Wed, 04 October 2006 13:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

For database link
we will use global database name.
one possible reason.
Re: Global database Name [message #196302 is a reply to message #196158] Wed, 04 October 2006 23:25 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
global_name

*is a datadictionary
* parameter is a combination of the DB_NAME parameter and the DB_DOMAIN parameter

*if DB_NAME=HRPROD and DB_DOMAIN=NODE37.mydomain.COM ,your global_name can be HRPROD.NODE37.mydomain.COM

* select * from global_name;
HRPROD.NODE37.mydomain.COM

read->http://www.dbasupport.com/oracle/ora9i/naming01.shtml

[Updated on: Wed, 04 October 2006 23:26]

Report message to a moderator

Re: Global database Name [message #196335 is a reply to message #196158] Thu, 05 October 2006 01:22 Go to previous message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Its clear to me now.
Thanks a Lot.
Laughing
Previous Topic: Inside redo logs and Logminer (merged 3 cross-posts)
Next Topic: Scheduling shell script with 10g OMS
Goto Forum:
  


Current Time: Fri Sep 20 07:32:18 CDT 2024