中烟巡检

1. 整理数据库登录信息（IP记录、用户名密码等）

172.16.34.145 not open

set lines 200;
column HOST format a7;
SELECT     inst_id,
           instance_number inst_no,
           instance_name inst_name,
           parallel,
           status,
           database_status db_status,
           active_state state,
           host_name host
FROM       gv$instance
ORDER BY   inst_id;
SQL>

   INST_ID    INST_NO Instance     PARALLEL  STATUS                               DB_STATUS                                           STATE                       Host
---------- ---------- ------------ --------- ------------------------------------ --------------------------------------------------- --------------------------- -------
         1          1 BID          NO        STARTED                              ACTIVE                                              NORMAL                      ZYBDEV

==