ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-32004: obsolete and/or deprecated parameter(s) specified
启动自动归档模式,通过设置 log_archive_start 并不会起到自动归档的作用反而启动时会报出ORA- 32004: obsolete and/or deprecated parameter(s) specified,操作如下(测试数据库已是自动归 档模式)该方式适合9i数据库开通数据库归档和自动归档模式。
查看错误代码相关信息:
- SQL> host oerr ora 12154
- 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 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.
- SQL>
告诉我们去 alert log 中查看信息。查找...
Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing
SQL>ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';
查看一下 10g 中都有那些参数是 deprecated 的:
- SQL> SELECT NAME, description
- FROM v$parameter
- WHERE isdeprecated = 'TRUE';
评论暂时关闭