手工建庫啟動例項時一個小錯誤:ORA-00824: cannot set sga_target due to existing internal settings

還不算暈發表於2013-11-24

資料庫版本:10G 10.2.0.1   錯誤:ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information

引數檔案如下:

[oracle@ocm1 dbs]$ ls
initdw.ora  initocm1.ora  init.ora  orapwocm1
[oracle@ocm1 dbs]$ cat initocm1.ora
db_name=ocm1
db_files = 80                                                         # SMALL  
db_file_multiblock_read_count = 8                                     # SMALL  
db_block_buffers = 100                                                 # SMALL  
shared_pool_size = 3500000                                            # SMALL
log_checkpoint_interval = 10000
processes = 250                                                        # SMALL  
sessions = 300
parallel_max_servers = 5                                              # SMALL
log_buffer = 32768                                                    # SMALL
max_dump_file_size = 10240      # limit trace file size to 5 Meg each
global_names = TRUE
control_files = ('/u01/oradata/bys3/control01.ctl', '/u01/oradata/bys3/control02.ctl','/u01/oradata/bys3/control03.ctl')
sga_max_size = 400m
sga_target = 300m
undo_management = auto
啟動例項報錯如下:
oracle@ocm1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 24 14:13:41 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information
SQL> exit
報錯原因 :
Cause     SGA_TARGET >0又設定了db_block_buffers引數。db_block_buffers已經是廢棄的了。
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
解決方法:
A)設定SGA_Target=0,關閉Automatic SGA Mangement自動記憶體管理
B) 刪除 db_block_buffers parameter
C) 使用db_cache_size parameter替換db_block_buffers
我這裡刪除了db_cache_size引數:
[oracle@ocm1 dbs]$ cat initocm1.ora
db_name=ocm1
db_files = 80                                                         # SMALL  
db_file_multiblock_read_count = 8                                     # SMALL  
log_checkpoint_interval = 10000
processes = 250                                                        # SMALL  
sessions = 300
parallel_max_servers = 5                                              # SMALL
log_buffer = 32768                                                    # SMALL
max_dump_file_size = 10240      # limit trace file size to 5 Meg each
global_names = TRUE
control_files = ('/u01/oradata/bys3/control01.ctl', '/u01/oradata/bys3/control02.ctl','/u01/oradata/bys3/control03.ctl')
sga_max_size = 400m
sga_target = 300m
undo_management = auto
[oracle@ocm1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 24 14:14:59 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
重啟例項成功:
SQL> startup nomount;
ORACLE instance started.
Total System Global Area  419430400 bytes
Fixed Size                  1219784 bytes
Variable Size             201327416 bytes
Database Buffers          213909504 bytes
Redo Buffers                2973696 bytes

相關文章