ORA-00824 cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settin
程序员文章站
2022-07-15 08:58:23
...
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00842: DB_BLOCK_BUFFERS cannot be set with SGA_TARGET or MEMORY_TARGET ORA-01034: ORACLE not available E:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on 星期三 1月 28 16:04:37 2015 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> startup ; ORA-01031: insufficient privileges SQL> startup; ORA-01031: insufficient privileges SQL> conn / as sysdba; 已连接到空闲例程。 SQL> shutdown normal ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 第 1 行出现错误: ORA-01034: ORACLE not available 进程 ID: 0 会话 ID: 0 序列号: 0 SQL> startup pfile='E:\app\Administrator\admin\orcl\pfile\init.ora.216201423850' ; ORACLE 例程已经启动。 Total System Global Area 5094195200 bytes Fixed Size 2184552 bytes Variable Size 2684357272 bytes Database Buffers 2399141888 bytes Redo Buffers 8511488 bytes 数据库装载完毕。 数据库已经打开。 SQL> create spfile from pfile='E:\app\Administrator\admin\orcl\pfile\init.ora.216201423850'; 文件已创建。 SQL> shutdown immediate 数据库已经关闭。 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> startup ORACLE 例程已经启动。 Total System Global Area 5094195200 bytes Fixed Size 2184552 bytes Variable Size 2684357272 bytes Database Buffers 2399141888 bytes Redo Buffers 8511488 bytes 数据库装载完毕。 数据库已经打开。 SQL>
上一篇: 矩阵Gauss消除法解线性方程
下一篇: oracle中如何将表缓存到内存中