oracle 错误ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-00600: internal
来源:互联网 发布:java下载 编辑:程序博客网 时间:2024/05/01 12:25
由于active redo损坏,使用_allow_resetlogs_corruption参数resetlog启动,报以下错误:
Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_29192.trc:
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwpost1
ORA-27303: additional information: semid = 1441793
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Doing block recovery for file 3 block 2480
No block recovery was needed
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3BBA1BBA] [PC:0x2297714, kgegpa()+40] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3BBA1BBA] [PC:0x229593F, kgebse()+279] [flags: 0x2, count: 2]
解决:
[oracle@testdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 6 16:03:14 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance
SQL> startup mount
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 490735648 bytes
Database Buffers 335544320 bytes
Redo Buffers 6606848 bytes
Database mounted.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_management=manual scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 490735648 bytes
Database Buffers 335544320 bytes
Redo Buffers 6606848 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>
SQL>
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/orcl/system01.dbf
/u01/oracle/oradata/orcl/sysaux01.dbf
/u01/oracle/oradata/orcl/undotbs01.dbf
/u01/oracle/oradata/orcl/users01.dbf
/u01/oracle/oradata/orcl/example01.dbf
SQL> create undo tablespace undotbs02 datafile '/u01/oracle/oradata/orcl/undotbs02.dbf' size 128m;
Tablespace created.
SQL> alter system set undo_tablespace='undotbs02' scope=spfile;
System altered.
SQL> alter system set undo_management=auto scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
再启动,ok 原因由回滚段错误引起。
我这里是因为意外断电,导致数据库无法启动,自己shutdown,通过以上操作数据库成功恢复。
- oracle 错误ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-00600: internal
- ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-00600: internal error cod
- Ora-27300 OS system dependent operation:fork failed with status: 11 [ID 392006.1]
- ORA-27300: OS system dependent operation:fork failed with status: 12
- ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- ora-00600: internal error code, arguments: [kpotcgah-7], [12534], [ora-12534: TNS:operation not supp
- oracle数据库错误:ORA-01033、ORA-00600、ORA-01589
- ORA-00245: control file backup operation failed
- ORA-00245: control file backup operation failed
- ORACLE ORA-00600 错误解决
- MOS文章实验:ORA-01722 from Queries with Dependent Predicates
- impdp failed with ORA-39002, ORA-31694 and ORA-31644
- Oracle 11g启动报ORA-28056、OS 1502错误
- 如何解决ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], []错误!
- 如何解决ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], []错误!
- ORA-00600 错误 internal error code, arguments: [kkslgbv0], [], [], [], [], [], [], [ ]
- CB的PageControl控件动态删除TABSHEET
- 自己理解的游戏开发
- 【实例】表单跨页(内容在一个ActionForm)中保存
- 101 个 MySQL 的调节和优化的提示
- DLL文件——让我来管理(一)
- oracle 错误ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-00600: internal
- TCP序列号和确认号详解
- 创建Material Design风格的Android应用--应用主题
- 自制全铝CNC雕刻机全过程(完工篇)
- 一个国内的 ngrok 服务器
- HDU2444 The Accomodation of Students(二分匹配 匈牙利算法)
- Practical C Programming - Chapter 9
- 如何导入frm格式MYD格式MYI格式文件到MySQL中
- oracle 中的translate函数