Home » RDBMS Server » Networking and Gateways » Oracle SID and SERVICE_NAME
Oracle SID and SERVICE_NAME [message #67671] Wed, 22 December 2004 19:50 Go to next message
Koushik Chandra
Messages: 3
Registered: December 2004
Junior Member
what is the differecce between Oracle SID and SERVICE_NAME and which one better to use in tnsnames.ora.
Re: Oracle SID and SERVICE_NAME [message #67672 is a reply to message #67671] Thu, 23 December 2004 03:41 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Hi,

A SERVICE is a nicer looking name than a SID. Besides, you want to be in a position to change the SID, or move the SERVICE to a different SID without your users knowing it. A SERVICE also allows users to connect to a set of instances when using RAC.

For more info, see "Connectivity Concepts" in the Oracle Net Services Administrator's Guide.

Best regards.

Frank
Previous Topic: Failover mechanism does not fire.
Next Topic: oracle 8i remote data synchronization
Goto Forum:
  


Current Time: Fri Nov 22 03:17:15 CST 2024