ORA-03113 ORA-24324 ORA-01041

最新推荐文章于 2024-07-22 11:22:30 发布

aaaaaaaa2000

最新推荐文章于 2024-07-22 11:22:30 发布

阅读量2.3k

点赞数

分类专栏： oracle 文章标签： oracle exception object extension redhat signal

本文链接：https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7598467

版权

oracle 专栏收录该内容

53 篇文章

订阅专栏

SQL> startup
ORA-03113: end-of-file on communication channel
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

SQL>

此时去查看alter日志发现：
[oracle@localhost bdump]$ more alert_jiaoyoubi.log
Thu May 24 15:06:13 2012
Starting ORACLE instance (normal)
Thu May 24 15:06:13 2012
Errors in file /home/oracle/admin/jiaoyoubi/udump/jiaoyoubi_ora_2673.trc:
ORA-07445: exception encountered: core dump [sskgmqstable()+379] [SIGSEGV] [Address not mapped to object] [0x2CBD2BE0] [] []
在sartup的时候直接就是一个这个错误，下面再没有了
[oracle@localhost bdump]$ more /home/oracle/admin/jiaoyoubi/udump/jiaoyoubi_ora_2673.trc
/home/oracle/admin/jiaoyoubi/udump/jiaoyoubi_ora_2673.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/product/10.2.0/db_1
System name: Linux
Node name: localhost.localdomain
Release: 2.6.18-8.el5PAE
Version: #1 SMP Fri Jan 26 14:28:43 EST 2007
Machine: i686
Instance name: jiaoyoubi
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Unix process pid: 2673, image: oracle@localhost.localdomain

skgm error 27123: errno = 0, info = 4, 128, 0, 0
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x2cbd2be0, PC: [0xac7415f, sskgmqstable()+379]
Registers:
%eax: 0xfffffff2 %ebx: 0x0cb84448 %ecx: 0x0000000d
%edx: 0x0cbd2b80 %edi: 0x00002000 %esi: 0x07ffffff
%esp: 0xbff51ccc %ebp: 0xbff51d08 %eip: 0x0ac7415f
%efl: 0x00010206
sskgmqstable()+366 (0xac74152) and $31,%ecx
sskgmqstable()+369 (0xac74155) xor $31,%ecx
sskgmqstable()+372 (0xac74158) mov $0x1,%edi
sskgmqstable()+377 (0xac7415d) shl %cl,%edi
> sskgmqstable()+379 (0xac7415f) test %edi,0x64(%edx,%esi,4)
sskgmqstable()+383 (0xac74163) jne 0xac741c6
sskgmqstable()+385 (0xac74165) mov 0xfffffff8(%ebp),%ecx
sskgmqstable()+388 (0xac74168) add $1,%eax
sskgmqstable()+391 (0xac7416b) cmp %ecx,%eax
*** 2012-05-24 15:06:13.349
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [sskgmqstable()+379] [SIGSEGV] [Address not mapped to object] [0x2CBD2BE0] [] []
Current SQL information unavailable - no SGA

这个不知道怎么解决了....
只好删除重新安装了，
删除oracle的步骤：

1. 运行 $ORACLE_HOME/bin/localconfig delete
2. rm -rf $ORACLE_BASE/*
3. rm -f /etc/oraInst.loc /etc/oratab
4. rm -rf /etc/oracle
5. rm -f /etc/inittab.cssd
6. rm -f /usr/local/bin/coraenv /usr/local/bin/dbhome /usr/local/bin/oraenv

7. 删除oracle用户和组。-----如果还要安装就不用删除用户

只能重新安装，这次安装完成只好数据库可以正常打开没有问题
现在想第一次为什么会出错那？
1、没有执行root.sh脚本------在使用slient安装的时候没有提示要执行，11g的时候改进了提示要执行，10g还有sys会配置默认密码，而11g的时候会让用户自己输入密码
2、没有安装好compat那2个rpm包----这个是因为10g还不支持redhat5，导致系统包检查那块根本就没有做，导致我也没检查出来