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.

Report message to a moderator

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: 4579
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 23:43:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.