Oracle报SGA_MAX_SIZE cannot be set to more than MEMORY_TARGET
Oracle报SGA_MAX_SIZE cannot be set to more than MEMORY_TARGET
登录数据库的时候提示数据库监听不存在
登录到oracle账号登上数据库服务器查看数据库监听是否启动
lsnrctl status 查看数据库监听,结果如下,数据库服务并未启动。
SQL>startupSqlplus / as sysdba sqlplus界面以dba登录
启动数据库,报错信息为
SGA_MAX_SIZE 536870912 cannot be set to more than MEMORY_TARGET 411041792
问题分析:Oracle 11g中,MAX(SGA+PGA)<= memory_target,在SGA大于memory_target的情况下,使用startup nomount会出现异常
处理步骤:这时候需要执行以下步骤:
SQL> create pfile='/home/oracle/init0321.ora' from spfile;
File created.
SQL> !vi /home/oracle/init0321.ora
然后修改:
*.memory_target=1073741824
*.sga_max_size=805306368
*.sga_target=805306368
SQL> startup pfile='/home/oracle/init0321.ora';
SQL> create spfile from pfile='/home/oracle/init0321.ora';
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
数据库启动正常,可以正常使用工具登录数据库。