Oracle数据库常见问题处理(1)
一、解决Oracle 9.2.0.6版本数据库由于ORA-07445宕机问题
故障现象:
XX网数据库宕机,查看日志发现以下内容:
Wed Jun 8 20:24:17 2005
Errors in file /u02/app/oracle/admin/unicom/udump/unicom_ora_661.trc:
ORA-07445: \263\366\317\326\322\354\263\243: \272\313\320\304\327\252\264\242 [00000 00101C3089C] [SIGSEGV] [Address not mappe
d to object] [0x000000000] [] []
Wed Jun 8 20:24:22 2005
Errors in file /u02/app/oracle/admin/unicom/bdump/unicom_pmon_11598.trc:
ORA-07445: exception encountered: core dump [0000000101C399A0] [SIGSEGV] [Address no t mapped to object] [0x000000000] [] []
Wed Jun 8 20:24:23 2005
Errors in file /u02/app/oracle/admin/unicom/bdump/unicom_pmon_11598.trc:
ORA-07445: exception encountered: core dump [0000000101C399A0] [SIGSEGV] [Address no t mapped to object] [0x000000000] [] []
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [0000000101C399A0] [SIGSEGV] [Address no t mapped to object] [0x000000000] [] []
Wed Jun 8 20:24:33 2005
CKPT: terminating instance due to error 472
Instance terminated by CKPT, pid = 11604
Wed Jun 8 21:04:47 2005
Starting ORACLE instance (normal)
|
解决办法:
Oracle工程师建议安装Oracle补丁p3949307_9206_SOLARIS64,经过测试,安装步骤如下注意,首先shutdown数据库):
1.解压补丁文件:
unzip p3949307_9206_SOLARIS64.zip
解开后的目录是:4060756 。
2.修改oraclehomeproperties.xml文件,该文件在$ORACLE_HOME/inventory/ContentsXML目录下:
cp oraclehomeproperties.xml oraclehomeproperties.xmlb.bak
vi oraclehomeproperties.xml
更改数字453 ->23,存盘退出。
3.修改PATH路径为:
PATH=$ORACLE_HOME/bin:/usr/ccs/bin:${PATH}
4.执行opatch apply命令:
cd 4060756
$ORACLE_HOME/OPatch/opatch apply
5.安装成功后会出现如下结果:
Updating inventory...
/oracle92/app/oracle/product/9.2.0.1/OPatch/opatch.pl version: 1.0.0.0.51
Copyright (c) 2001-2004 Oracle Corporation. All Rights Reserved.
OPatch succeeded.
|
http://www.htsjk.com/shujukugl/18130.html
www.htsjk.Com
true
http://www.htsjk.com/shujukugl/18130.html
NewsArticle
Oracle数据库常见问题处理(1) 一、解决Oracle 9.2.0.6版本数据库由于ORA-07445宕机问题 故障现象: XX网数据库宕机,查看日志发现以下内容: Wed Jun 8 20:24:17 2005Errors in file /u02/app/oracle/admin/u...
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。