Wednesday, 19 June 2013

Oracle SQL Developer - SID

I had a scenario where they could not provide me with the SID for the connection.

If you have access to the Oracle database via a SQL interface (Like Oracle SQL developer or sqlplus) the below query can be used to determine the SID

select sys_context('userenv','db_name') from dual;
Or if you have access to the server terminal the below command can be used
lsnrctl status