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