转载自:http://zhidao.baidu.com/question/364402420.html
用 ps -ef|grep smon
看你当前有多少个已经启动的实例,
[oracle@VOD-151 ~]$ ps -ef|grep smon
oracle 16541 1 0 11:16 ? 00:00:01 ora_smon_vodtest
oracle 21753 1 0 16:18 ? 00:00:00 ora_smon_voddb
oracle 22314 21280 0 16:40 pts/1 00:00:00 grep smon
没启动的,只能去$ORACLE_HOME/dbs下面去数你有多少init文件了。如果你有多个ORACLE HOME,那就挨个数吧
SQL>select * from global_name; //显示当前启动的数据库实例
未启动的可以:ps -elf | grep ora_ ( 对比其后接的SID)
[oracle@VOD-151 ~]$ ps -elf | grep ora_
0 S oracle 16515 1 0 80 0 - 447959 poll_s 11:16 ? 00:00:02 ora_pmon_vodtest
0 S oracle 16517 1 0 58 - - 447364 hrtime 11:16 ? 00:00:33 ora_vktm_vodtest
0 S oracle 16521 1 0 80 0 - 447364 semtim 11:16 ? 00:00:00 ora_gen0_vodtest
0 S oracle 16523 1 0 80 0 - 447364 semtim 11:16 ? 00:00:00 ora_diag_vodtest
....