|
Size: 120
Comment:
|
Size: 2570
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 == 172.16.33.153 not include Oracle Database == == 172.16.33.141 == {{{ ZYBPRD2:orabip 21> machinfo CPU info: 4 Intel(R) Itanium 2 9100 series processors (1.6 GHz, 18 MB) 533 MT/s bus, CPU version A1 8 logical processors (2 per socket) Memory: 65467 MB (63.93 GB) Firmware info: Firmware revision: 9.048 FP SWA driver revision: 1.18 IPMI is supported on this system. BMC firmware revision: 4.01 Platform info: Model: "ia64 hp server rx7640" Machine ID number: 0b67bf01-c256-11de-a2c9-e732dd675286 Machine serial number: SGH49383T5 OS info: Nodename: ZYBPRD2 Release: HP-UX B.11.31 Version: U (unlimited-user license) Machine: ia64 ID Number: 0191348481 vmunix _release_version: @(#) $Revision: vmunix: B.11.31_LR FLAVOR=perf }}} == 172.16.33.158 == |
中烟巡检
- 整理数据库登录信息（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
ZYBPRD2:orabip 21> machinfo
CPU info:
4 Intel(R) Itanium 2 9100 series processors (1.6 GHz, 18 MB)
533 MT/s bus, CPU version A1
8 logical processors (2 per socket)
Memory: 65467 MB (63.93 GB)
Firmware info:
Firmware revision: 9.048
FP SWA driver revision: 1.18
IPMI is supported on this system.
BMC firmware revision: 4.01
Platform info:
Model: "ia64 hp server rx7640"
Machine ID number: 0b67bf01-c256-11de-a2c9-e732dd675286
Machine serial number: SGH49383T5
OS info:
Nodename: ZYBPRD2
Release: HP-UX B.11.31
Version: U (unlimited-user license)
Machine: ia64
ID Number: 0191348481
vmunix _release_version:
@(#) $Revision: vmunix: B.11.31_LR FLAVOR=perf