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

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.


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

Current Time: Sat Jul 22 04:15:10 CDT 2017

Total time taken to generate the page: 0.04833 seconds