中烟巡检
- 整理数据库登录信息（IP记录、用户名密码等）
Manual Check needed
Password incorrect
172.16.33.164 orasrp 172.16.33.180 orabpp
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
ZYCPRD2:oracrp 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: 49083 MB (47.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: ZYCPRD2
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