美创科技技术社区

注册

 

发新话题 回复该主题

dbcheck.sh [复制链接]

1#

–Test on 10g Linux

[root@xe2 lank]# sh check.sh

/lank/20120111231616 not found,nowing mdkir it!

Start Checking….

##########Running osbase.sh…….

End sh osbase.sh successfully!

##########Running dbcheck.sql…….

End dbcheck.sql successfully!

Check Finished…

End get_bdump successfully!

The directory of Alert_log is /app/admin/lank/bdump

total 3992

-rw-r–r– 1 root   root 1705623 Jan 11 23:17 osbase.log

-rw-r–r– 1 ora10g dba    51262 Jan 11 23:17 dbcheck.htm

-rw-r–r– 1 root   root   41295 Jan 11 23:17 os_db_check.log

-rw-r–r– 1 root   root 2267628 Jan 11 23:17 alert.log.20120111231616


20120111231616/alert.log.20120111231616

20120111231616/dbcheck.htm

20120111231616/osbase.log

20120111231616/os_db_check.log

[root@xe2 lank]#


Test on 11g Linux

[root@xe2 lank]# sh check.sh

/home/oracle/scripts/20120111231954 not found,nowing mdkir it!

Start Checking….

##########Running osbase.sh…….

End sh osbase.sh successfully!

##########Running dbcheck.sql…….

End dbcheck.sql successfully!

Check Finished…

End get_bdump successfully!

The directory of Alert_log is /ora11/diag/rdbms/ora11/ora11/trace

total 3756

-rw-r–r– 1 root   root 1705623 Jan 11 23:21 osbase.log

-rw-r–r– 1 root   root   48101 Jan 11 23:21 os_db_check.log

-rw-r–r– 1 oracle dba    57907 Jan 11 23:21 dbcheck.htm

-rw-r–r– 1 root   root 2014893 Jan 11 23:21 alert.log.20120111231954


20120111231954/alert.log.20120111231954

20120111231954/dbcheck.htm

20120111231954/osbase.log

20120111231954/os_db_check.log



Test AIX +Oracle 10g

[root@xe2 lank]# sh last.sh

/home/oracle/scripts/20120112011915 not found,nowing mdkir it!

Start Checking….

##########Running osbase.sh…….

End sh osbase.sh successfully!

##########Running dbcheck.sql…….

End dbcheck.sql successfully!

Check Finished…

End get_bdump successfully!

The directory of Alert_log is /ora11/diag/rdbms/ora11/ora11/trace

total 3764

-rw-r–r– 1 root   root 1711404 Jan 12 01:20 osbase.log

-rw-r–r– 1 root   root   48344 Jan 12 01:20 os_db_check.log

-rw-r–r– 1 oracle dba    58163 Jan 12 01:20 dbcheck.htm

-rw-r–r– 1 root   root 2015312 Jan 12 01:20 alert.log.20120112011915


20120112011915/alert.log.20120112011915

20120112011915/dbcheck.htm

20120112011915/osbase.log

20120112011915/os_db_check.log

[root@xe2 lank]#

脚本:

http://blog.mchz.com.cn/wp-content/uploads/dbcheck.txt

———Mark it

-2012-03-14 fixed a bug

su – oracle –>$USER  !not cat right user!

http://blog.mchz.com.cn/wp-content/uploads/one_key_dbcheck_v1.txt

分享 转发
TOP
发新话题 回复该主题