度量快速开发平台-专业、快速的软件定制快开平台

标题: 实例启动时报ORA-00845的解决方法 [打印本页]

作者: fteair 时间: 2020-2-10 21:33

作者: 张兴康 时间: 2020-2-13 12:49

fteair 发表于 2017-3-10 21:33

作者: 张兴康 时间: 2020-6-22 14:24
标题: 实例启动时报ORA-00845的解决方法
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

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

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

作者: 张兴康 时间: 2020-6-22 14:25

欢迎光临度量快速开发平台-专业、快速的软件定制快开平台 (http://bbs.delit.cn/)