|
Size: 120
Comment:
|
Size: 1670
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
== 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 |
中烟巡检
- 整理数据库登录信息（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