Chinaunix首页 | 论坛 | 博客
  • 博客访问: 32856
  • 博文数量: 17
  • 博客积分: 696
  • 博客等级: 上士
  • 技术积分: 170
  • 用 户 组: 普通用户
  • 注册时间: 2009-03-14 16:59
文章分类

全部博文(17)

文章存档

2010年(4)

2009年(13)

我的朋友

分类: Oracle

2009-03-16 23:42:28

在配置归档模式的时候,启动数据库出现如下错误
idle> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area          167772160 bytes
Fixed Size                1218316 bytes
Variable Size                   62916852 bytes
Database Buffers              100663296 bytes
Redo Buffers                2973696 bytes

idle> host oerr ora 32004
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause:  One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.

idle> host oerr ora 32004
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause:  One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.

查询alter log发现
Deprecated system parameters with specified values:
  log_archive_start  

经查文档发现oracle10g 已经废弃了这个参数   
但是在参数文件中其值为true

idle> alter system reset log_archive_start SCOPE=SPFILE SID='*';

System altered.

idle> shutdown immediate;

idle> startup
ORACLE instance started.

Total System Global Area          167772160 bytes
Fixed Size                1218316 bytes
Variable Size                   62916852 bytes
Database Buffers              100663296 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.


阅读(521) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~