今天早上接到电话说数据库听了,来了一看数据库已经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>
启动成功.
呵呵,一个郁闷的错误.让人值得去想想.为我们的每一个操作考虑好后果和影响.也许,我们在不经意间就犯了一个错误.
技术容不的马虎!
