内存不足导致安装时报错ORA-3113（一）

最新推荐文章于 2021-04-16 08:07:01 发布

ckawt40802

最新推荐文章于 2021-04-16 08:07:01 发布

阅读量131

点赞数

文章标签：数据库操作系统网络

在安装11.2 RAC环境时，碰到了这个错误。

安装RAC数据库时报错ORA-3113。

检查dbca对应的信息：

bash-3.00$ cd /data/oracle/cfgtoollogs/dbca/testrac/
bash-3.00$ more CreateDB.log
ORA-27102: out of memory
SVR4 Error: 12: Not enough space
ORA-03113: 通信通道的文件结尾

这其实是两次安装错误的汇总，第一次设置memory_target为2.8G，直接就报错out of memory，于是将内存修改为2G左右，结果出现了这个ORA-3113错误。

检查数据库的alert文件：

bash-3.00$ cd /data/oracle/diag/rdbms/testrac/testrac1/trace/
bash-3.00$ tail -100 alert_testrac1.log
System parameters with non-default values:
processes                = 300
sessions                 = 472
nls_language             = "SIMPLIFIED CHINESE"
nls_territory            = "CHINA"
memory_target            = 2G
db_block_size            = 16384
compatible               = "11.2.0.0.0"
log_archive_dest_1       = "LOCATION=+DATA"
log_archive_format       = "%t_%s_%r.dbf"
db_create_file_dest      = "+DATA"
db_recovery_file_dest    = "+DATA"
db_recovery_file_dest_size= 64G
undo_tablespace          = "UNDOTBS1"
instance_number          = 1
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers              = "(PROTOCOL=TCP) (SERVICE=testracXDB)"
remote_listener          = ""
audit_file_dest          = "/data/oracle/admin/testrac/adump"
audit_trail              = "DB"
db_name                  = "testrac"
open_cursors             = 300
diagnostic_dest          = "/data/oracle"
Cluster communication is configured to use the following interface(s) for this instance
10.0.0.1
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Fri Dec 17 12:43:31 2010
PMON started with pid=2, OS id=20946
Fri Dec 17 12:43:31 2010
VKTM started with pid=3, OS id=20951 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Fri Dec 17 12:43:31 2010
GEN0 started with pid=4, OS id=20955
Fri Dec 17 12:43:31 2010
DIAG started with pid=5, OS id=20963
Fri Dec 17 12:43:31 2010
DBRM started with pid=6, OS id=20965
Fri Dec 17 12:43:31 2010
PING started with pid=7, OS id=20967
Fri Dec 17 12:43:32 2010
PSP0 started with pid=8, OS id=20972
Fri Dec 17 12:43:32 2010
ACMS started with pid=9, OS id=20977
Fri Dec 17 12:43:32 2010
DIA0 started with pid=10, OS id=20979
Fri Dec 17 12:43:32 2010
LMON started with pid=11, OS id=20987
Fri Dec 17 12:43:34 2010
LMD0 started with pid=12, OS id=20989
Fri Dec 17 12:43:34 2010
RMS0 started with pid=13, OS id=21009
Fri Dec 17 12:43:34 2010
LMHB started with pid=14, OS id=21011
Fri Dec 17 12:43:34 2010
MMAN started with pid=15, OS id=21019
Fri Dec 17 12:43:34 2010
DBW0 started with pid=16, OS id=21021
Fri Dec 17 12:43:34 2010
LGWR started with pid=17, OS id=21023
Fri Dec 17 12:43:35 2010
CKPT started with pid=18, OS id=21028
Fri Dec 17 12:43:35 2010
SMON started with pid=19, OS id=21033
Fri Dec 17 12:43:35 2010
RECO started with pid=20, OS id=21035
Fri Dec 17 12:43:35 2010
MMON started with pid=21, OS id=21043
Fri Dec 17 12:43:35 2010
MMNL started with pid=22, OS id=21045
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
DISM started, OS id=21054
Fri Dec 17 12:44:02 2010
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF2000] [PC:0xFFFFFFFF7CC32FA4, clskGetStackTraceBuf()+20] [flags: 0x0, count: 1]
Fri Dec 17 12:44:03 2010
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF5F50] [PC:0x10777F280, sdbgrfcfp_convert_fileloc_pathfile()+64] [flags: 0x0, count: 1]
Errors in file /data/oracle/diag/rdbms/testrac/testrac1/trace/testrac1_lmon_20987.trc (incident=2489):
ORA-07445: ??????: ???? [clskGetStackTraceBuf()+20] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF2000] [PC:0xFFFFFFFF7CC32FA4] [Address not mapped to object] []
Incident details in: /data/oracle/diag/rdbms/testrac/testrac1/incident/incdir_2489/testrac1_lmon_20987_i2489.trc
Errors in file /data/oracle/diag/rdbms/testrac/testrac1/trace/testrac1_psp0_20972.trc (incident=2465):
ORA-07445: ??????: ???? [sdbgrfcfp_convert_fileloc_pathfile()+64] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF5F50] [PC:0x10777F280] [Address not mapped to object] []
Incident details in: /data/oracle/diag/rdbms/testrac/testrac1/incident/incdir_2465/testrac1_psp0_20972_i2465.trc
Fri Dec 17 12:46:11 2010
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF5920] [PC:0x10777FE20, sdbgrfcvp_convert_pathinfo()+480] [flags: 0x0, count: 1]
Fri Dec 17 12:46:13 2010
Errors in file /data/oracle/diag/rdbms/testrac/testrac1/trace/testrac1_lmhb_21011.trc (incident=2513):
ORA-07445: ??????: ???? [sdbgrfcvp_convert_pathinfo()+480] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF5920] [PC:0x10777FE20] [Address not mapped to object] []
Incident details in: /data/oracle/diag/rdbms/testrac/testrac1/incident/incdir_2513/testrac1_lmhb_21011_i2513.trc
Fri Dec 17 12:46:35 2010
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFF7FFF5E50] [PC:0xFFFFFFFF7ADDA554, _write()] [flags: 0x0, count: 1]
Errors in file /data/oracle/diag/rdbms/testrac/testrac1/trace/testrac1_mmon_21043.trc (incident=2569):
ORA-07445: ??????: ???? [_write()] [SIGSEGV] [ADDR:0xFFFFFFFF7FFF5E50] [PC:0xFFFFFFFF7ADDA554] [Address not mapped to object] []
Incident details in: /data/oracle/diag/rdbms/testrac/testrac1/incident/incdir_2569/testrac1_mmon_21043_i2569.trc
Fri Dec 17 12:48:32 2010
Trace dumping is performing id=[cdmp_20101217124832]
Fri Dec 17 12:49:04 2010
PMON (ospid: 20946): terminating the instance due to error 481
Instance terminated by PMON, pid = 20946

Oracle出现了大量的ORA-7445错误，其实不用查询metalink，也不用进一步分析详细错误日志文件，仅从错误的函数上就可以推断，问题仍然是内存不足造成的。

在安装过程中，曾经在操作系统上运行vmstat和ps –ef时，都出现过无法分配内容的错误。其实2G的分配并不多，但是由于这台Sun480一共只有4G内存，还要支持Solaris 10系统，ClusterWare、ASM以及Xmanager和dbca的运行，因此空闲的内存只有1.6G左右，从而导致了安装失败。