Home » RDBMS Server » Server Administration » service name and sid
service name and sid [message #229408] Sat, 07 April 2007 07:31 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Can someone please explain me the difference between a service name and an SID?

Report message to a moderator

Re: service name and sid [message #229410 is a reply to message #229408] Sat, 07 April 2007 07:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,
Service Name = SID
db_name <> SID
( when you specify separate)
otherwise db_name and SID is some.


If the database is Oracle9i or Oracle8i, use the SERVICE_NAME parameter rather than the SID parameter.


http://download-uk.oracle.com/docs/cd/B14117_01/network.101/b10776/tnsnames.htm

Regards
Taj

Report message to a moderator

Previous Topic: connectivity with SQL Server
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:48:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.