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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22036495/viewspace-1048716/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22036495/viewspace-1048716/