-
编辑 删除
ORA-1555 Using Automatic Undo Management - How to troubleshoot
Applies to: Oracle Server - Enterprise EditionInformation in this document applies to any platform.PurposeThis article discusses the means to troubleshoot and diagnose the ORA-01555 "snapshot too...
-
编辑 删除
How To Size UNDO Tablespace For Automatic Undo Management
Applies to: Oracle Server Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7Information in this document applies to any platform.Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.3 Goa...
-
编辑 删除
How To Identify a Hot Block Within The Database Buffer Cache
Applies to: Oracle Server - Enterprise EditionInformation in this document applies to any platform.GoalHow to identify blocks which cause latch contention on the 'cache buffers chains' latch.How t...
-
编辑 删除
oracle 访问sqlserver透明网关配置
1. 检查oracle 透明网关插件是否已经安装. 安装后会存在ORACLE_HOME\tg4msql 这个文件夹. 若没有安装择需要oracle 介质去安装. &n...
-
编辑 删除
ORA-1555错误解决大全
ORA-1555是一个非常著名但让人讨厌的错误，下面就该错误是如何产生的及该如何来预防做个综述。ORA-1555错误简单的说就是针对一个数据块产生一致读时发生了错误。一致读就是指ORACLE利用回滚段来临时重构一个和事务...
-
编辑 删除
重启主库出现ORA-03113和ORA-16072错误
The information in this article applies to:Oracle Database - Enterprise EditionOracle Data Guard and Standby DatabaseSymptom(s)~~~~~~~~~~You have a Data Guard Configuration running either in Maximum A...
-
编辑 删除
ORA-1093 During Switchover or Close of Standby Database (Doc ID 444362.1)
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3This problem can occur on any platform.SymptomsDuring switchover from Primary to Physical Standby the following errors ...
-
编辑 删除
改变RAC参数可能引发的参数不一致的问题
这个问题其实已经在文章《CLUSTER_DATABASE_INSTANCES参数》中提到过，但是当时并没有太在意。以至于在随后两天的测试中，连续两次由于这个问题导致了RAC实例无法启动，因此还是有必要单独描述一下这个问题。CLUSTE...
-
编辑 删除
RAC连接的问题ORA-12545
连接到RAC数据库的时候经常会出现ORA-12545错误，在METALINK上查询了一下，是Oracle的一个小bug。在远端客户端连接RAC数据库时，通过统一的服务名连接时经常会出现ORA-12545错误。SQL> CONN NDMAIN@TESTRAC输入口...
