中烟巡检

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

Manual Check needed

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

172.16.33.152 is not open

ZYSQAS:orasrp 21> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 17 13:22:09 2016

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options

SQL> SQL> SQL> SQL> INSTANCE_NAME DATABASE_STATUS STATUS HOST_NAME

SRP ACTIVE MOUNTED ZYSQAS

172.16.33.153 not include Oracle Database

172.16.33.141