How to check which database is running on my server

If your server has running more than one instance then it is essential to check which instance is down and which instance is running. Sometimes, end users or application team is trying to connect database but they are getting mysterious error. Actual problem is instance down but you would get different kinds of error messages of TNS or some other.

If you have access of your Linux/Unix server then you can execute following command

ps –ef| grep smon |grep –v grep

You would get list of instances.

On Windows server, you need to start Task Manager. In task there is an option to check PROCESSES. In processes queue you can get number of Oracle.exe processes. TASKLIST command can also help to find out Oracle thread from Win2k platform. This article can help more about Windows https://www.dbametrix.com/ps-command-windows.html