how to relink oracle binaries with rac to off

ORA-29702: error occurred in Cluster Group Service operation

After Cloning RAC to Single Instance, How to Remove Any References to the Additional Threads [ID 759032.1] NON-RAC Database Startup Giving Error ORA-29702 [ID 433310.1]

MRP0: Background Media Recovery terminated with error 1274

MRP0: Background Media Recovery terminated with error 1274 [ID 739618.1]

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 :

MSAccess fails with [Oracle][Odbc]Numeric Value Out Of Range. (#0) [ID 1318028.1]

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

http://blog.ronnyegner-consulting.de/2011/10/13/info-task-blocked-for-more-than-120-seconds/

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.

job_queue_processes

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.
https://blogs.oracle.com/UPGRADE/entry/dbms_scheduler_jobs_stuck_after

CRS daemon depends on private interconnect

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