查看oracle实例及sid

select name from V$database;

select instance_name from  V$instance;