ORA-07445 ORA-24324 ORA-01041错误

转载： http://hi.baidu.com/wholke/blog/item/b1836d617acf1742eaf8f8cf.html

ORA-07445 ORA-24324 ORA-01041错误

2008-09-08 12:35

今天早上接到电话说数据库听了,来了一看数据库已经down了,有监听,没有实例和进程但是有部分会话连接.alert错误是: Thread 1 advanced to log sequence 55275 Current log# 1 seq# 55275 mem# 0: /oradb2/oradata/gpnms4c/redo01,log Current log# 1 seq# 55275 mem# 1: /oradb1/oradata/gpnms4c/redo01.log Mon Sep 8 02:01:25 2008 ARC1: Completed archiving log 2 thread 1 sequence 55274 Mon Sep 8 02:06:36 2008 Errors in file /opt/oracle/product/9i/admin/gpnms4c/udump/gpnms4c_ora_1639.trc: ORA-07445: exception encountered: core dump [0000000100A48710] [SIGSEGV] [Address not mapped to object] [0x000000021] [] [] Mon Sep 8 02:07:46 2008 Errors in file /opt/oracle/product/9i/admin/gpnms4c/udump/gpnms4c_ora_2166.trc: ORA-07445: exception encountered: core dump [0000000100A48710] [SIGSEGV] [Address not mapped to object] [0x000000021] [] [] Mon Sep 8 02:11:48 2008 Errors in file /opt/oracle/product/9i/admin/gpnms4c/bdump/gpnms4c_smon_9273.trc: ORA-07445: ????: ???? [0000000100A48710] [SIGSEGV] [Address not mapped to object] [0x000000021] [] [] Mon Sep 8 02:11:54 2008 Errors in file /opt/oracle/product/9i/admin/gpnms4c/bdump/gpnms4c_pmon_9265.trc: ORA-00474: SMON ???????? Mon Sep 8 02:11:54 2008 PMON: terminating instance due to error 474 Instance terminated by PMON, pid = 9265| 想着先停止数据库,停止所有应用以后,停止数据库 SQL> shutdown immediate ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory SQL> 没有实例,数据库对象不可用,停止操作无效.于是重新启动数据库. SQL> startup pfile=/opt/oracle/product/9i/admin/gpnms4c/pfile/initgpnms4c.ora ORACLE instance started. Total System Global Area 2451542096 bytes Fixed Size                   733264 bytes Variable Size            1375731712 bytes Database Buffers         1073741824 bytes Redo Buffers                1335296 bytes Database mounted. Database opened. SQL> 启动成功,再次关闭数据库. SQL>shutdown immediate 长时间不能关闭数据库,于是手工把oracle所有进程kill掉,把所有的sqlplus进程kill掉.刚才关闭会话终止. 重新关闭数据库. SQL> shutdown immediate ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist SQL> 现在无论启动和关闭操作都报这个错误.服务句柄无效.对象找不到主机. 郁闷了好长时间,开始找问题…… 明白刚才把sqlplus给kill掉了.所以没有对应的环境了.愚蠢的错误.重新开一个sqlplus,启动数据库. SQL> startup pfile=/opt/oracle/product/9i/admin/gpnms4c/pfile/initgpnms4c.ora ORACLE instance started. Total System Global Area 2451542096 bytes Fixed Size                   733264 bytes Variable Size            1375731712 bytes Database Buffers         1073741824 bytes Redo Buffers                1335296 bytes Database mounted. Database opened. SQL> 启动成功. 呵呵,一个郁闷的错误.让人值得去想想.为我们的每一个操作考虑好后果和影响.也许,我们在不经意间就犯了一个错误. 技术容不的马虎!