DB_MOS - 文章分类 - erwadba

SELECT sequence.NEXTVAL FROM dual;会引发bug？

摘要：在生产环境中，SELECT sequence.NEXTVAL FROM dual;报ora-600错误。在mos上面查居然是个bugORA-00600 [6816] on SELECT sequence.NEXTVAL FROM dual in RAC (文档 ID 2428000.1) In th 阅读全文

posted @ 2018-09-28 17:25 erwadba 阅读(976) 评论(0) 推荐(0)

我好像是遇到IF: ORA-1628 Reported During Long Running Transactions (文档 ID 1951032.1) 这个bug了？

摘要：IF: ORA-1628 Reported During Long Running Transactions (文档 ID 1951032.1) In this Document APPLIES TO: Oracle Database - Enterprise Edition - Version 9 阅读全文

posted @ 2018-07-09 16:50 erwadba 阅读(276) 评论(0) 推荐(0)

Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1)

摘要：In this Document APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]Oracle Database - Enterprise Edit 阅读全文

posted @ 2018-06-12 16:31 erwadba 阅读(349) 评论(0) 推荐(0)

12c lgwr新特性可能会引起log file sync等待事件？

摘要：Multiple Log Writers in 12c Causing Enabling and Disabling of Adaptive Scalable Log Writer Workers Which Cause High 'log file sync' Wait Event (文档 ID 阅读全文

posted @ 2018-06-11 14:36 erwadba 阅读(1143) 评论(0) 推荐(0)

故障排除指南 ORA-3136：WARNING Inbound Connection Timed Out (文档 ID 2331569.1)

摘要：故障排除指南 ORA-3136：WARNING Inbound Connection Timed Out (文档 ID 2331569.1) 文档内容 Oracle Net Services - 版本 10.2.0.5 到 12.2.0.1 [发行版 10.2 到 12.2] 适用于: Oracle 阅读全文

posted @ 2018-06-04 14:49 erwadba 阅读(3581) 评论(0) 推荐(0)

怎样将pdb退回到nocdb？

摘要：How to Move a PDB Back to a Non-CDB Using TRANSPORTABLE=ALWAYS (文档 ID 2027352.1) In this Document Oracle Database - Enterprise Edition - Version 12.1. 阅读全文

posted @ 2018-05-09 15:56 erwadba 阅读(726) 评论(0) 推荐(0)

12.2:DB Alert.log shows ORA-20001: Latest xml inventory,ORA-06512: at "SYS.DBMS_QOPATCH","KUP-04004: error while reading file" (文档 ID 2323937.1)

摘要：alert.log中出现如下告警日志： Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into tableORA-06512: 阅读全文

posted @ 2018-05-03 13:56 erwadba 阅读(1742) 评论(0) 推荐(0)

Datapatch：数据库 12c 补丁后期 SQL 自动化 (文档 ID 2101974.1)

摘要：文档内容适用于: Oracle Database - Enterprise Edition - 版本 12.1.0.1 和更高版本Oracle Database - Personal Edition - 版本 12.1.0.1 和更高版本Oracle Database - Standard Edi 阅读全文

posted @ 2018-04-28 17:12 erwadba 阅读(600) 评论(0) 推荐(0)

单实例asm修改主机名Reconfigure

摘要：How to Reconfigure Oracle Restart (文档 ID 986740.1) In this Document The expected result is "Successfully deconfigured Oracle Restart stack". APPLIES T 阅读全文

posted @ 2018-04-27 14:02 erwadba 阅读(247) 评论(0) 推荐(0)

安装12.2.0.1单实例ASM。dbca报错？

摘要：[ora.cdb.db]{0:0:1343} [start] ORA-01017: invalid username/password; logon denied Database Creation in Oracle Restart Environment Fails With "ORA-0101 阅读全文

posted @ 2018-04-26 09:00 erwadba 阅读(324) 评论(0) 推荐(0)

How to Convert a Long to Varchar2 (文档 ID 228532.1)

摘要：oracle 中怎样转化long类型，到varchar2 How to Convert a Long to Varchar2 (文档 ID 228532.1) 阅读全文

posted @ 2018-04-25 15:58 erwadba 阅读(104) 评论(0) 推荐(0)

查找redo切换频率块的原因？

摘要：How to identify the causes of High Redo Generation (文档 ID 2265722.1) In this Document Oracle Database - Enterprise Edition - Version 9.2.0.1 and later 阅读全文

posted @ 2018-04-22 07:58 erwadba 阅读(183) 评论(0) 推荐(0)

在升级11.2.0.3的过程中，发现system用户下面有无效物化视图？

摘要：删除system中mv$$_Materialized Views 无效对象 How To Remove Invalid MV$$_ Materialized Views in the SYSTEM Schema (文档 ID 1571344.1) In this Document Oracle Da 阅读全文

posted @ 2018-03-26 13:20 erwadba 阅读(209) 评论(0) 推荐(0)

由于sys的统计信息过旧，awr进程mmon不工作？

摘要：awr进程mmon不工作情况1：生产环境的一套系统awr突然不自动产生了。手动执行create能创建。通过开sr确定，是由于系统中sys统计信息过旧，导致不能正常生成awr现象：从ORAODS1_mmon_194475.trc中，有下列信息 +++++++++++++++++++++++++++ 阅读全文

posted @ 2018-03-26 08:46 erwadba 阅读(3807) 评论(0) 推荐(0)

oracle中system用户能lock吗？

摘要：从mos上的文档中显示，oracle中system用户是可以lock的 Can the SYS and SYSTEM users be locked? (文档 ID 2132859.1) 需要注意的是：1.system用户下面没有自动化作业。2、在升级或者打补丁的时候，需要将system用户解锁，不阅读全文

posted @ 2017-12-21 10:30 erwadba 阅读(770) 评论(0) 推荐(0)

文章分类 - DB_MOS