本文共 1919 字,大约阅读时间需要 6 分钟。
[oracle@169_test bdump]$ >alert_TSH1.log
[oracle@169_test bdump]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri May 24 10:40:13 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> shutdown immediate
Database closed.Database dismounted.ORACLE instance shut down.SQL> host[oracle@169_test bdump]$ > alert_TSH1.log [oracle@169_test bdump]$ exitexitSQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytesVariable Size 369101792 bytesDatabase Buffers 838860800 bytesRedo Buffers 14753792 bytesDatabase mounted.Database opened.SQL> host[oracle@169_test bdump]$ grep -B 3 "deprecated" alert_TSH1.log pga_aggregate_target = 402653184Deprecated 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]$ exitexitSQL> 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]$ exitexitSQL> startup
ORACLE instance started.Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytesVariable Size 369101792 bytesDatabase Buffers 838860800 bytesRedo Buffers 14753792 bytesDatabase mounted.Database opened.SQL> host[oracle@169_test bdump]$ grep -B 2 "deprecated" alert_TSH1.log转载于:https://blog.51cto.com/860143/2399439