OGG OGG-01496 OGG-01028
今天由于没有正常的先关闭源端的PUMP进程而直接关闭了备库的replicat和MGR进程。导致PUMP进程启动不了报错如下:OGG-01496 Oracle GoldenGate Capture for Oracle, py169.prm: Failed to open target trail file ./dirdat/tb000183, at RBA 4434691.我对PUMP提示使用下一个trail文件alter extract py169, ...
ORA-27102: out of memory Linux Error: 28: No space left on device
[oracle@rac1 ppzhu]$ more CloneRmanRestore.log ORA-27102: out of memoryLinux Error: 28: No space left on deviceselect TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual*ERROR at line 1:ORA-01034: ORA...
Heap size exceeds notification threshold
转自网络Tue Oct 16 18:41:06 2007Memory Notification: Library Cache Object loaded into SGAHeap size 5118K exceeds notification threshold (2048K)Details in trace file /oracle/admin/era3/udump/era32_o...
ORA-00603 ORA-00604在建立DBLINK的时候
原创建立好DBLINK查询报错如下:ORA-02068: 以下严重错误源于testORA-03113: 通信通道的文件结束ORA-02068: 以下严重错误源于testORA-00603: ORACLE server session terminated by fatal errorORA-00604: error ...
ORA-04021
CauseThere is a lock on a library object when doing the export.Error: ORA 4021Text: time-out occurred while waiting to lock object <name>--------------------------------------------------------------...
OUI-10058问题原因
原创 转载请注明出处 遇到了故障OUI-10058: The OUI Inventory on this system does not exits or is not writable .1-The /opt/oracle/oraInventory/orainstRoot.sh script. was not executed with root pri...
ORA-02069:解决方法
今天遇到了ORA-02069: global_names parameter must be set to TRUE for this operation查了METALINK原因是不能在通过DBLINK操作远程表的DML语句中使用本地函数原文如下:Because of a limitation, it is not pos...
ORA-01438处理方法
(我的学习过程)今天公司的同事告诉我生产系统出现了ORA-01438错误如下ORA-01438: value larger than specified precision allowed for this column由于定位不到具体的表以及具体的字段,同事问我们是否可以跟...