解决Oracle 9.2.0.6版本数据库由于ORA-07445宕机问题

最新推荐文章于 2021-04-06 22:13:09 发布

cuizhu0832

最新推荐文章于 2021-04-06 22:13:09 发布

阅读量174

点赞数

IT168技术文章】
1 解决Oracle 9.2.0.6版本数据库由于ORA-07445宕机问题
故障现象：
XX网数据库宕机，查看日志发现以下内容：

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--&gt 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 [ 0000000101C3089C ] [ 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 not 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 not mapped to object ] [ 0x000000000 ] [] []
ORA - 00602 : internal programming exception
ORA - 07445 : exception encountered: core dump [ 0000000101C399A0 ] [ SIGSEGV ] [ Address not 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.

2 查看Oracle表空间大小及利用率的SQL语句－非常实用的语句

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--&gt set linesize 300
col 表空间名 for a30
SELECT UPPER (F.TABLESPACE_NAME) "表空间名",
D.TOT_GROOTTE_MB "表空间大小(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)",
TO_CHAR( ROUND ((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100 ,
2 ),
' 990.99 ' ) "使用比",
F.TOTAL_BYTES "空闲空间(M)",
F.MAX_BYTES "最大块(M)"
FROM ( SELECT TABLESPACE_NAME,
ROUND ( SUM (BYTES) / ( 1024 * 1024 ), 2 ) TOTAL_BYTES,
ROUND ( MAX (BYTES) / ( 1024 * 1024 ), 2 ) MAX_BYTES
FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
( SELECT DD.TABLESPACE_NAME,
ROUND ( SUM (DD.BYTES) / ( 1024 * 1024 ), 2 ) TOT_GROOTTE_MB
FROM SYS.DBA_DATA_FILES DD
GROUP BY DD.TABLESPACE_NAME) D
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
ORDER BY 4 DESC ;

转自： http://tech.it168.com/a2008/0924/206/000000206251.shtml

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-464323/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/90618/viewspace-464323/