欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-08-05 20:45:41
重启RAC时发现32004,后来才发现DG已经不存在了standby_archive_dest还在生效中,而background_dump_dest和user_dump_dest并没在pfile中出现,最后注释了standby_archive_destOK了纠结了一段时间,遇到问题多尝试一下是必要的 ......

重启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