RAC ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

重启rac时发现32004,后来才发现dg已经不存在了standby_archive_dest还在生效中,而background_dump_dest和user_dump_dest并没在pfile中出现,最后注释了standby_archive_destok了
纠结了一段时间,遇到问题多尝试一下是必要的
奇怪的是alter日志中并没提示因为这个参数影响的,也没说另外2个参数

connected to:
oracle database 11g enterprise edition release 11.2.0.4.0 – 64bit production
with the partitioning, real application clusters, automatic storage management, olap,
data mining and real application testing options
primary-sys@testdb1>startup
ora-32004: obsolete or deprecated parameter(s) specified for rdbms instance
oracle instance started.

total system global area 7.4826e+10 bytes
fixed size 2261048 bytes
variable size 4.9392e+10 bytes
database buffers 2.5233e+10 bytes
redo buffers 199049216 bytes
database mounted.
database opened.

primary-sys@testdb2> ho oerr ora 32004
32004, 00000, “obsolete or deprecated parameter(s) specified for %s instance”
// *cause: obsolete or deprecated parameters for this instance type
// 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.

primary-sys@testdb1>show parameter background_dump_dest

name type value
———————————— ——————————— ——————————
background_dump_dest string /u01/app/oracle/diag/rdbms/din
pay/testdb1/trace
primary-sys@testdb1>show parameter user_dump_dest

name type value
———————————— ——————————— ——————————
user_dump_dest string /u01/app/oracle/diag/rdbms/din
pay/testdb1/trace

primary-sys@testdb1>show parameter standby_archive_dest

name type value
———————————— ——————————— ——————————
standby_archive_dest string +fra

(0)
上一篇 2022年3月22日
下一篇 2022年3月22日

相关推荐