-
编辑 删除
windows中OracleServiceOrcl服务消失处理方案
----sql连接报ORA-12560错误，OracleServiceOrcl服务也消失了----报错原因应该是注册表中丢失了oracle实例的配置信息，导致丢失的原因多样，杀毒软件、木马病毒、其他恶意流氓软件等等 处理方法如下：----新增数据库ORCL实例服务的命令：oradim -new -sid ORCL----新增之后，服务列表中就有...
-
编辑 删除
SYS_AUTO_SQL_TUNING_TASK 导致 ORA-07445错误
1.先贴报错----敏感信息已经经过处理 Fri Sep 30 11:01:372016Begin automatic SQLTuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"Fri Sep 30 11:01:502016Exception [type:SIGSEGV, Address not mapped to object] [ADDR:0x7FFF82C72FF8] [PC:0x9541BA4...
-
编辑 删除
ORA-02055 ORA-02068 ORA-03113 ORA-01591
1.报错如下ORA-02055/02068/03113Fri Jul 8 13:02:07 2016Errors in file/oracle/admin/orcl/bdump/orcl_j000_27421.trc:ORA-12012: 自动执行作业 87 出错ORA-02055: 分布式更新操作失效；要求回退ORA-02068: 以下严重错误源于db_orclORA-03113: 通信通道的文件结束ORA-06512: 在"sh...
-
编辑 删除
TNS-12547 TNS-12560 TNS-00517解决办法
一朋友启动监听lsnrctl start 发现报错TNS-12547 TNS-12560 TNS-00517[oracle@zyx ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-APR-2016 06:14:23Copyright (c) 1991, 2013, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2/db_1/bin/tnslsnr: plea...
-
编辑 删除
日志检测发现Checkpoint not complete
1.检查告警日志发现Checkpoint not complete报错如下：Sat May 21 07:36:43 2016Thread 1 cannot allocate new log, sequence6672Checkpoint not complete Current log# 2 seq# 6671 mem# 0:/home/oracle/app/oracle/oradata/qianlong/redo02.logSat May 21 07:36:58 2016Thread 1 ...
-
编辑 删除
检测告警日志发现 Private strand flush not complete
1. 检查告警日志发现Private strand flush not complete报错如下：Mon May 23 12:32:34 2016Thread 1 cannot allocate new log, sequence6726Private strand flush not complete Current log# 1 seq# 6725 mem# 0:/home/oracle/app/oracle/oradata/qianlong/redo01.logThread 1 advanced...
-
编辑 删除
ORACLE 9i alert.log 出现ARC1: Media recovery disabled
测试库检查告警日志，发现出现如下错误：[oracle@zyx ~]$ tail -n 100 /oracle/admin/orcl/bdump/alert_orcl.log Fri May 6 14:06:49 2016ARC0: Media recovery disabledFri May 6 14:06:54 2016ARC1: Media recovery disabledFri May 6 14:07:54 2016AR...
-
编辑 删除
oracle告警日志alert出现 minact-scn 处理
今天检测测试库时，发现alert告警日志报错，如下： FriApr 29 12:11:34 2016 minact-scn:got error during useg scan e:376 usn:10 minact-scn:useg scan erroring out with error e:376 FriApr 29 12:14:34 2016 minact-scn:got error during useg scan e:376 usn:10 minact-sc...
