ORACLE 9i-23ai

数据库oracle

ORA-07445 [kggchk()+77] [SIGSEGV] [Address not mapped to object]

by

今天有个项目系统负载突然变大，查到top sql是一个存储过程,执行计划缺少合理的索引，SQL是个update操作，于是kill 调用的几个session 建立一个索引，结果发现kill几个用户进程后实例挂了.下面是alert日志，可见instance crash前出现过死锁,就是那个update sql Thu Aug 15 11:08:04 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_24011.trc. Thu Aug 15 11:27:00 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_26527.trc. Thu Aug 15 11:27:03 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_26912.trc. Thu Aug 15 11:32:46 2013 ORA-00060: Deadlock detected. More info … Read more

Enabling Listener Trace ,TNS-01251

by

Enabling Listener Trace ,TNS-01251 Oracle version 11g introduced the ADR or Automatic Diagnostic Repository feature,Trying to change the log file using the Lsnrctl utility fails with: TNS-01251: Cannot set trace/log directory under ADR. oracle@db231 trace]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 – Production on 15-AUG-2013 14:15:59 Copyright (c) 1991, 2011, Oracle. All rights reserved. … Read more

Know more about Oracle ASH

by

《Know More about Oracle AWR》 姐妹篇，oracle 10g引入，ASH 是性能诊断工具，不像sql trace总是默认打开， 保存历史上发生了什么， 提供比AWR更细粒度的数据，即使当系统负载很高时，它也工作的很好，因为使用类似memcopy的数据收集，不会有太大的额外负担，没用任何类型的数据库lock。 Active(‘Active’ == Non-idle sessions) Session History Licensed as part of the Diagnostic pack,

Know More about Oracle AWR

by

一段时间以来，Oracle在此领域的解决方案一直是其内置工具Statspack。Oracle数据库10g进行了重大改进：自动工作量存储库（AWR）。AWR与数据库一起安装，不仅捕获统计信息，还捕获捕获的指标。

Script: RMAN backup shell on linux

by

# make direcory for backset file and scripts file,in my case /backup/db_bak cd   /backup/db_bak mkdir  scripts logs rman #  the following is contents of  rman_backup_sh vi  /backup/db_bak/scripts/rman_backup_sh #!/bin/bash # author: anbob.com # desc: rman backup database level 0 # contact: weejar@gmail.com export ORACLE_HOME=/oracle/product/11.2.0/db_1 export ORACLE_SID=pora40 RMAN_LOG_FILE=/backup/db_bak/logs/rman_database_backup.`date +%y%m%d%H%M`.out # —————————————————————– # Initialize the log file. # … Read more

How to hanganalyze and systemstate dumps for Oracle database？

by

Oracle support request hang analysis and system state dumps when rasing SR. One 10.1 or higher versions login as sqlplus -prelim / as sysdba To do a hanganalyze oradebug setmypid; oradebug unlimit; oradebug hanganalyze 3; Wait 60 – 90 seconds and run the last command again to identify the process state changes. To get a … Read more

script:purge ADR file

by

[oracle@db231 ~]$ ./adr_purge
INFO: Purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purging diagnostic destination diag/tnslsnr/db231/listener
INFO: purging ALERT older than 90 days …
INFO: purging INCIDENT older than 30 days …