手工建库启动实例时一个小错误:ORA-00824: cannot set sga_target due to existing internal settings
来源:互联网 发布:定制交易源码 编辑:程序博客网 时间:2024/04/28 13:21
数据库版本: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]$ lsinitdw.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
- 手工建库启动实例时一个小错误:ORA-00824: cannot set sga_target due to existing internal settings
- ORA-00824: cannot set sga_target due to existing internal settings
- ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log f
- can not startup. ORA-00824: cannot set sga_target due to existing internal settings
- ORA-00849: SGA_TARGET 8589934592 cannot be set to more than MEMORY_MAX_TARGET 0.
- Cannot start the session due to some internal error
- ORA-31514: change set disabled due to capture error
- 手工建库时启动到nomount状态时错误ORA-09925,ORA-01017
- 类的继承引起的一个错误:error C2259 cannot instantiate abstract class due to following members
- 类的继承引起的一个错误:error C2259 cannot instantiate abstract class due to following members
- pache 显示这样的错误时 "Request exceeded the limit of 10 internal redirects due to probable configuration er
- 连接WCF出现错误:The server was unable to process the request due to an internal
- Form 6i cannot connect to 10gR2 or 10gXe due to character set issue
- oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
- Spring Boot jar 启动错误“due to missing embeddedServletContainerFactory.bean”
- 手工建库ORA-01501 ORA-01504
- Tomcat启动时错误:Cannot rename original file to
- Tomcat启动时错误:Cannot rename original file to
- AS3中与声音控制
- bulk-load 装载HDFS数据到HBase
- 数码管动态扫描显示01234567
- HBase开启LZO
- Cento基本命令应用
- 手工建库启动实例时一个小错误:ORA-00824: cannot set sga_target due to existing internal settings
- HBase replication使用
- UVa:10334 Ray Through Glasses
- SoundMixer.computeSpectrum() 方法
- salt
- Hibernate学习小记
- 信息管理专业的分析(更新中)
- 有前后缀的排列算法
- 提高HBase写性能