Tony,

If you are on the client side, check your tnsnames.ora file: each entry will
have the SID name on the first line, e.g.

DBNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VADER.DARTH.COM)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBNAME.DARTH.COM)
)
)

If you are on the DB server, you can look at the oratab file which is
located in the /var/opt/oracle directory on Solaris, but you can do a file
search on Windows to locate it. If you can query the database directly,
simply run the following statement:

select name
from v$database;

NAME
DBNAME

hth,

tom



-----Original Message-----
From: Maskevich, Tony [mailto:Tony.[Email Address Removed] 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] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page