1.DM7数据库部署信息查询

set echo off
set feedback off
set timing off
set verify off
set lineshow off
set pagesize 0

with inst as
  (
    select
	host_name
       ,svr_version version
       ,instance_number
       ,instance_name
       ,STATUS$ status
       ,round(sysdate-START_TIME)||' Days' uptime
   from v$instance
  ),
db as
  (
     select
        arch_mode log_mode
	,(case
           when rac_nodes = 1 then 'NORAC Database'
           when rac_nodes >=2 then 'RAC Database'
          else 'ERROR' end) db_clusters
       from v$database
   )
select 'Database Information' from dual
union all
select '--------------------' from dual
union all
select '*HOSTNAME*：'   ||
       a.host_name      ||
       ' *DB_VERSION*：'||
       a.version        ||
       ' *DB_CLUSTER*：'||
       b.db_clusters    ||
       ' *INS_ID*：'    ||
       a.instance_number||
       ' *INS_NAME*：'  ||
       a.instance_name  ||
       ' *STATUS*：'    ||
       a.status         ||
       ' *ARCH_MODE*：' ||
       b.log_mode       ||
       ' *Uptime*：'    ||
       a.uptime dbinfo
from  inst a, db b;

2.DM8数据库部署信息查询

set echo off
set feedback off
set timing off
set verify off
set lineshow off
set pagesize 0

with inst as
  (
    select
        host_name
       ,svr_version version
       ,instance_number
       ,instance_name
       ,STATUS$ status
       ,round(sysdate-START_TIME)||' Days' uptime
   from v$instance
  ),
db as
  (
     select
        arch_mode log_mode
       ,(case
           when dsc_nodes = 1 then 'NODSC Database'
           when dsc_nodes >=2 then 'DSC Database'
         else 'ERROR' end) db_clusters
       from v$database
   )
select 'Database Information' from dual
union all
select '--------------------' from dual
union all
select '*HOSTNAME*：'   ||
       a.host_name      ||
       ' *DB_VERSION*：'||
       a.version        ||
       ' *DB_CLUSTER*：'||
       b.db_clusters    ||
       ' *INS_ID*：'    ||
       a.instance_number||
       ' *INS_NAME*：'  ||
       a.instance_name  ||
       ' *STATUS*：'    ||
       a.status         ||
       ' *ARCH_MODE*：' ||
       b.log_mode       ||
       ' *Uptime*：'    ||
       a.uptime dbinfo
from  inst a, db b;