:

The Latest Oracle Posts

What Qualities make a good Oracle DBA?

I’m sure that there are lots of opinions about this, and there will be certain qualities which are more desirable depending on the specifics of the role in question. For example, someone who is client facing and interacts with a lot of people will need to have a higher level of communication skills than someone […]

Continue Reading

What is a DBA?

A very common question is “What is a DBA?” or “What is an Oracle DBA?”. Within the remainder of this article I hope to answer both of those questions and provide you with some more information about how to become an oracle DBA and what an Oracle DBA does. Let’s first start by defining what […]

Continue Reading

ORA-14099: all rows in table do not qualify for specified partition

We have a table within our DB which stores every transaction which is made within our application. As you can imagine, this table is heavily updated and we create around 10,000,000 rows everyday on our Production system. Further to this, we are required to save this data for 2 weeks just in case we need […]

Continue Reading

ORA-29558: JAccelerator (NCOMP) not installed

I was setting up Change Data Capture in one of our databases recently. I was attempting to create the change tables in the database and I received the following errors. ORA-29558: JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions. ORA-06512: at “SYS.DBMS_JAVA”, line 236 ORA-06512: at line 2 You can read the Metalink […]

Continue Reading

Exploring the ARCHIVE_LAG_TARGET INIT.ora Parameter

It is possible to control the lag associated with how often online redo log files are archived, and therefore the time between changes to a primary database and standby database. This is particularly helpful when using Change Data Capture and applying the changes from the archive logs and not the online redo logs. The ARCHIVE_LAG_TARGET […]

Continue Reading

ORA-07445: exception encountered: core dump [qeshIHInsertPRowInBkt+488]

The Problem The error below showed up when we were running a SQL statement which required a hash group by in it. We are running Oracle version 10.2.0.4, patchset 3 (base release). It is a very intermittent error, as 9 times out of 10 there isn’t a problem with it but then sometimes we see […]

Continue Reading

SQLPlus Hangs

We were seeing an intermittent problem very recently whereby the listener would not accept connections for all DBs that it was listening for. A restart of the listener would resolve the issue, but within 5 minutes of the restart it would be stop accepting connections again. We had no idea what was causing the issue, […]

Continue Reading

IPC vs TCP Connectivity Using TNSNames

When your code requires a connection to the database, and it  is on the same physical machine, it can be very advantageous to add an entry  into your TNSNames file so that the connection can occur using the IPC protocol  rather than the TCP protocol. This is because the IPC protocol negates the need for […]

Continue Reading

.patch_storage Consuming Large Amount of Space

The Problem You have multiple Oracle Homes installed on the same DB server and you notice that the size of the software is increasing pretty rapidly. You have patched the homes many times since you installed the base release and it seems to grow with each patch application. In particular, you notice that the .patch_storage […]

Continue Reading

OMS Won’t Start – StatusOMSCmd.java:223

The Problem After restarting the 11g OMS and Grid Control Repository, I was receiving the error below when running the command: D:\oracle\Middleware\oms11g\BIN>emctl start oms Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started Oracle Management Server is not functioning because of the following reason: Unexpected error occurred. Check error and log files. Please check D:/oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error […]

Continue Reading