On the host where the Oracle database resides look at the services
You will see "OracleService<SID>"

i.e
OracleServicePROD

The sid would be the name after OracleService



____________________________________________

Glen Bernas
Database Administrator
EMC²
where information lives

Phone:
Direct: (508) 249-2237
Ext: 42237



-----Original Message-----
From: Maskevich, Tony [mailto:Tony.[Email Address Removed]
Sent: Friday, October 31, 2003 9:54 AM
To: LazyDBA.com Discussion
Subject: ORACLE SID


How can I determine the Oracle Sid for an 8i database. When I go into Net 8
assistant Under local when I click o the database the service name is
populated but the SID is empty. Can anyone offer any help?

Tony


CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. Any unauthorized review, use, disclosure
or distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page