how to relink oracle binaries with rac to off

ORA-29702: error occurred in Cluster Group Service operation




MRP0: Background Media Recovery terminated with error 1274



ORA-25137 Data value out of range

Sometimes , there could be also a logical corruption inside an oracle table , which could lead to this error message .

In our case, the corruption was identified by applying length(affected_column) . The result was -1 for a row, which signifies a logical corruption .

esecul by tudor galos

 "...unde începe eșecul? Eșecul începe în momentul în care îți miroase a bine; atunci trebuie să te pregătești, pentru că sub mirosul de flori s-ar putea să vină mirosul de putregai al vreunui detaliu pe care îl uiți în beția succesului. "
"In momentul în care lucrurile merg foarte bine, lumea uită de disciplină; nu mai este atentă la detalii, nu mai este atentă la informațiile care curg, se uită doar la cifre; care cifre arată bine"


[Oracle][Odbc]Numeric Value Out Of Range. (#0)

Sometimes it's easier to delete the entire statistics (dbms_stats.delete_table_stats) for the table affected :



how to recover ocr when it is on ASM

How to restore ASM based OCR after complete loss of the CRS diskgroup on Linux/Unix systems [ID 1062983.1]


why SGA + PGA must be maximum 60% of total memory available on a Linux Server


By default Linux uses up to 40% of the available memory for file system caching
You can lower the mark for flushing the cache from 40% to 10% by setting “vm.dirty_ratio=10″ in /etc/sysctl.conf.


Starting with Oracle Database 11g Release 2 (11.2), setting JOB_QUEUE_PROCESSES to 0 causes both DBMS_SCHEDULER and DBMS_JOB jobs to not run. Previously, setting JOB_QUEUE_PROCESSES to 0 caused DBMS_JOB jobs to not run, but DBMS_SCHEDULER jobs were unaffected and would still run.


CRS daemon depends on private interconnect

How to Modify Private Network Interface in 11.2 Grid Infrastructure [ID 1073502.1]