Solution to ORA-00845 error of Oracle11gR2 in CentOS

PS: Some time ago, a demo environment of Oracle 11g for Linux do not know why, cannot start up, report the ORA-00845 error. After searching, the problem is that the size of the SGA exceeds the size of the Operating System/dev/shm. At that time, I had no time to write a summary. Today I am a little blank. Here is a summary:

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

[root@oracle11g ~]# df -k /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
tmpfs 3072000 1374176 1697824 45% /dev/shm

Oracle describes this in metalink documentation: Doc ID: Note: 460506.1. There are only two ways to solve this problem. One is to modify the initialization parameter so that the SGA setting in the initialization parameter is smaller than/dev/shm, another method is to adjust the size of/dev/shm.

My solution:

1. You can modify the/dev/shm size by modifying the/etc/fstab file. (The size value must be adjusted based on the memory size. I have adjusted it several times before it is successful .) :

[root@oracle11g ~]# vim /etc/fstab

/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults,size=3000m 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0


2. Modify/etc/fstab and mount/dev/shm again to start the database and solve the problem.

[root@oracle11g ~]# umount /dev/shm
[root@oracle11g ~]# mount /dev/shm



[root@oracle ~]# su - oracle
[oracle@oracle ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 30 17:09:42 2012

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1102344192 bytes
Fixed Size 2212576 bytes
Variable Size 838864160 bytes
Database Buffers 251658240 bytes
Redo Buffers 9609216 bytes
Database mounted.
Database opened.


Permanent Link: http://www.ha97.com/5175.html