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?
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
Previous Topic: connectivity with SQL Server
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Sat Dec 10 03:21:48 CST 2016

Total time taken to generate the page: 0.07768 seconds