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...]
Why should I properly close my Oracle E-Business Suite session?
We've all been there before. It's noon, and you're co-worker is telling you to tidy up - it's time to go to lunch. Your E-Business Suite session is idle, and in your haste you simply click the 'X' at the top of your browser. You know it's not the proper thing to do, but you're not sure of the implications.... What happens when I close my session … [Read more...]
Our own Sarah Novotny is Seattle’s “Geek of the Week!”
Sarah Novotny is featured in the Seattle PI as the "Geek of the Week." We're all quite pleased with the well-seserved recognition, and hope you have a minute to check out the article. Leave a comment and let her know what you think! Nice work, Sarah! … [Read more...]
Seattle-area Oracle Applications Tech Group
Announcing the first meeting of the Seattle Oracle Applications Technology Group! This group will be dedicated to knowledge sharing and learning between Oracle Applications Technology professionals in the Puget Sound area. I'm hopeful we can get a regular group of Apps DBAs, developers, Apps admins, and other people connected with E-Business … [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...]
Oracle error ORA-00904: “%s”: invalid identifier
This is the first in a series of blurbs on common Oracle errors. Enjoy! Most people get ORA-00904 because they forgot to put quotes around a literal string in their SQL. Example: … [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...]
ORA-06512: at “%s”, line %d
The ORA-06512 error doesn't tell you what is wrong, it tells you in which object at which line the error occurred. The error doesn't mean much by itself. It is simply the catch-all Oracle error for PL/SQL (procedural SQL) exceptions. This error is almost always preceded by a different message stating the reason for the error. Check the error that … [Read more...]
ORA-12154: TNS:could not resolve the connect identifier specified
The error also appears in some versions as: "ORA-12154: TNS:could not resolve service name." When a program needs to connect to an Oracle service via Oracle Networking (SQL*Net), it must look up the connect data for that service somewhere. When the lookup fails, the Oracle client code raises ORA-12154. Most people will encounter this error when … [Read more...]
Blue Gecko acquires ORA-600 Consulting
Seattle, WA (March 19, 2009)—Seattle-based remote DBA services company Blue Gecko, Inc. (http://www.bluegecko.dk), as part of its strategy to enhance emergency support and education offerings, announced that it has acquired Seattle-based ORA-600 Consulting, a premier provider of Oracle administration, recovery and education services. ORA-600 … [Read more...]
Firefox 3 certified against E-Business Suite
Steven Chan posted on his blog yeterday that Oracle has announced certification of E-Business Suite and Firefox 3. There are some pre-requisites which should be carefully reviewed, but this is great news for E-Business Suite customers pining to get off of Firefox 2. The framework patch 7651759 in particular specifically targets Firefox 3 users … [Read more...]
Proactive support
We all know proactive service when we see it. A couple of examples: Proactive is when you are shopping for a new gadget, but just before you buy it the clerk tells you a special battery is required (even though the box fails to mention it) but is not included. “Would you like one of those as well?” Proactive is a waiter asking his patrons if … [Read more...]
Velocity 2009
I've had the pleasure of being asked to speak at Velocity 2009 and tomorrow I go to San Francisco to participate the the Velocity Summit. I'll get to rub elbows with the cabal that is planning/producing and executing the mamouth undertaking that is running a conference. I gave four topic possibilities all focused on MySQL or 24/7 operational … [Read more...]
ORA-04031 and ASMM
Oracle E-Business Suite customer was reporting ORA-04031 errors being returned by the database. There were a number of ORA-04031 shared pool errors generated in the alert by background processes: ORA-04031: unable to allocate 168 bytes of shared memory ("shared pool","select t.ts#,t.file#,t.block...","Heap0: KGL","kglob") I checked the shared … [Read more...]
- « Previous Page
- 1
- …
- 9
- 10
- 11
- 12
- 13
- Next Page »