ORA-00823: Specified value of sga_target greater than sga_max_size
来源:互联网 发布:希斯.莱杰 知乎 编辑:程序博客网 时间:2024/04/28 16:16
1.根据pfile创建spfiel后,修改pfile中的sga_max_size参数
2.用pfile启动数据库,测试正常。
3.根据pfiel创建spfile
4.用spfile启动数据库。
SQL>ALTER SYSTEM SET sga_max_size = 4096 SCOPE=SPFILE; -- 少写了一个M,害得数据库起不来
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
SQL> CREATE PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora' FROM SPFILE;
File created.
SQL> !
[oracle@oradb01 emd]$ vi CREATE PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora' FROM SPFILE;
*.sga_max_size=4096 改为
*.sga_max_size=4096M
SQL> startup PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora'
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2266024 bytes
Variable Size 1681919064 bytes
Database Buffers 2583691264 bytes
Redo Buffers 7905280 bytes
Database mounted.
Database opened.
SQL> !
[oracle@oradb01 emd]$ cd /opt/ora11g/product/11.2.3/db_1/dbs/
[oracle@oradb01 dbs]$ cp spfileorcl.ora spfileorcl.ora_bak01
[oracle@oradb01 dbs]$ exit
exit
SQL> CREATE SPFILE='/opt/ora11g/product/11.2.3/db_1/dbs/spfileorcl.ora' FROM PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora';
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 1677722808 bytes
Database Buffers 2583691264 bytes
Redo Buffers 12132352 bytes
Database mounted.
Database opened.
- ORA-00823: Specified value of sga_target greater than sga_max_size
- ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
- ORA-00821: Specified value of sga_target
- ORA-00838: Specified value of MEMORY_TARGET
- ORA-00838: Specified value of MEMORY_TARGET 解决方案!
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET 区别
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_TARGET与SGA_MAX_SIZE关系
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- List
- Trie的java实现
- HDOJ 1005 - 上周新队员做的题~我也来水水~矩阵乘法的说..
- ASP
- 各种平台下PERL模块的安装方法完全版
- ORA-00823: Specified value of sga_target greater than sga_max_size
- 电脑上安装安卓系统模拟器的方法
- 大并发下listen的连接完成对列backlog太小导致客户超时,服务器效率低下
- Android的传感器编程小结
- 修改内核参数,增强Linux吞吐量
- cocos2d-x 直接读取多张图创建动画
- Hbase表的结构
- 某软件驱动任意地址写任意数据漏洞
- jQuery实现图片点击放大