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

发布时间:2020-06-30 22:05:20 作者:xingzhehxiang
来源:网络 阅读:294

[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

推荐阅读:
  1. Oracle启动时出现ORA-32004报错如何解决
  2. PHP数组占用内存大小是多少

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

ora-32004 ora- 2004

上一篇:Ping32非法外联使用教程

下一篇:tcmalloc导致程序无法启动

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》