Oracle sid

[Guest_imported]

How can you find the login oracle sid of the currently running instance.

 

[karluk]

I guess the easiest thing is to check the listener.ora file on the server. It should contain a parameter, SID_LIST_LISTENER. The individual SID_NAMEs within this list are the instances which the listener is monitoring.

Of course there are some implicit assumptions in doing this. The listener may not be started, and even if it is, the instances it is monitoring may not be up. Also, it's possible, but not likely, that there is an instance running on the server that hasn't been added to the listener. However most likely checking listener.ora will give you a complete list of instances running on the server.

 

[DBAwhosaysNIE]

I don't understand what you meant by "login oracle sid of the currently running instance". A given server can have multiple instances simultaneously running. Do you mean the sid for a given client session (ex. SQL*Plus)?

Obviously you can type env in a shell (or set in NT) but that instance won't necessarily be running.

If you want to see running instances you can type ps -ef | grep ora*smon (or net start in NT).

If you mean for a SQL*Plus session just go back and check the tnsnames.ora ($ORACLE_HOME/network/admin).

What exactly did you mean by "login oracle sid"?