SMON (ospid: 18859): terminating the instance due to error 21779

SMON (ospid: 18859): terminating the instance due to error 21779
oracle 11.2.0.3 shutdown immediate Completed: ALTER DATABASE DISMOUNTARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledARCH: Archival disabled due to shutdown: 1089Thu Dec 10 22:34:11 2020Errors in file /oracle/app/oracle/diag/rdbms/zwa/zwa1/trace/zwa1_smon_18859.trc:ORA-21779: duration not activeShutting down archive proces...

[kjctr_proc_hiprimsg: bad flag]

[kjctr_proc_hiprimsg: bad flag]
19 Patch for 30614411 for Linux-x86-64 Platforms 安装出错, 按照补丁readme描述 This patch is RAC Rolling Installable 但是在实际操作中,当1节点补丁安装完成后,数据库实例无法启动,alert日志提示LMS进程出错,trace日志显示,LMS进程无法与其他节点通信,怀疑LMS程序版本不匹配造成无法通信。 全部节点补丁安装完成后,数据库正常启动。 alert日志信息: Errors i...

p30614411_190000补丁安装

p30614411_190000补丁安装
Bugs Fixed by This Patch The following are the bugs fixed by this patch:30614411: LMS IGNORING MESSAGE HANDLER FOR SCN MESSAGE, ORIGINATING INSTANCE WAITING VERY LONG FOR BROADCAST COMPLETION 检查补丁 -bash-4.2$ $ORACLE_HOME/OPatch/opatch lspatches29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)29517242;Database Release Update : 19.3.0.0.190416 (29517242) O...

oracle 19c 打p30151705补丁过程

oracle 19c 打p30151705补丁过程
环境说明:win10 x64 oracle databae:19.0.0.0.0 补丁程序:p30151705_190000_MSWIN-x86-64, 19.5.0.0.191015 OPatch:p6880880_190000_MSWIN-x86-64 安装步骤: 停止Oracle数据库进程,包括监听 程序和oracle服务 设置正确的环境变量  set PATH=%ORACLE_HOME%\perl\bin;%PATH%  set PERL5LIB= <Press Enter> 更新OPatch 查看现有版本 Window...

遇到oracle bug [kcblasm_1], [103]

遇到oracle bug  [kcblasm_1], [103]
进行到同步余额数据 ACFZJE-> ACFZJE2016 oracle报错ora600 E年结失败!原因:ORA-00600: 内部错误代码, 参数: [kcblasm_1], [103], [], [], [], [], [], [] 查询后发现为oracle bug ,尝试禁用ACFZJE索引,无奈运行到这步时,同步数据是在太慢,决定暂停操作,给数据打补丁。 下载补丁p12419392_10205_AIX64-5L,安装补丁说明进行安装后问题解决。 年结结束的时候发生了一个奇怪的事情,linstener 服...

oracle database 11g Snapshot Standby Easier than manual steps in 10.2

oracle database 11g Snapshot Standby Easier than manual steps in 10.2
Snapshot Standby Easier than manual steps in 10.2 inewup-standby-database 10.2 Standby > alter database recover managed standby database cancel; > create restore point before_lt guarantee flashback database; Primary > alter system archive log current; > alter system set log_archive_dest_state_2=defer; Standby > alter database activate standby database; > s...
Copyright © 2011-2021 往事Theme By  Ality  京ICP备16007547号   关于本站

用户登录