ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 处理ORA-00824: cannot set sga_target due to existing internal settings 的过程

处理ORA-00824: cannot set sga_target due to existing internal settings 的过程

原创 Linux操作系统 作者:howard_zhang 时间:2008-04-10 09:53:10 0 删除 编辑

SUN 6900  20CPU,80G内存

ORACLE 10203,装了三个实例

首先修改PROJECT

由于SA是默认安装MAX-SHM-MEMORY只有19.6G

# projadd -U oracle -G dba -c 'Ora DB' -p 162 user.oracle
# projmod -sK 'project.max-shm-memory=(priv,50g,deny)' user.oracle

然后分别修改3个实例的SGA_MAX_SIZE和SGA_TARGET参数

发现第三个实例修改后重起报如下错误:

SQL> startup
ORA-00824: cannot set sga_target due to existing internal settings, see alert lo
g for more information

搜索METALINK:

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 = ''
8. Create spfile from pfile.

Errors

ORA-824 cannot set sga_target due to existing internal settings

处理办法,找到之前备份过的PFILE把DB_BLOCK_BUFFERS去掉,然后重建SPFILE,在修改以上2个参数,问题解决.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7882490/viewspace-232329/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-22

  • 博文量
    42
  • 访问量
    130369