@sga_target greater than sga_max_size
Oracle 18c Windows 误设置sga_max_size后处理
1、SQL>ALTER SYSTEM SET sga_max_size = 500M SCOPE=SPFILE; – 小了
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORA-00823: Specified value of sga_target greater than sga_max_size
2、修改或生成 安装目录WINDOWS.X64_180000_db_home\dbs\init.ora文件
生成的命令
startup pfile=D:\soft\WINDOWS.X64_180000_db_home\dbs\init1.ora
3、电脑上打开修改sga_target sga_max_size 两个参数大小都为1024m,然后启动试下,没毛病,关了库
startup pfile=D:\soft\WINDOWS.X64_180000_db_home\dbs\init1.ora
4、到安装目录 WINDOWS.X64_180000_db_home\database 备份SPFILEORCL.ORA后删了他,生成一个新的SPFILEORCL.ORA命令如下:
CREATE SPFILE=‘D:\soft\WINDOWS.X64_180000_db_home\database\SPFILEORCL.ORA’ FROM PFILE=‘D:\soft\WINDOWS.X64_180000_db_home\dbs\init1.ora’;
5、启动 startup