Goal
How to know which parameter is obsolete and/or deprecated when the only message on screen whenattempting to start a database is "ORA-32004: obsolete and/or deprecated parameter(s) specified" ?
Solution
1.
Look at the DBA's alert log of the associated instance as
newer versions of the RDBMS software will identify the parameters that
are obsolete and/or deprecated within the alert log at the time that an
instance startup is initiated.
2.
If the alert log is not
available or does not identify the obsolete or deprecated parameter and
the database is accessible then check to see that none of the parameters
in the parameter initialization file match a parameter name stored in
the V$OBSOLETE_PARAMETER view of that same database.
If there is a match, then it is an obsolete parameter.
3.
If
the alert log is not available or does not identify the obsolete or
deprecated parameter then check to see that none of the parameters in
the parameter initialization file match a parameter name listed within
the migration guide's list of deprecated parameters or it's list of
obsolete parameters.
[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/161195/viewspace-1054517/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 参数LOG_ARCHIVE_MIN_SUCCEED_DEST
- v$bgprocess --解释oracle db 后台进程作用的视图
- goldengate 认证矩阵matrix
- 日志挖掘是看不到谁在尝试密码的
- 各种*nix操作系统下查看网卡带宽 .
- Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evicti
- 64bit client 与 32bit plsqldev是不兼容的
- Data Guard Switchover and Failover Best Practices
- How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]
- Checking for Oracle archive log corruption [ID 1268590.1]
