alert_TSH1.log [oracle@169_test bdump]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production..."/>
溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

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

發(fā)布時間:2020-06-30 22:05:20 來源:網(wǎng)絡 閱讀:294 作者:xingzhehxiang 欄目:關系型數(shù)據(jù)庫

[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

Copyright (c) 1982, 2005, Oracle. All rights reserved.

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.

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 2 "deprecated" alert_TSH1.log

向AI問一下細節(jié)

免責聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權內(nèi)容。

AI