1.ORA-04031: unable to allocate 4128 bytes of shared memory
show parameters shared_pool_size;
show parameters large_pool_size;
show parameters java_pool_size;
alter system set shared_pool_size='160M' scope=both;
alter system set java_pool_size='160M' scope=both ;
alter system set large_pool_size='160M' scope=both ;
2.关闭数据库重启时出现:Specified value of MEMORY_TARGET is too small, needs to be at least 1536M
创建pfile
create pfile = '/home/oracle/initora12g.ora' from spfile;
修改pfile中的MEMORY_TARGET为1536M
用pfile启动,成功。
startup pfile='/home/oracle/initora12g.ora';
停止数据库,从pfile创建spfile。
create spfile from pfile = '/home/oracle/initora12g.ora';
使用spfile启动:startup