linux中出现ora27102,解决 ORA-27102: out of memory问题

解决 ORA-27102: out of memory问题

当修改数据参数出现ORA-27102: out of memory错误，大概都是系统参数设置的问题，限制了oracle的sga大小

修改系统参数前，一定要

备份参数文件，

create spfile from pfile='/opt/oracle/product/11.1/db_1/dbs/initorcl.ora';

------- 查看sga的大小

SQL> show parameter sga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

lock_sga                             boolean     FALSE

pre_page_sga                         boolean     FALSE

sga_max_size                         big integer 1552M

sga_target                           big integer 1536M

修改sga_max_size

alter system set sga_max_size=10240M scope=spfile;

重新启动数据库

SQL> startup force

ORA-27102: out of memory

Linux-x86_64 Error: 28: No space left on dev