近期,遇到一个ORACLE 10G数据库环境,用户将数据库迁移到新的硬件服务器上后,新服务器配置较高;分配了200G内存,数据库在运行一段时间后异常;

经分析为数据库使用大内存的问题,在10G版本当内存大于168G后,会出现问题。

SQL> startup
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 22: Invalid argument
Additional information: 1
Additional information: 425986

MOS文档Oracle Database 10g R2 Version 10.2.0.3 - Receiving Ora-27123 Errors. (Doc ID 1268668.1)中对此有描述:
RDBMS 10.2 can startup with a maximum size of 168GB SGA, due to the way the SGA is allocated
Development explained that, although possible to start database with some larger SGA, after 168GB shared libraries get overlayed in memory.  This may cause unpredictable results.

最终,通过将数据库的SGA大小修改为160GB,然后成功启动数据库;

10g数据库使用大内存主机时不能启动的问题_sql