ORA-32004: obsolete and/or deprecated parameter(s)

原创

xingzhehxiang 2019-05-24 10:47:26 ©著作权

文章标签 ora-32004 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者xingzhehxiang的原创作品，请联系作者获取转载授权，否则将追究法律责任

[oracle@169_test bdump]$ >alert_TSH1.log
[oracle@169_test bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 24 10:40:13 2019

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> host [oracle@169_test bdump]$ > alert_TSH1.log [oracle@169_test bdump]$ exit exit

SQL> startup ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started.

Total System Global Area 1224736768 bytes Fixed Size 2020384 bytes Variable Size 369101792 bytes Database Buffers 838860800 bytes Redo Buffers 14753792 bytes Database mounted. Database opened. SQL> host [oracle@169_test bdump]$ grep -B 3 "deprecated" alert_TSH1.log
pga_aggregate_target = 402653184 Deprecated system parameters with specified values: log_archive_start
End of deprecated system parameter listing [oracle@169_test bdump]$ grep -B 2 "deprecated" alert_TSH1.log
Deprecated system parameters with specified values: log_archive_start
End of deprecated system parameter listing [oracle@169_test bdump]$ exit exit

SQL> alter system reset log_archive_start scope=spfile sid='*' ;

System altered.

SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> host [oracle@169_test bdump]$ > alert_TSH1.log [oracle@169_test bdump]$ pwd /u01/app/oracle/admin/orcl10g/bdump [oracle@169_test bdump]$ exit exit

SQL> startup ORACLE instance started.