ORA-27102 Out of Memory問題處理

一般是SGA大小設定有關

[oracle@localhost trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 15 10:51:31 2011

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

Connected to an idle instance.

SQL> startup nomount
ORA-00845: MEMORY_TARGET not supported on this system

手動建立一個init引數檔案

調整SGA引數大小

[oracle@localhost dbs]$ vi initrp.ora

spfile='/oracle/product/11.1.0/db_1/dbs/spfilelzccb.ora'
sga_max_size=2500000000
sga_target=2500000000

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 15 11:42:01 2011

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

Connected to an idle instance.

SQL> startup nomount pfile=/oracle/product/11.1.0/db_1/dbs/initrp.ora
ORACLE instance started.

[@more@]