《oracle合规检查和健康检查不正常项目明细》由会员分享，可在线阅读，更多相关《oracle合规检查和健康检查不正常项目明细（6页珍藏版）》请在金锄头文库上搜索。
1、合规检查_不合规项目明细表主机名主机名:bj1ecidb8:bj1ecidb8 检检 查查 类类 别别检查项检查项说明说明明细明细配 置 信 息重做日志 大小正常：所有 大小都一样， 都在 50M 到 1G 之间eciforg_std : LOGSIZE 500 500 500 500 500 500 6 rows selected.配 置 信 息归档目录正常按照 规范的目录 不正常不 是按照规范 的目录eciforg_std : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With
2、the Partitioning, OLAP, Data Mining and Real Application Testing options Database log mode Archive Mode Automatic archival Enabled Archive destination /home/db/oraarch Oldest online log sequence 3785 Next log sequence to archive 0 Current log sequence 3787配 置 信 息监听端口 listener port正常按照 规定的端口 (11521)
3、不 正常默认 的端口eciforg_std : listener port number: 1521 1521配 置 信 息用户 ulimit正常都为 unlimited 不正常不 全是 unlimitedeciforg_std : time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 8192 memory(kbytes) unlimited coredump(blocks) 2097151 nofiles(descriptors) unlimited命 名 规 则控制文件 名正
4、常按照 规范的名称 不正常不 是按照规范eciforg_std : NAME /home/db/oracle/oradata/eciforg/rcontrol1_512m /home/db/oracle/oradata/eciforg/rcontrol2_512m的名称/home/db/oracle/oradata/eciforg/rcontrol3_512m日 志alert 日 志eciforg_std : ORA-00316: log 3 of thread 1, type 0 in header is not log file ORA-00312: online log 3 thread
5、 1: /home/db/oracle/oradata/eciforg/rlog1_3_1_512m Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-00367: checksum error in log file header ORA-00316: log 4 of thread 2, type 0 in header is not log file ORA-00312: online log 4 thread 2: /home/db/oracle/oradata
6、/eciforg/rlog2_1_1_512m Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-00367: checksum error in log file header ORA-00316: log 6 of thread 2, type 0 in header is not log file ORA-00312: online log 6 thread 2: /home/db/oracle/oradata/eciforg/rlog2_3_1_512m Err
7、ors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-00367: checksum error in log file header ORA-00316: log 8 of thread 2, type 0 in header is not log file ORA-00312: online log 8 thread 2: /home/db/oracle/oradata/eciforg/rlog2_2_2_512m Errors in file /home/db/oracle
8、/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-16037: user requested cancel of managed recovery operation Recovery interrupted! Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-16037: user requested cancel of managed recovery operation ORA-1109 signa
9、lled during: ALTER DATABASE CLOSE NORMAL. Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_151552.trc: ORA-16037: user requested cancel of managed recovery operation Recovery interrupted! Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_151552.trc: ORA-1
10、6037: user requested cancel of managed recovery operation Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_131130.trc: ORA-16037: user requested cancel of managed recovery operation Recovery interrupted! Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_1
11、31130.trc:ORA-16037: user requested cancel of managed recovery operation日 志listener 日志eciforg_std : WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending TNS-12514: TNS:listener does not currently know of service requested in connect descript
12、or WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscrip
13、tion for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending 配 置 信 息临时表空 间大小正常：=4Geciforg_std :配 置 信 息UNDO 表空 间大小正常：=8Geciforg_std :配 置 信 息用户环境 配置正常按照 规范的目录 不正常不 是按照规范 的目录eciforg_std : ORACLE_BASE:/home/db/orac
14、le ORACLE_HOME:/home/db/oracle/product/10.2.0配 置 信 息在线日志 目录正常按照 规范的目录 不正常不 是按照规范 的目录eciforg_std : MEMBER /home/db/oracle/oradata/eciforg/rlog1_1_1_512m /home/db/oracle/oradata/eciforg/rlog1_2_1_512m /home/db/oracle/oradata/eciforg/rlog1_3_1_512m /home/db/oracle/oradata/eciforg/rlog2_1_1_512m /home/d
15、b/oracle/oradata/eciforg/rlog2_2_2_512m /home/db/oracle/oradata/eciforg/rlog2_3_1_512m /home/db/oracle/oradata/eciforg/rlog2_1_2_512m /home/db/oracle/oradata/eciforg/rlog2_2_1_512m /home/db/oracle/oradata/eciforg/rlog1_1_2_512m /home/db/oracle/oradata/eciforg/rlog1_2_2_512m /home/db/oracle/oradata/e
16、ciforg/rlog1_3_2_512m MEMBER /home/db/oracle/oradata/eciforg/rlog2_3_2_512m /home/db/oracle/oradata/eciforg/rstb1_1_512m /home/db/oracle/oradata/eciforg/rstb1_2_512m/home/db/oracle/oradata/eciforg/rstb2_1_512m /home/db/oracle/oradata/eciforg/rstb2_2_512m /home/db/oracle/oradata/eciforg/rstb3_1_512m /home/db/oracle/oradata/eciforg/rstb3_2_512m /home/db/oracle/oradata/eciforg/rstb4_1_512m /home/db/oracle/oradata/eciforg/rstb4_2_512m /home/db/oracle
