1.模拟环境http://www.cndba.cn/hbhe0316/article/4845http://www.cndba.cn/hbhe0316/article/4845http://www.cndba.cn/hbhe0316/article/4845http://www.cndba.cn/hbhe0316/article/4845http://www.cndba.cn/hbhe0316/article/4845

alter system set sga_target=10000000M scope=spfile;
shutdown immediate
startup

2.解决方法：http://www.cndba.cn/hbhe0316/article/4845

sqlplus / as sysdba
SQL> shutdown immediate
SQL> create spfile from pfile='/tmp/initorcl.ora';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 2516582400 bytes
Fixed Size                  8623832 bytes
Variable Size            1459620136 bytes
Database Buffers         1040187392 bytes
Redo Buffers                8151040 bytes
Database mounted.
Database opened.

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle