查询当前数据名,实例名，域名，服务名，模式

alter system register            ---强制重新注册（动态实例注册）host lsnrctl status listenerhost lsnrctl start listenerhost lsnrctl stop listenerhost lsnrctl services listener查询数据库服务名desc v$parametercol name justify left format a20col value justify left format a20select name,value from v$parameter where name like '%service%'命令行下，不使用连接字符串直接/as sysdba进入sqlplusw，此种情况下不会连接监听器，所以启停服务时都不会去连接监听服务。select status from v$instance;select * from v$shared_serverselect * from v$dispatcher以上任意一个结果为空，为共享模式select network from v$dispatcherselect * from v$queueselect * from v$circuitselect * from v$shared_server_monitor  --查看那些进程在服务show parameter dispatchers ---只能在sqlplus 中查询select * from v$sessionselect * from dba_tablespacesselect * from dba_tables where TABLESPACE_NAME='USERS';select * from v$database查询当前数据名方法一:select name from v$database;方法二：show parameter dbselect * from v$instance 查询当前数据库实例名方法一：select instance_name from v$instance;方法二：show parameter instanceselect * from v$parameter where NAME like '%db_domain%';  查询数据库域名方法一：select value from v$parameter where name = 'db_domain';方法二：show parameter domainselect * from v$parameter where name like '%name%' 查询数据库服务名方法一：select value from v$parameter where name = 'service_names';方法二：show parameter service_name