服务器下电几天后今天上电,数据库却怎么也起不了了,具体情况如下:SQL> startup
ORACLE instance started.Total System Global Area 5010685952 bytes
Fixed Size 2159272 bytes
Variable Size 3758099800 bytes
Database Buffers 1207959552 bytes
Redo Buffers 42467328 bytes
ORA-03113: end-of-file on communication channel
Process ID: 5465
Session ID: 665 Serial number: 3
alert.log文件片段:
Mon Jul 30 07:40:40 2007
MMNL started with pid=15, OS id=5872
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Mon Jul 30 07:40:40 2007
ALTER DATABASE MOUNT
Errors in file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 5858): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 5858
amw_mman_5858文件内容:
Trace file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11g/db
System name: Linux
Node name: linux58
Release: 2.6.16.46-0.12-smp
Version: #1 SMP Thu May 17 14:00:09 UTC 2007
Machine: x86_64
Instance name: amw
Redo thread mounted by this instance: 0 <none>
Oracle process number: 8
Unix process pid: 5858, image: oracle@linux58 (MMAN)
*** 2007-07-30 07:40:43.629
*** SESSION ID:(658.1) 2007-07-30 07:40:43.629
*** CLIENT ID:() 2007-07-30 07:40:43.629
*** SERVICE NAME:() 2007-07-30 07:40:43.629
*** MODULE NAME:() 2007-07-30 07:40:43.629
*** ACTION NAME:() 2007-07-30 07:40:43.629error 27103 detected in background process
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1*** 2007-07-30 07:40:43.629
MMAN (ospid: 5858): terminating the instance due to error 27103
看日志里面的报错,好像是说资源不足,下面把我的机器资源贴出来:
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 21G 6.1G 14G 31% /
udev 7.9G 112K 7.9G 1% /dev
/dev/sda6 25G 14G 11G 57% /home
/dev/sda5 16G 15G 626M 96% /opt
shm 8.1G 80K 8.1G 1% /dev/shmtop - 09:49:06 up 28 min, 2 users, load average: 0.00, 0.00, 0.00
Tasks: 118 total, 1 running, 117 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16437760k total, 370028k used, 16067732k free, 19828k buffers
Swap: 8393920k total, 0k used, 8393920k free, 242312k cached
600M+的硬盘空间应该足够启动了吧??大家遇到过这样的问题么???请帮忙看看,3Q!!!
ORACLE instance started.Total System Global Area 5010685952 bytes
Fixed Size 2159272 bytes
Variable Size 3758099800 bytes
Database Buffers 1207959552 bytes
Redo Buffers 42467328 bytes
ORA-03113: end-of-file on communication channel
Process ID: 5465
Session ID: 665 Serial number: 3
alert.log文件片段:
Mon Jul 30 07:40:40 2007
MMNL started with pid=15, OS id=5872
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Mon Jul 30 07:40:40 2007
ALTER DATABASE MOUNT
Errors in file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 5858): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 5858
amw_mman_5858文件内容:
Trace file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11g/db
System name: Linux
Node name: linux58
Release: 2.6.16.46-0.12-smp
Version: #1 SMP Thu May 17 14:00:09 UTC 2007
Machine: x86_64
Instance name: amw
Redo thread mounted by this instance: 0 <none>
Oracle process number: 8
Unix process pid: 5858, image: oracle@linux58 (MMAN)
*** 2007-07-30 07:40:43.629
*** SESSION ID:(658.1) 2007-07-30 07:40:43.629
*** CLIENT ID:() 2007-07-30 07:40:43.629
*** SERVICE NAME:() 2007-07-30 07:40:43.629
*** MODULE NAME:() 2007-07-30 07:40:43.629
*** ACTION NAME:() 2007-07-30 07:40:43.629error 27103 detected in background process
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1*** 2007-07-30 07:40:43.629
MMAN (ospid: 5858): terminating the instance due to error 27103
看日志里面的报错,好像是说资源不足,下面把我的机器资源贴出来:
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 21G 6.1G 14G 31% /
udev 7.9G 112K 7.9G 1% /dev
/dev/sda6 25G 14G 11G 57% /home
/dev/sda5 16G 15G 626M 96% /opt
shm 8.1G 80K 8.1G 1% /dev/shmtop - 09:49:06 up 28 min, 2 users, load average: 0.00, 0.00, 0.00
Tasks: 118 total, 1 running, 117 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16437760k total, 370028k used, 16067732k free, 19828k buffers
Swap: 8393920k total, 0k used, 8393920k free, 242312k cached
600M+的硬盘空间应该足够启动了吧??大家遇到过这样的问题么???请帮忙看看,3Q!!!
主题: ORA-27103 when Memory target parameter is set to more than 3 GB
文档 ID: 743012.1 类型: PROBLEM
上次修订日期: 08-OCT-2009 状态: PUBLISHED In this Document
Symptoms
Changes
Cause
Solution
References--------------------------------------------------------------------------------Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.7
Linux x86-64Symptoms
When setting the memory_target parameter on 11.1.0.7 > 3 GB , The instance can not start up and crashes with the following errors displayed in the alert log :
ALTER DATABASE MOUNT
This instance was first to mount
Errors in file /oracle/app/oracle/diag/rdbms/dwhp/DWHP1/trace/DWHP1_mman_22192.trc:
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 22192): terminating the instance due to error 27103
System state dump is made for local instance
System State dumped to trace file /oracle/app/oracle/diag/rdbms/dwhp/DWHP1/trace/DWHP1_diag_22166.trc
Trace dumping is performing id=[cdmp_20080929103326]
Instance terminated by MMAN, pid = 22192OR:Errors in file /app/oemrep/diag/rdbms/emrep/emrep/trace/emrep_mman_30849.trc:
ORA-27103: internal error
Linux-x86_64 Error: 17: File exists
Additional information: -1
Additional information: 1
MMAN (ospid: 30849): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 30849
This issue is not reproduced in 11.1.0.6Changes
Applied the 11.1.0.7 patch set. Cause
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 > 3GB to verify patch resolves issue.References