Check general database status
I recommend you first step is to check if database processes are running, to do that on shell(Unix): $ ps -ef | grep pmon orauser1 17289 1 0 May 11 ? 292:33 ora_pmon_DATABASE1 orauser2 15095 1 0 Sep 10 ? 2:00 ora_pmon_DATABASE2 oracle 22362 1 0 May 8 ? 118:48 ora_pmon_DATABASE3 this command will let us know which databases are running on the machine and his startup times, also it gives you which oracle users are starting each database. For example, oracle user started DATABASE3 database on May 8. To check if listeners are running: $ ps -ef | grep tns oracle 25141 1 0 May 8 ? 82:59 /oracle/HPQC/oracle/DATABASE3/11204/bin/tnslsnr LISTENER -inherit orauser1 17265 1 0 May 11 ? 59:17 /oracle/JP0/112_64/bin/tnslsnr LISTENER_DATABASE1 -inherit orauser2 16189 1 0 Oct 10 ? 100:26 /oracle/SM2/112_64/bin/tnslsnr LISTENER_DATABASE2 -inherit And to check deeply if a particular list...