oracle 11g road(/dev/shm需注意)

在oracle linux上安装oracle 11g的过程中对于os的共享内存(/dev/shm)还是有一定的要求的,其大小不能小于你分配给oracle使用的内存的大小:

Starting with Oracle Database 11g, the Automatic Memory Management feature
requires more shared memory (/dev/shm)and file descriptors. The size of the shared
memory should be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET
for each Oracle instance on the computer
. If MEMORY_MAX_TARGET or MEMORY_
TARGET is set to a non zero value, and an incorrect size is assigned to the shared
memory, it will result in an ORA-00845 error at startup. The number of file descriptors
for each Oracle instance should be at least 512*PROCESSES. Also, the limit of
descriptors for each process should be at least 512. If file descriptors are not sized
correctly, you will notice ORA-27123 from various Oracle processes and potentially
Linux Error EMFILE (Too many open files) errors in non-Oracle processes.

于是我悲剧了,发现我初始安装Oracle Linux的时候给的/dev/shm太小了(其实我都忘记自己在哪里设置了这个参数了..),好吧,只能修改了。

vi /etc/fstab,在其中添加size=4096M,然后mount -o remount /dev/shm就可以了,如下:

tmpfs                   /dev/shm                tmpfs   defaults,size=4096M        0 0


[root@gongwenServer srvadmin]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              95G  5.4G   85G   6% /
/dev/sda4             294G  195M  278G   1% /opt
/dev/sda1             190M   12M  169M   7% /boot
tmpfs                 4.0G     0  4.0G   0% /dev/shm

好了,ok,rush the way to oracle 11g

http://blog.sina.com.cn/s/blog_5fbb16590100hx1z.html

原文地址:https://www.cnblogs.com/seasonzone/p/3103762.html