How to get SID (instance name) without SYS DBA?
625082Feb 25 2008 — edited Feb 12 2012Hi! 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?