|
Size: 1069
Comment:
|
Size: 1748
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 6: | Line 6: |
| == Manual Check needed == |
|
| Line 8: | Line 11: |
| SQL> set lines 200; | |
| Line 10: | Line 12: |
| set lines 200; | |
| Line 20: | Line 23: |
| ORDER BY inst_id;SQL> SQL> 2 3 4 5 6 7 8 9 10 | ORDER BY inst_id; SQL> |
| Line 27: | Line 31: |
| == | == 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 == {{{ |
中烟巡检
- 整理数据库登录信息（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