oracle数据库的一次异常起停处理。

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了oracle数据库的一次异常起停处理。，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5693字，纯文字阅读大概需要9分钟。

内容图文

在重启数据库的时候，忘记把一个应用关停了，想起来的时候，就ctrl+c,把数据库shutdown immediate 给强制停下了，把该应用再停止，然后shutdown immdiate，这时候数据报错了。

oracle@NMSSERVER1:~> sqlplus ‘/as sysdba‘

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 3 18:07:35 2016

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
^C^C^C^C^C

^C^C^C^C

ORA-12152: TNS:unable to send break message

 

SQL> SQL> SQL> SQL>
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn‘t exist
SQL>
SQL>
SQL>
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn‘t exist
SQL>
SQL>
SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn‘t exist
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn‘t exist
SQL>

 

 

 

此时alert日志的情况如下：

Additional information: 1
Additional information: 32823
Tue May 03 18:05:16 2016
Errors in file /opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/trace/pm4h_m000_21073.trc:
ORA-51106: check failed to complete due to an error. See error below
ORA-48101: error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/metadata/HM_FINDING.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
Additional information: 64840
Additional information: 1
Additional information: 32823
Tue May 03 18:06:45 2016
Errors in file /opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/trace/pm4h_m000_25185.trc:
ORA-51106: check failed to complete due to an error. See error below
ORA-48101: error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/metadata/HM_FINDING.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
Additional information: 64840
Additional information: 1
Additional information: 32823
Tue May 03 18:07:25 2016
opidcl aborting process unknown ospid (58374) as a result of ORA-2396
Tue May 03 18:07:26 2016

***********************************************************************

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 03-MAY-2016 18:07:26
Tracing not turned on.
Tns error struct:
ns main err code: 12547

TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (29320) as a result of ORA-609
Tue May 03 18:07:29 2016
opidcl aborting process unknown ospid (58149) as a result of ORA-2396
Tue May 03 18:07:44 2016
Errors in file /opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/trace/pm4h_m000_29720.trc:
ORA-51106: check failed to complete due to an error. See error below
ORA-48101: error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/metadata/HM_FINDING.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
Additional information: 64840
Additional information: 1
Additional information: 32823
Tue May 03 18:08:50 2016
Errors in file /opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/trace/pm4h_m000_31031.trc:
ORA-51106: check failed to complete due to an error. See error below
ORA-48101: error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/metadata/HM_FINDING.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
Additional information: 64840
Additional information: 1
Additional information: 32823
Tue May 03 18:10:03 2016
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Tue May 03 18:10:05 2016
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1426
Tue May 03 18:11:17 2016
ALTER DATABASE CLOSE NORMAL
Tue May 03 18:11:21 2016
SMON: disabling tx recovery
SMON: disabling cache recovery
^C

 

 

 

 

处理的措施：

1.查看共享内存资源
 ipcs -pmb

 

oracle@NMSSERVER1:~> ipcs -pm;

------ Shared Memory Creator/Last-op PIDs --------
shmid owner cpid lpid
3145744 oracle 14924 32669
3178513 oracle 14924 32669
3211282 oracle 14924 32669
3244051 oracle 14924 32669
3276820 oracle 14924 32669
3309589 oracle 14924 32669
3342358 oracle 14924 32669
3375127 oracle 14924 32669
3407896 oracle 14924 32669
3440665 oracle 14924 32733

oracle资源在占用，所以必须进行资源释放，执行如下操作：

oracle@NMSSERVER1:~> ipcrm -m 3145744

（这里必须一个一个的停，不能一次停 多个）

2.

SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SQL> startup force;
ORACLE instance started.

Total System Global Area 5.1310E+10 bytes
Fixed Size 2240344 bytes
Variable Size 3.1139E+10 bytes
Database Buffers 2.0133E+10 bytes
Redo Buffers 36098048 bytes
Database mounted.
Database opened.

oracle数据库的一次异常起停处理。

标签：

本文系统来源：http://www.cnblogs.com/gaochsh/p/5456960.html

内容总结

以上是互联网集市为您收集整理的oracle数据库的一次异常起停处理。全部内容，希望文章能够帮你解决oracle数据库的一次异常起停处理。所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---