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]

pdfchm.net is dead, unfortunately

This is secure area for those who have helped us develop our project.
There is no registration in our project. Please don't ask.
We don't sale any books presented in our catalogue.
You can purchase this books in Internet shop "AMAZON.COM" by clicking Buy Now button.



Unfortunately, our project can no longer maintain the infrastructure necessary for the operation.
So we took a difficult decision to stop operation.
Your account information (email and other data) will be removed soon.
Sorry for any inconvenience.
PDFCHM