Shulou(Shulou.com)06/01 Report--

[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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.