This is a subject I have much interest in and something we are working on very hard at Blue Gecko; Amazon is positioning itself as an Oracle partner and leader in the Oracle/cloud space and I want to know anything I can about what other people are doing, which is why this presentation was not what I was hoping it would be. The gentleman presenting … [Read more...]
Oracle, MySQL, MariaDB, and Drizzle. oh my.
To follow up on Chuck's post from earlier this week, I want to say that yes, on Monday morning I raced across the office to share the crazy news that Oracle is trying to buy MySQL Sun. Though, I don't remember yelling. But, I did have a real point here and that is that the numbers that he quoted are prior to the Enterprise / Community split that … [Read more...]
Oracle also acquires MySQL… right?
Yes, we all know that Oracle has acquired Sun. Or intends to. They still have to get through a few hurdles, one of which will be the SEC. My first thought upon hearing the news (delivered by Sarah, running over to the copy machine yelling, "Did you hear?! Oracle just bought Sun!!" causing me to completely jam the automatic paper feeder, and … [Read more...]
Oracle Education – Our First DBA Class!!
We are very pleased to announce our very first Oracle Class open to the general public! Taught by our very own Jeremiah Wilton, this class is titled “Hands-on Oracle Database Administration one-week Total Immersion.” We are pleased to offer the opportunity to build upon your professional skills with a week-long hands-on intensive … [Read more...]
Blue Gecko featured at Oracle Technology Solutions Fair
Blue Gecko has been recognized as a key Oracle partner, and will participate with the Seattle Oracle database team at the Oracle Technology Solutions Fair. Jeremiah Wilton and JJ Ecker will be on site to answer questions about the latest database features, tuning, and general Oracle database questions, so please register for the fair today and … [Read more...]
Blue Gecko Announces Free Oracle Database Performance Reviews
SEATTLE, WA--(Marketwire - March 31, 2009) - Seattle-based remote DBA services company Blue Gecko, Inc. (http://www.bluegecko.dk), is now offering free performance evaluations. The promotion will extend through 6/30/2009. Blue Gecko President Chuck Edwards cited the importance of keeping databases in tune, especially now that so many people are … [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...]
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...]
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...]