Differences between revisions 3 and 5 (spanning 2 versions)
⇤ ← Revision 3 as of 2016-03-17 03:49:40 →
Size: 1034
Editor: localhost
Comment:
← Revision 5 as of 2016-03-17 03:50:57 → ⇥
Size: 1015
Editor: localhost
Comment:
Deletions are marked like this. Additions are marked like this.
Line 6: Line 6:
== 172.16. == 172.16.34.145 not open ==
Line 8: Line 8:
SQL> set lines 200; {{{
set lines 200;
Line 19: Line 20:
ORDER BY inst_id;SQL> SQL> 2 3 4 5 6 7 8 9 10 ORDER BY inst_id;
SQL>
Line 24: Line 26:
       }}}

中烟巡检

  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

==

首頁/2016-03-17 (last edited 2016-03-17 07:01:13 by localhost)