[20180211]11g关闭AMM.txt

[20180211]11g关闭AMM.txt

--//指点别人的系统关闭AMM,使用hugepages遇到问题,主要问题是对方设置如下参数在spfile文件中:
*.memory_max_target=0
*.memory_target=0

--//通过例子说明:

1.环境:

SCOTT@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SYS@book> create pfile='/tmp/@.ora' from spfile;
File created.

--//修改 /tmp/book.ora 文件增加如下:
*.memory_max_target=0
*.memory_target=0

2.测试:
SYS@book> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@book> startup pfile='/tmp/book.ora'
ORA-27125: unable to create shared memory segment

SYS@book> startup nomount pfile='/tmp/book.ora'
ORA-27125: unable to create shared memory segment

SYS@book> create spfile from pfile='/tmp/book.ora';
File created.

SYS@book> startup
ORA-27125: unable to create shared memory segment

3.问题解决:

--//按照前面的方法建立pfile.
SYS@book> create pfile='/tmp/@.ora' from spfile;
File created.

--//删除*.memory_max_target=0,*.memory_target=0行,重新建立spfile:

SYS@book> create spfile from pfile='/tmp/book.ora';
File created.

SYS@book> startup
ORACLE instance started.
Total System Global Area  634732544 bytes
Fixed Size                  2255792 bytes
Variable Size             197133392 bytes
Database Buffers          427819008 bytes
Redo Buffers                7524352 bytes
Database mounted.
Database opened.
--//OK.

SYS@book> show parameter memory_%target
NAME              TYPE        VALUE
----------------- ----------- ------
memory_max_target big integer 0
memory_target     big integer 0

--//oracle到处都是坑...^_^.即使是0,也不能写在参数文件里面.