博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
ORA-32004: obsolete and/or deprecated parameter(s)
阅读量:6572 次
发布时间:2019-06-24

本文共 1919 字,大约阅读时间需要 6 分钟。

[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

转载于:https://blog.51cto.com/860143/2399439

你可能感兴趣的文章
爆款 | Medium上6900个赞的AI学习路线图,让你快速上手机器学习
查看>>
Java基础知识梳理(五)从源码了解字符串
查看>>
从JDK源码角度看Short
查看>>
HTTP/2特性及其在实际应用中的表现
查看>>
解密Angular WebWorker Renderer (二)
查看>>
parceljs 中文文档24小时诞生记
查看>>
五年 Web 开发者 star 的 github 整理说明
查看>>
Docker 部署 SpringBoot 项目整合 Redis 镜像做访问计数Demo
查看>>
Android一种常见的布局困扰
查看>>
ReactNative字体大小不随系统字体大小变化而变化
查看>>
看剧流畅还省电?视频类应用预缓存策略功耗评测详解
查看>>
从零搭建自己的SpringBoot后台框架(六)
查看>>
微信App支付全解析
查看>>
[单刷APUE系列]第四章——文件和目录[1]
查看>>
程序员思维看爱情是什么?
查看>>
RN与原生交互(一)——基本页面跳转
查看>>
android消息机制—Looper
查看>>
中台之上(五):业务架构和中台的难点,都是需要反复锤炼出标准模型
查看>>
为什么中台是传统企业数字化转型的关键?
查看>>
使用模板将Web服务的结果转换为标记语言
查看>>