文档解释
ORA-27136: MPMT and VLM are both enabled
Cause: When the _mpmt_enabled parameter is set to TRUE, none of the following parameters should be set to TRUE:
* use_indirect_buffers
* _db_block_cache_protect
* _db_block_cache_clone
Action: Either turn off Multi Process Multi Threads (MPMT) or turn off all the other parameters.
ORA-27136: MPMT (Multi-Process Multi-Thread) 和 VLM(Virtual Large Memory) 同时启动时发生的错误。
官方解释
案例:当在Linux平台安装了 oracle 数据库,并在数据库实例启动时,报ORA-27136 错误。
一般处理方法及步骤
1. 首先,请确定你需要配置MPMT(Multi-Process Multi-Thread),还是VLM(Virtual Large Memory)。
2. 如果只需要使用MPMT,勾选上Use Multi-Process Multi-Threaded libraries in sqlnet.ora中即可;
3. 如果只需要使用VLM,则需要在sqlnet.ora文件中打开下面的选项:VLM_ENABLED = TRUE;
4. 但是,如果同时安装了MPMT(Multi-Process Multi-Thread)和VLM(Virtual Large Memory),就会报出ORA-27136的错误;
5. 因此,要想避免报出ORA-27136的错误,请从sqlnet.ora文件中, 注释掉 VLM_ENABLED = TRUE 选项, 然后重新启动数据库即可。