Presented by: Jeremiah Wilton, Blue Gecko Jeremiah’s patented Breaking Oracle seminar – a one-hour condensed version of a full-day class – was again a huge hit. To a packed room, Jeremiah mercilessly rained spins, hangs, corruption, and a variety of other Oracle failures and disasters on a poor, unsuspecting test 11hg database, then demonstrated … [Read more...]
New presentation: Simulating failures for testing and diagnostic practice
In this entertaining presentation, Jeremiah Wilton demonstrates creative ways to induce Oracle failures with the objective of learning how to detect, assess and diagnose problems. Some of the self-induced failures are quite amusing, and will allow the reader to have some fun with their DBA friends. Check out the presentation on our whitepaper … [Read more...]
ORA-00600 [kkojcio]
According to Oracle Support note 336315.1, this ORA-600 error is a known issue (bug 4335559) affecting some versions of 9i and 10g. It is a bug in the cost-based optimizer's initial join order routine. The note mentions a simple known workaround that you can implement either in one session, or throughout the whole Oracle instance. To implement … [Read more...]
ORA-00600: internal error code, arguments: [keltnfy-ldminit]
This ORA-600 is a result of the Oracle server's server alert subsystem (DBMS_SERVER_ALERT) being unable to determine the local host name. Most frequently, this is due to DNS (domain name service) not being available. This error can result in instance failure (crash) or inability to start up. Patches for 10.2.0.2 and 10.2.0.3 available for: … [Read more...]
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]
This error may appear during instance shutdown. You may safely ignore this error, as it is raised only after the database has been closed. No action or corrective steps on the part of the DBA are required. The condition that causes this error to be raised is caught and handled starting in 11.1.0.6. No patches available Although the occasional … [Read more...]