ORA-00824: cannot set sga_target due to existing internal settings

本文记录了一次因同时设置SGA_TARGET及使用过时参数db_block_buffers而导致ORA-00824错误的经历,并提供了详细的解决步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

前线数据库,说是有问题,让我看看。

我上去看了下,觉得SGA给的太小气了,于是调整sga_target到sga_max_size的值。

突然莫名其妙的数据库停止了。很是神奇。

看了下alter,没发现异常居然,于是startup,坏了,报错: ORA-00824: cannot set sga_target due to existing internal settings


怀疑可能是我修改的参数值最后各个组件的和大于sga_target了,于是一一修改,但是还是不行。

google了下,

原来是oracle的问题。

 当时重现的话,默认安装后,一直有人使用oem的bs版本管理,然后我create pfile form spfile之后,数据库当掉。

检查pfile,其中有一段:

db_block_buffers=13332

 

哦,想起来了,一个oracle的问题。

找了下,果然。


Applies to:
Oracle Server - Enterprise Edition - Version: 10.2 to 10.2
This problem can occur on any platform.


Symptoms
Startup of 10g Database Instance fails with ORA-00824 Error

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-00824: cannot set sga_target due to existing internal settings

Cause
If you enable automatic SGA Management by setting SGA_TARGET >0 and also have db_block_buffers(Obsolete parameter) in your parameter file (pfile/spfile)

Startup of Database fails with ORA-00824 Error

Solution
A) Either you need to disable the Automatic SGA Mangement by setting SGA_Target=0


==OR==

B) Replace the db_block_buffers parameter with db_cache_size parameter

STEPS TO RESOLVE

1. Make an OS copy of the spfile if you do not have a pfile for this database
2. Edit the copy of the spfile to remove the binary stuff before the first parameter
3. Remove the binary stuff after the last parameter.
4. Edit parameters needed to be changed.
5. Save the file and note name and location.
6. Start sqlplus and connect / as sysdba
7. Issue startup pfile = '<full path and file name of file just updated>'
8. Create spfile from pfile.


Errors
ORA-824cannot set sga_target due to existing internal settings

 

 于是删除这个参数,startup。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值