1.1 检查数据库的基本状况
oracle数据库由实例和后台进程组成,生产环境中,又都会搭建中间件,应用服务器,那监听也是必不可少。
故 数据库的基本状况包括oracle实例状态,oracle服务进程,oracle监听状态三大部分。
这是oracle的基础!!!
1.1.1 检查oracle 实例状态
SQL> select instance_name,host_name,startup_time,status,version,database_status from v$instance;
INSTANCE_NAME HOST_NAME STARTUP_TIME STATUS VERSION DATABASE_STATUS
------------ ----------------- --------------- --------- ------------ -----------------
test TEST 06-JAN-17 OPEN 11.2.0.1.0 ACTIVE
Instance_name 实例名字
Host_name 主机名字
Startup_time 实例开启的时间
Status 实例状态 必须为open
Database_status 数据库状态 必须为active
SQL> select name,log_mode,open_mode from v$database;
NAME LOG_MODE OPEN_MODE
--------- ------------ --------------------
TEST ARCHIVELOG READ WRITE
name 数据库名字
log_mode 日志模式 归档模式为archivelog
非归档模式为noarchivelog
Open_mode 数据库打开模式 read write 读写 only read 只读
1.1.2 检查oracle服务进程
[oracle@TEST ~]$ ps -ef |grep ora_
oracle 1808 1 0 15:42 ? 00:00:00 ora_w000_test
oracle 1975 1934 0 16:10 pts/2 00:00:00 grep ora_
oracle 9340 1 0 Jan06 ? 00:00:08 ora_pmon_test
oracle 9342 1 0 Jan06 ? 00:00:36 ora_vktm_test
oracle 9346 1 0 Jan06 ? 00:00:01 ora_gen0_test
oracle 9348 1 0 Jan06 ? 00:00:06 ora_diag_test
oracle 9350 1 0 Jan06 ? 00:00:02 ora_dbrm_test
oracle 9352 1 0 Jan06 ? 00:00:06 ora_psp0_test
oracle 9354 1 0 Jan06 ? 00:01:06 ora_dia0_test
oracle 9356 1 0 Jan06 ? 00:00:07 ora_mman_test
oracle 9358 1 0 Jan06 ? 00:00:16 ora_dbw0_test
oracle 9360 1 0 Jan06 ? 00:00:09 ora_lgwr_test
oracle 9362 1 0 Jan06 ? 00:01:18 ora_ckpt_test
oracle 9364 1 0 Jan06 ? 00:00:12 ora_smon_test
oracle 9366 1 0 Jan06 ? 00:00:01 ora_reco_test
oracle 9368 1 0 Jan06 ? 00:00:16 ora_mmon_test
oracle 9370 1 0 Jan06 ? 00:00:23 ora_mmnl_test
oracle 9372 1 0 Jan06 ? 00:00:01 ora_d000_test
oracle 9374 1 0 Jan06 ? 00:00:01 ora_s000_test
oracle 9433 1 0 Jan06 ? 00:00:02 ora_arc0_test
oracle 9435 1 0 Jan06 ? 00:00:05 ora_arc1_test
oracle 9437 1 0 Jan06 ? 00:00:04 ora_arc2_test
oracle 9439 1 0 Jan06 ? 00:00:03 ora_arc3_test
oracle 9441 1 0 Jan06 ? 00:00:03 ora_qmnc_test
oracle 9455 1 0 Jan06 ? 00:00:39 ora_cjq0_test
oracle 9457 1 0 Jan06 ? 00:00:02 ora_q000_test
oracle 9459 1 0 Jan06 ? 00:00:01 ora_q001_test
oracle 9516 1 0 Jan06 ? 00:00:01 ora_smco_test
User oracle 用户名
Pid 1294 进程id号
Ppid 1 父进程id号
C
Startup_time jan06 进程启动时间 stime
Time 00:00:02 进程使用的总cpu时间
Cmd ora_pmon_test 正在执行的命令行命令
其中pmon为进程名 test为实例名 oracle的sid
Pmon 进程监视器
Smon 系统监视进程 监听实例状态 实例恢复
Ckpt 检查点进程
Dbwr 写数据进程
Lgwr 写日志进程
Arc0 进行归档进程
Reco 进行恢复进程
1.1.3 检查oracle监听状态
[oracle@TEST ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-JAN-2017 16:11:06
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.40)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 09-JAN-2017 23:27:41
Uptime 0 days 16 hr. 43 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/TEST/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.9.40)(PORT=1521)))
Services Summary...
Service "test" has 2 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
Service summary 表示oracle的监听程序正在监听哪些数据库实例
Instance test 名为test的实例
Status Unknow 为静态监听 手动创建
Status ready 为动态监听 oralce读取init.ora文件自动生成
检查监听程序是否存在
[oracle@TEST ~]$ ps -ef |grep lsn |grep -v grep
oracle 29453 1 0 Jan09 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/tnslsnr
LISTENER -inherit
grep –v grep 排除掉grep行
oracle数据库由实例和后台进程组成,生产环境中,又都会搭建中间件,应用服务器,那监听也是必不可少。
故 数据库的基本状况包括oracle实例状态,oracle服务进程,oracle监听状态三大部分。
这是oracle的基础!!!
1.1.1 检查oracle 实例状态
SQL> select instance_name,host_name,startup_time,status,version,database_status from v$instance;
INSTANCE_NAME HOST_NAME STARTUP_TIME STATUS VERSION DATABASE_STATUS
------------ ----------------- --------------- --------- ------------ -----------------
test TEST 06-JAN-17 OPEN 11.2.0.1.0 ACTIVE
Instance_name 实例名字
Host_name 主机名字
Startup_time 实例开启的时间
Status 实例状态 必须为open
Database_status 数据库状态 必须为active
SQL> select name,log_mode,open_mode from v$database;
NAME LOG_MODE OPEN_MODE
--------- ------------ --------------------
TEST ARCHIVELOG READ WRITE
name 数据库名字
log_mode 日志模式 归档模式为archivelog
非归档模式为noarchivelog
Open_mode 数据库打开模式 read write 读写 only read 只读
1.1.2 检查oracle服务进程
[oracle@TEST ~]$ ps -ef |grep ora_
oracle 1808 1 0 15:42 ? 00:00:00 ora_w000_test
oracle 1975 1934 0 16:10 pts/2 00:00:00 grep ora_
oracle 9340 1 0 Jan06 ? 00:00:08 ora_pmon_test
oracle 9342 1 0 Jan06 ? 00:00:36 ora_vktm_test
oracle 9346 1 0 Jan06 ? 00:00:01 ora_gen0_test
oracle 9348 1 0 Jan06 ? 00:00:06 ora_diag_test
oracle 9350 1 0 Jan06 ? 00:00:02 ora_dbrm_test
oracle 9352 1 0 Jan06 ? 00:00:06 ora_psp0_test
oracle 9354 1 0 Jan06 ? 00:01:06 ora_dia0_test
oracle 9356 1 0 Jan06 ? 00:00:07 ora_mman_test
oracle 9358 1 0 Jan06 ? 00:00:16 ora_dbw0_test
oracle 9360 1 0 Jan06 ? 00:00:09 ora_lgwr_test
oracle 9362 1 0 Jan06 ? 00:01:18 ora_ckpt_test
oracle 9364 1 0 Jan06 ? 00:00:12 ora_smon_test
oracle 9366 1 0 Jan06 ? 00:00:01 ora_reco_test
oracle 9368 1 0 Jan06 ? 00:00:16 ora_mmon_test
oracle 9370 1 0 Jan06 ? 00:00:23 ora_mmnl_test
oracle 9372 1 0 Jan06 ? 00:00:01 ora_d000_test
oracle 9374 1 0 Jan06 ? 00:00:01 ora_s000_test
oracle 9433 1 0 Jan06 ? 00:00:02 ora_arc0_test
oracle 9435 1 0 Jan06 ? 00:00:05 ora_arc1_test
oracle 9437 1 0 Jan06 ? 00:00:04 ora_arc2_test
oracle 9439 1 0 Jan06 ? 00:00:03 ora_arc3_test
oracle 9441 1 0 Jan06 ? 00:00:03 ora_qmnc_test
oracle 9455 1 0 Jan06 ? 00:00:39 ora_cjq0_test
oracle 9457 1 0 Jan06 ? 00:00:02 ora_q000_test
oracle 9459 1 0 Jan06 ? 00:00:01 ora_q001_test
oracle 9516 1 0 Jan06 ? 00:00:01 ora_smco_test
User oracle 用户名
Pid 1294 进程id号
Ppid 1 父进程id号
C
Startup_time jan06 进程启动时间 stime
Time 00:00:02 进程使用的总cpu时间
Cmd ora_pmon_test 正在执行的命令行命令
其中pmon为进程名 test为实例名 oracle的sid
Pmon 进程监视器
Smon 系统监视进程 监听实例状态 实例恢复
Ckpt 检查点进程
Dbwr 写数据进程
Lgwr 写日志进程
Arc0 进行归档进程
Reco 进行恢复进程
1.1.3 检查oracle监听状态
[oracle@TEST ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-JAN-2017 16:11:06
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.40)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 09-JAN-2017 23:27:41
Uptime 0 days 16 hr. 43 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/TEST/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.9.40)(PORT=1521)))
Services Summary...
Service "test" has 2 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
Service summary 表示oracle的监听程序正在监听哪些数据库实例
Instance test 名为test的实例
Status Unknow 为静态监听 手动创建
Status ready 为动态监听 oralce读取init.ora文件自动生成
检查监听程序是否存在
[oracle@TEST ~]$ ps -ef |grep lsn |grep -v grep
oracle 29453 1 0 Jan09 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/tnslsnr
LISTENER -inherit
grep –v grep 排除掉grep行
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31419698/viewspace-2132188/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31419698/viewspace-2132188/