ORA-27136: MPMT and VLM are both enabled ORACLE 报错 故障修复 远程处理
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 选项, 然后重新启动数据库即可。
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 ORA-27136: MPMT and VLM are both enabled ORACLE 报错 故障修复 远程处理
相关文章
- ORA-01486: size of array element is too large ORACLE 报错 故障修复 远程处理
- ORA-23424: materialized view “string”.”string” at string not registered ORACLE 报错 故障修复 远程处理
- ORA-23610: internal dbms_streams_tablespaces error: [string] [string] [string] [string] ORACLE 报错 故障修复 远程处理
- ORA-25452: duplicate attribute value for variable: string, attribute: string ORACLE 报错 故障修复 远程处理
- ORA-26895: Setting parameter “string” of Streams process “string” is only permitted for Oracle GoldenGate or XStream. ORACLE 报错 故障修复 远程处理
- ORA-27235: unable to map file region into memory ORACLE 报错 故障修复 远程处理
- ORA-27602: Failure to publish network status information, cell library error code [string] ORACLE 报错 故障修复 远程处理
- ORA-29911: null scan context returned by ODCIIndexStart() routine ORACLE 报错 故障修复 远程处理
- ORA-30771: Cannot add more than one referential constraint on REF column “string” ORACLE 报错 故障修复 远程处理
- ORA-41646: missing “string” attribute for “string” element in the rule condition ORACLE 报错 故障修复 远程处理
- ORA-44826: Number of Performance Classes is more than what was specified. ORACLE 报错 故障修复 远程处理
- ORA-49415: Package sequence earlier than expected [string] [string] ORACLE 报错 故障修复 远程处理
- ORA-54517: outer ring is on the same plane and overlaps another outer ring ORACLE 报错 故障修复 远程处理
- ORA-55350: RDF-OLS table option string not supported ORACLE 报错 故障修复 远程处理
- ORA-02785: Invalid shared memory buffer size ORACLE 报错 故障修复 远程处理
- ORA-09740: slsget: cannot get virtual memory region statistics. ORACLE 报错 故障修复 远程处理
- ORA-10481: Backup data block for data file has an unlogged change ORACLE 报错 故障修复 远程处理
- ORA-12150: TNS:unable to send data ORACLE 报错 故障修复 远程处理
- ORA-15270: disk string is not a quorum disk ORACLE 报错 故障修复 远程处理
- Oracle服务器报价:激发商务潜力(oracle服务器报价)
- 精通 Oracle 触发器:深入了解不同类型(oracle触发器类型)
- Oracle 上月第一天:开启新的旅程(oracle上月第一天)
- Oracle数据库中自带的用户(oracle中自带的用户)
- 开启Oracle事件调度器,实现智能自动化任务(oracle事件调度器)
- 从Oracle优化到性能优化(oracle优化方向)
- Oracle中所有CHR函数的实战使用(oracle中所有chr)
- Oracle中动态取值的实现(oracle中动态值)
- 查看Oracle数据库的监听状态(oracle下检查监听)
- 专业研究Oracle GIS平台分析能力(oracle gis平台)