Guest_imported
New member
- Jan 1, 1970
- 0
How can you find the login oracle sid of the currently running instance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle sid
- Thread starter Guest_imported
- Start date
- Status
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.
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
MIS
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"?
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"?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
