1.select status from v$instance;

nomount状态、mounted状态、open状态。

或者

select open_mode from v$database;

nomount、mounted、READ WRITE

2.查看实例名字

 select instance_name,host_name from v$instance;