Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting SID with a given service name or host

271944Jan 12 2012 — edited Jan 12 2012

Hi.

I am curious if there is a way or command line to get SID with a given service name or host. I have a service name, but I don't know how to get SID. I know that I can parse the tnsnames.ora file to get it, but if possible, I want to use the more official and safe way.

I'd appreciated if somebody knows it.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2012

Added on Jan 12 2012

#general-database-discussions

4 comments

8,406 views