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

1.启动数据库时报错:ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

                                   ORA-00119: invalid specification for system parameter LOCAL_LISTENER
                                   ORA-00132: syntax error or unresolved network name 'lsnr2'

2.回想一下,因为关库之前更改了user_dump_dest参数,经过查阅资料,Oracle11g  background_dump_dest和user_dump_dest两个参数已经弃用,由新参数diagnostic_dest所取代,我在数据库中去修改了user_dump_dest参数,所以会报错ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance,lsnr2是动态监听,

3.利用spfile创建pfile,用pfile启动,还是报错

                                     startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initPROD1.ora';
                                    ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated
                                    ORA-00119: invalid specification for system parameter LOCAL_LISTENER
                                    ORA-00132: syntax error or unresolved network name 'lsnr2'

4.根据报错,vi编辑pfile,把报错相关参数暂时注释掉,然后用pfile正常启动数据库。

原文地址:https://www.cnblogs.com/gw666/p/11878706.html