实例启动时报ORA-00845的解决方法

雨点打透心脏的1/2处 2022-03-27 11:44 234阅读 0赞

idle> startup

ORA-00845: MEMORY\_TARGET not supported on this system

因为我一个库里有两个实例，启动时 /dev/shm就不够用了。

在Oracle 11g中如果采用AMM内存管理，那么当MEMORY\_TARGET的值大于/dev/shm的时候，就会报ORA-00845: MEMORY\_TARGET not supported on this system错误，解决办法增加/dev/shm大小，在redhat系列系统中，/dev/shm的默认值是系统总内存的一半

1、修改/dev/shm大小

\[oracle@rtest ~\]$ df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda3 140G 57G 76G 43% /

/dev/sda1 99M 12M 82M 13% /boot

tmpfs 3.9G 995M 3.0G 25% /dev/shm

\[oracle@rtest ~\]$ mount -o size=8G -o nr\_inodes=1000000 -o noatime,nodiratime -o remount /dev/shm

mount: only root can do that

\[oracle@rtest ~\]$ su -

Password:

\[root@rtest ~\]\# mount -o size=8G -o nr\_inodes=1000000 -o noatime,nodiratime -o remount /dev/shm

\[root@rtest ~\]\# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda3 140G 57G 76G 43% /

/dev/sda1 99M 12M 82M 13% /boot

tmpfs 8.0G 995M 7.1G 13% /dev/shm

2、 vi /etc/fstab

LABEL=/ / ext3 defaults 1 1

LABEL=/boot /boot ext3 defaults 1 2

tmpfs /dev/shm tmpfs defaults ,size=8G 0 0

devpts /dev/pts devpts gid=5,mode=620 0 0

sysfs /sys sysfs defaults 0 0

proc /proc proc defaults 0 0

LABEL=SWAP-sda2 swap swap defaults 0 0

3、启动数据库验证：

\[oracle@rtest ~\]$ export ORACLE\_SID=test0924

\[oracle@rtest ~\]$ sqlplus / as sysdba

SQL\*Plus: Release 11.2.0.3.0 Production on Mon Oct 28 14:41:13 2013

Connected to an idle instance.

idle> idle>

idle> conn /as sysdba

Connected to an idle instance.

idle> startup

ORACLE instance started.

Total System Global Area 3340451840 bytes

Fixed Size 2232960 bytes

Variable Size 3204451712 bytes

Database Buffers 117440512 bytes

Redo Buffers 16326656 bytes

Database mounted.

Database opened.

idle> conn /as sysdba

Connected.

sys@TEST0924> show parameter mem

NAME TYPE VALUE

\------------------------------------ ----------- ------------------------------

hi\_shared\_memory\_address integer 0

memory\_max\_target big integer 3200M

memory\_target big integer 0

shared\_memory\_address integer 0

4、官方解析

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.

5、解决问题建议

5.1. If you are installing Oracle 11g on a Linux system, note that Memory Size (SGA and PGA), which sets the initialization parameter MEMORY\_TARGET or MEMORY\_MAX\_TARGET, cannot be greater than the shared memory filesystem (/dev/shm) on your operating system. To resolve the current error, increase the /dev/shm file size.

5.2. If configuring AMM is not possible due to lack of space on /dev/shm mount point, you can configure ASMM instead of AMM, i.e. set SGA\_TARGET, SGA\_MAX\_SIZE and PGA\_AGGREGATE\_TARGET instead of MEMORY\_TARGET.

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485