ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together

最新推荐文章于 2021-04-05 22:53:33 发布

lurou

最新推荐文章于 2021-04-05 22:53:33 发布

阅读量2.6k

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/laven54/article/details/11862361

版权

Oracle 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

dg-primary:~ # free -m
total used free shared buffers cached
Mem: 3834 3620 214 0 26 3157
-/+ buffers/cache: 435 3398
Swap: 4095 1341 2754

SQL> show parameter lock_sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE

dg-primary:~ # sysctl -q vm.swappiness
vm.swappiness = 60

dg-primary:~ # su - oracle
dg-primary:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 21 10:25:08 2013

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set lock_sga=true scope=spfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
SQL>

dg-primary:~ # free -m
total used free shared buffers cached
Mem: 3834 3620 214 0 26 3157
-/+ buffers/cache: 435 3398
Swap: 4095 1341 2754

dg-primary:/oracle/product/11gR2/db/dbs> vi initebai.ora
dg-primary:/oracle/product/11gR2/db/dbs> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 21 20:45:40 2013

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

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> exit
Disconnected
dg-primary:/oracle/product/11gR2/db/dbs> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 21 20:46:05 2013

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 5845798912 bytes
Fixed Size 2238976 bytes
Variable Size 2868905472 bytes
Database Buffers 2969567232 bytes
Redo Buffers 5087232 bytes
Database mounted.
Database opened.
SQL> select count(*) from v$session;

COUNT(*)
----------
30

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
dg-primary:/oracle/product/11gR2/db/dbs> exit
logout
dg-primary:~ # free -m
total used free shared buffers cached
Mem: 3834 3705 128 0 1 3398
-/+ buffers/cache: 306 3528
Swap: 4095 771 3324
dg-primary:~ # cat /proc/meminfo |grep swap
dg-primary:~ # sysctl -q vm.swappiness
vm.swappiness = 60
dg-primary:~ # vi /etc/sysctl.conf
dg-primary:~ # /sbin/sysctl -p
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
fs.inotify.max_user_watches = 65536
net.ipv4.conf.default.promote_secondaries = 1
net.ipv4.conf.all.promote_secondaries = 1
kernel.shmmax = 4128348160
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
vm.swappiness = 0
dg-primary:~ # sysctl -q vm.swappiness
vm.swappiness = 0
dg-primary:~ # free -m
total used free shared buffers cached
Mem: 3834 3697 136 0 2 3402
-/+ buffers/cache: 293 3540
Swap: 4095 771 3324
dg-primary:~ #
dg-primary:~ # su - oracle
dg-primary:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 21 20:51:11 2013

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>