:

The Latest Oracle Posts

UDE-00014: invalid value for parameter, ‘schemas’

When using the data pump utility with the QUERY parameter to export only a subset of the data, I ran into the error: UDE-00014: invalid value for parameter, ‘schemas’ As it turns out, you cannot fully qualify the table names within your QUERY statement. The reason for this seems to be because you can only […]

Continue Reading

Wait Event enq: TX – allocate ITL entry

Oracle Version: 10.2.0.4 Platform: Windows Server 2003, SP2 Our system had steadily been getting busier and busier, as the business grew and more customers start using the system. Up until now the system has been performing quite well; the AWR reports don’t show any unwanted wait events and the SQL queries have been tuned nicely […]

Continue Reading

Oracle 11g Enterprise Manager Agent Tracing

If you are having issues with your Oracle 11g agent, perhaps you are experiencing high CPU load from a perl.exe process, then you may want to turn tracing on in order to upload the details to Oracle support. Here is how you go about doing that: Create Backups of Configuration Files 1. Backup agent11g/sysman/config/emagentlogging.properties 2. […]

Continue Reading

Checking operating system version failed; must be 5.0, 5.1, 5.2 or 6.0. Actual 6.1.

The Problem You want to install Oracle version 10.2.0.4 onto a Windows Server 2008 OS machine, which is not actually supported. When you run the executable to start the installer you receive the following message on your screen: Checking installer requirements… Checking operating system version: must be 5.0, 5.1, 5.2 or 6.0. Actual 6.1 Failed […]

Continue Reading

ORA-00904: string: invalid identifier

The Problem You have written a SQL statement and are running it from the SQL Plus command prompt and you receive the error message ORA-00904: string: invalid identifier. You may have been running an Oracle procedure, package or anonymous block of PL\SQL code and received this error. The Solution To resolve your ORA-00904 error message […]

Continue Reading

Development DBA or Production DBA?

First off, let me clarify what DBA stands for! It can stand for DataBase Analyst, but I’m referring to it as a DataBase Administrator. The names are only slightly different, but the roles are very different. There is a distinction between Oracle DBAs, and not only in terms of skill and experience. There are two […]

Continue Reading

What does an Oracle DBA do?

Some people might answer this question rather facetiously, and say “not a lot!” Others, like many Oracle DBAs themselves, would say “Manage, maintain and improve an application built upon an Oracle database.” So, what jobs would you expect an Oracle DBA to do? Here is a list of some general things that you would be […]

Continue Reading

How Can I Become an Oracle DBA?

Direct or Indirect… It’s not very common for someone to get a job as an Oracle DBA straight out of university. It’s usually a job for a more experienced candidate and someone who has already been an Oracle DBA. If you’ve never been an Oracle DBA how do you get the experience to get a […]

Continue Reading

ORA-31641: unable to create dump file

The Problem You are attempting to execute the data pump utility and export some data from your database but when you run the command which was previously working without any errors you receive the following error: ORA-31641: unable to create dump file “C:\Temp\export.DMP” The Cause There will, most likely, already be a file name “export.DMP” […]

Continue Reading

RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

The Problem One of our regularly scheduled jobs on PROD which backs up the archivelogs each day failed with the error message below: RMAN-03002: failure of backup command RMAN-06059: expected archived log not found, loss of  archived log compromises recoverability ORA-19625: error identifying file  M:\ORACLE\LOGS\LOG_246800_1.ARC ORA-27041: unable to open file OSD-04002: unable to open file The […]

Continue Reading