dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Service_names - Oracle FAQ

This is a discussion on Service_names - Oracle FAQ ; Type:String Syntax:SERVICE_NAMES =db_service_name [, db_service_name [ ... ] ] Default B_UNIQUE_NAME.DB_DOMAIN if defined Modify:ALTER SYSTEM Range:Any ASCII string or comma-separated list of string names Basic:No Rac o not set the SERVER_NAMES parameter for Real Application Clusters (RAC). Instead, define services ...



Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 02-04-2008, 07:24 AM
Database Guru
 
Join Date: Jan 2008
Posts: 2,546
domregchief is on a distinguished road
Post Service_names

Type:String
Syntax:SERVICE_NAMES =db_service_name [, db_service_name [ ... ] ]
DefaultB_UNIQUE_NAME.DB_DOMAIN if defined
Modify:ALTER SYSTEM
Range:Any ASCII string or comma-separated list of string names
Basic:No
Raco not set the SERVER_NAMES parameter for Real Application Clusters
(RAC). Instead, define services using Database Configuration Assistant (DBCA) and manage services using Server Control (SRVCTL) utility.
Notes:SERVICE_NAMES specifies one or more names by which clients can connect to the instance. The instance registers its service names with the listener. When a client requests a service, the listener determines which instances offer the requested service and routes the client to the appropriate instance.You can specify multiple service names in order to distinguish among different uses of the same database. For example:
SERVICE_NAMES = sales.acme.com, widgetsales.acme.com
You can also use service names to identify a single service that is available from two different databases through the use of replication.If you do not qualify the names in this parameter with a domain, Oracle qualifies them
with the value of the DB_DOMAIN parameter. If DB_DOMAIN is not specified, then no domain will be applied to the non-qualified SERVICE_NAMES values.
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 12:38 AM.