-
编辑 删除
Oracle 18C,19C standby CHECKPOINT_CHANGE# 不更新问题
问题：因为电力问题，一台Oracle 19.3 standby没有正常shutdown immediate关机。来电后standby机器开启startup DB时发现要做media介质恢复，且archive log seq号要从512号开始找，512号seq是几个月前一次正常关机时的archive log，alertlog如下：2021-05-17T15:23:14.172329+08:00PR0
-
编辑 删除
主库到standby报错解决：Error 12154 received logging on to the standby ORA-12154
背景：笔者建库无数，但今天对Oracle 11.2.0.3库使用duplicate新建standby后，主库redo无法通过RFS传输至standby主库alert.log报错： Thu Jun 14 14:05:20 2018Error 12154 received logging on to the standby主库报错生成trc文件：*** 2018-06-14 14:25:20.581Redo shipping client performing standby login...
-
编辑 删除
ORA-8103 Troubleshooting, Diagnostic and Solution (文档 ID 8103.1)
APPLIES TO:PURPOSEThis note is intended for general audience as initial starting point for beginning diagnosis of ORA-8103.DETAILSError: ORA 8103 Text: object no longer exists -------------------------------------------------------------------------------Cause: The o...
-
编辑 删除
ORA-03137: TTC protocol internal error: [12333]分析及处理
DB: Oracle 11.2.0.1 OS: Redhat Linux 5.3 64bit異常： 阳春三月的周末，正准备出门踏青，突然接到用户的电话说一个程序使用中报错ORA-03113，但其它功能程式可正常使用。检查DB日志 alert.log: Sat Apr 14 10:43:04 2018Errors in file/u01/product/diag/rdbms/orcl/orcl/t...
-
编辑 删除
ORA-07445 [kslgetl()+80] ORA-00108主机名配置不一致引起的报错
环境：Oracle 10.2.0.4, Red Hat Linux4.5 32bit3.8妇女节这天，一台DB server因硬件故障挂掉。固通过备份恢复后的DB到新server上，恢复的DB开启没用多久硬盘就满了，检查DB bdump目录写了大量trc文件，且open后alert.log不断的报错：Fri Mar 9 04:19:59 2018dispatcher 'D000' encountered error getting ...
-
编辑 删除
ORA-31693 ORA-00604 and ORA-942 During Data Pump Import
ORA-31693 ORA-00604 and ORA-942 During Data Pump Import (文档 ID 1943390.1)In this Document...
-
编辑 删除
RAC Instance Crashes During Startup Due To Error 495
RAC Instance Crashes During Startup Due To Error 495 -GEN0 process terminated with error (文档 ID 1547091.1) Applies to: Oracle Database -Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.Symptomso GI & ...
-
编辑 删除
ORA-00600 [733] WHEN START 9i DATABASE
平臺: Oracle9i Enterprise Edition Release 9.2.0.8.0 -Production Windows 2003(32bit) 問題：standby database 斷電后，再啟動時startup nomount;報錯：ORA-00600: internal errorcode, arguments:[733], [1780491312], [pga heap],[],...
-
编辑 删除
Bug 10202228 wrong result when _allow_level_without_connect_by set to true
Bug10202228 wrong result when _allow_level_without_connect_by set totrue This note gives a brief overview of bug10202228. The content was last updated on: 25-OCT-2011 Click here for details of each of the sections below.Affects:...
-
编辑 删除
Oracle active dataguard ORA-01555
Bug 10018789 Spin in kgllock / DBhang with high library cache lock waits on ADG This note gives abrief overview of bug 10018789. The content was last updated on: 03-SEP-2013 Click here for details of each of the sections below.Affects:...
-
编辑 删除
Oracle standby ORA-00600:[3020] ORA-10567
現象Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - 64bit ProductionRed Hat Enterprise Linux Server release 5.3(Tikanga) 64bit 在主庫執行將文件從4G改小為2G后ALTERDATABASEDATAFILE'/data/orcl/undotbs04.dbf'RESIZE2000M; Standby DB中SELEC...
-
编辑 删除
DBCA建库报错 ORA-13516 / ORA-06512
DBCA fails in the middle of database creation withORA-13516 / ORA-06512 (文档 ID 1929718.1) In this Document Symptoms Cause SolutionApplies to:Oracle Database - StandardEdition - Version 11.2.0.2 t...
-
编辑 删除
ora-600 [rwoirw: check ret val] with count distinct and order by
點檢DB看到web程式引發 ORA-00600[rwoirw:check ret val]Mon Mar 02 09:32:062015 ORA-00600: 内部错误代码, 参数: [rwoirw: check ret val]問題SQL：SELECTSUM(MD01)MD01,SUM(MD02)MD02,SUM(MD03)MD03,SUM(MD04)MD04,SUM(MD05)MD05,SUM(MD06)MD06,SUM(MD07)MD07,SUM(MD08A)MD08A...
