oracle数据库常见真实问题处理步骤

《oracle数据库常见真实问题处理步骤》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、1解决Oracle9.2.0.6版本数据库由于0RA-07445宕机问题故障现象：XX网数据库宕机，查看H志发现以下内容：WedJun820:24:172005Errorsinfileu02apporacleadminunicornudumpunicom_ora_661.trc:ORA07445:263366317326322354263243:272313320304327252264242[0000000101C3089C][SIGSEGV][Addressnotmappedtoobject][0x000000000][][]

2、WedJun820:24:222005Errorsinfileu02apporacleadminunicornbdumpunicom_pmon_11598.trc:0RA-07445:exceptionencountered:coredump[0000000101C399A0][SIGSEGV][Addressnotmappedtoobject][0x000000000][][]WedJun820:24:232005Errorsinfileu02apporacleadminunicornbdumpunicom_pmon_11598.trc:0RA-07445:e

3、xceptionencountered:coredump[0000000101C399A0][SIGSEGV][Addressnotmappedtoobject][0x000000000][][]ORA-00602:internalprogrammingexceptionORA07445:exceptionencountered:coredump[0000000101C399A0][SIGSEGV][Addressnotmappedtoobject][0x000000000][][]WedJun820:24:332005CKPT:terminatinginsta

4、nceduetoerror472InstanceterminatedbyCKPT,pid=11604WedJun821:04:472005StartingORACLEinstance(normal)解决办法：工程师建议安装Oracle补丁p3949307_9206_S0LARIS64,经过测试,安装步骤如下：(注意，首先shutdown数据库)1，解压补丁文件unzipp3949307_9206_S0LARIS64.zip解开后的B录是：40607562,修改oraclehoraeproperties.xml文件，该文件在$ORACLEHOME/invcntor

5、y/ContcntsXML目录下。cporac1ehomeproperties.xmlorac1ehomeproperties.xmlb.bakvioraclehomeproperties.xml更改数字453—>23,存盘退出3,修改PATH路径为PATH=$ORACLE.HOME/bin:/usr/ccs/bin:${PATH}4,执行opatchapply命令cd4060756$ORACLE_HOME/OPatch/opatchapply5,安装k功后会出现如下结果Updatinginventory.../oracle92/app/oracle/produ

6、ct/9.2.0.1/OPatch/opatch.piversion:1.0.0.0.51Copyright(c)2001-2004OracleCorporation.AllRightsReserved.OPatchsucceeded.2查看Oracle表空间大小及利用率的SQL语句一非常实用的语句setlinesize300col表空间名fora30SELECTUPPER(F.TABLESPACE_NAME)〃表空间名'D.TOT_GROOTTR_MB〃表空间f小(M)〃，D.TOT_GROOTTEJ1B-F.TOTAL_BYTES〃己使用空间(M)〃，TO一

7、CHAR(ROUND((D.T0T_GR00TTEJIBF.TOTALJiYTES)/D.TOT_GKOOTTEJB*100,2),’990.99’)〃使用比〃，F.TOTAL_BYTES〃空闲空间(M)〃，F.MAX_BYTES〃最大块(M)〃FROM(SELECTTABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2)TOTAL_BYTES,ROUND(MAX(BYTES)/(1024*1024),2)MAX_BYTESFROMSYS.DBAFREESPACEGROUPBYTABLESPACE_NAME)F,(SELEC

8、TDD.TABLESPA