ORA-03113 ORA-27103: internal error MMAN (ospid: 21061)
来源:互联网 发布:st单片机代理 编辑:程序博客网 时间:2024/06/10 09:12
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1.0088E+10 bytes
Fixed Size 2162320 bytes
Variable Size 5301600624 bytes
Database Buffers 4764729344 bytes
Redo Buffers 19697664 bytes
ORA-03113: end-of-file on communication channel
Process ID: 31529
Session ID: 280 Serial number: 3
oracle环境:10.137.5.87
---原因分析:
在oracle的alert日志中报错:
Errors in file /opt/oracle/diag/rdbms/oracle/oracle/trace/oracle_mman_21061.trc:
ORA-27103: internal error
Linux-x86_64 Error: 17: File exists
Additional information: -1
Additional information: 1
MMAN (ospid: 21061): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 21061
Wed Sep 15 10:20:50 2010
这个是oracle的在11.1.0.7上的bug,与我们的参数设置有关系 memory_target 设置超过3G 后会触发此bug,解决方式:
Due to Bug:7272646
This problem is introduced in 11.1.0.7 on 64bit Linux .
In some cases after applying the 11.1.0.7 patch set on 64Bit Linux x86 the instance will not start when
MEMORY_TARGET > 3GB.
Solution
To solve the issue need to do the following :
1.) Download and apply Patch 7272646 available on metalink for Linux x86-64 11.1.0.7
2.) After applying the patch, test with memory_target set > 3GBto verify patch resolves issue
create pfile ='initwsj.ora' from spfile='/dev/vx/rdsk/vgora/lv_spfile';
oracle.__db_cache_size=4764729344
oracle.__java_pool_size=67108864
oracle.__large_pool_size=67108864
oracle.__oracle_base='/opt/oracle'#ORACLE_BASE set from environment
oracle.__pga_aggregate_target=4093640704
oracle.__sga_target=6039797760
oracle.__shared_io_pool_size=0
oracle.__shared_pool_size=1073741824
oracle.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/oracle/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/dev/vx/rdsk/vgora/lv_ctl01','/dev/vx/rdsk/vgora/lv_ctl02','/dev/vx/rdsk/vgora/lv_ctl03'
*.db_block_size=4096
*.db_domain=''
*.db_name='oracle'
*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/opt/oracle'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=10077863936
*.open_cursors=300
*.processes=250
*.remote_listener=''
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=TRUE
*.sessions=280
*.undo_tablespace='UNDOTBS1'
目前设置的是10G,需要调整为小于3G,然后打oracle的补丁。
恢复方式:
修改initwsj.ora 中的配置,与内存有关的大小调整memory_target 调整为小于3 G,转换成bit
其他参与也要相应调整或删除
oracle.__db_cache_size=4764729344
oracle.__java_pool_size=67108864
oracle.__large_pool_size=67108864
oracle.__pga_aggregate_target=4093640704
oracle.__sga_target=6039797760
oracle.__shared_io_pool_size=0
oracle.__shared_pool_size=1073741824
oracle.__streams_pool_size=0
然后从initcao.ora启动
sql>startup pfile =initwsj.ora;
启动成功后再恢复spfile
sql>create spfile='/dev/vx/rdsk/vgora/lv_spfile' from pfile='initwsj.ora';
重启oracle
- ORA-03113 ORA-27103: internal error MMAN (ospid: 21061)
- ORA-39006: internal error
- ORA-00600: internal error code
- ORA-00600 internal error code, arguments
- ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [ksuinfos_modact1], [], [], [], [], [], [], []
- ORA-00257: archiver error. Connect internal only
- ora-00600 internal error code arguments: [kcratrl_lastbwr],[],[],[],[],[],[],[]
- ORA-00257: archiver error. Connect internal only
- ORA-00600: internal error code, arguments: [19004]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [1265]
- ORA-00600: internal error code, arguments: [17182]
- ORA-00600: internal error code, arguments: [keltnf
- ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
- ORA-00600 internal error code,arguments: 问题
- ORA-00600: internal error code, arguments: [kdsgrp1]
- 【设计模式-外观模式】facade模式
- POJ 1743 后缀数组+分组二分
- 使用share SDK实现人人网授权登录分享(1.x版本)
- SQLQuery接口addScalar方法
- JSONObject与JSONArray的使用
- ORA-03113 ORA-27103: internal error MMAN (ospid: 21061)
- JAVA--将二进制流转换成图片文件
- 导致电脑网速变慢的几个方面
- JS把字符串按照特定的字母顺序进行排序
- Objc中Block的原理、实现及注意事项
- P2P的原理和常见的实现方式
- 进程创建和进程终止
- 一键导出更快捷——Aspose.Words使用Export to PDF宏
- 最快的内容查找算法-----暴雪的Hash算法