Differences between revisions 2 and 5 (spanning 3 versions)
⇤ ← Revision 2 as of 2016-03-17 03:38:31 →
Size: 134
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 ==

{{{
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
       }}}

==

中烟巡检

  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)