Skip to Main Content

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!

How to get SID (instance name) without SYS DBA?

625082Feb 25 2008 — edited Feb 12 2012
Hi! I want to know, how can i get SID (Oracle System ID) or instance name without access to SYS DBA views?

Situation:
1st box (my developing) with Oracle Instant Client (use sqlnet.ora net assistent service - so from my pc i can connect to db);
2nd box where script will be putted on is server with Oracle Instant Client which use tnsnames.ora
3rd box is Oracle DB server (ver. 9.2).

I need write script which connects to the DB (3rd), but the first of all i need create entry in tnsnames.ora file on (2nd box). I know (3rd) server ip address/port and user/pass..but i don't know SID.

I can connect direct from my box (2nd)..so i can run some sql queries and browse some tables with my privileges/scheme.

i tried to get SID from sys dba views, like:

select instance_name from v$instance (no access);
show parameters (no access);
select * from global_name; (actualy returns just hostname)

Q: is it possible to see SID without DBA roles in some dict table, view etc?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2012
Added on Feb 25 2008
5 comments
158,041 views