:

The Latest Oracle Posts

What DBA Qualifications Should I get to Become an Oracle DBA?

What qualifications are out there for Oracle DBAs to obtain? Well, there are a couple of areas to look at: Courses for Oracle DBAs Oracle qualifications for Oracle DBAs Courses for Oracle DBAs There are hundreds of courses out there for Oracle DBAs, ranging from courses to help you administer to the database to courses […]

Continue Reading

ORA-06512: at “SYSMAN.MGMT_JOB_UI”, line 4847 ORA-06512

The Problem When attempting to remove a job from the Enterprise Manager library, you receive the following error message: ORA-01403: no data found ORA-06512: at “SYSMAN.MGMT_JOB_UI”, line 4847 ORA-06512: at line 1 The Cause It seems to be because there is no target associated with the job. If you look at the job in the […]

Continue Reading

ORA-06512: at “SYS.UTL_TCP”

I was developing a new package which was carrying out some  maintenance processes, such as partitioning logging tables and dropping the old  partitions. As part of the process, my procedure would email out the errors when  running. The first stage, however, was to get the procedure to compile. I was  getting the following errors: ERROR […]

Continue Reading

ORA-06512: at line Error Messages

The ORA-06512 error message is a generic error message given to capture all PL/SQL error messages. There are multiple situations and solutions below so please read the full article. The Problem You are running a piece of PL\SQL and are receiving this message: ORA-06502 and ORA-06512: at line <line number> Note: There are multiple solutions to this […]

Continue Reading

Open a Physical Standby Database for Read Only

Once you have configured your physical standby database and it is functioning as you require, you may consider opening the database at certain times for read only access. Why would and wouldn’t you want to do this? Benefits You can reduce the load on the primary database if there are reporting jobs which are required […]

Continue Reading

Data Guard Sessions

From my experience, it is common practice to open up a physical standby database for read only, reporting purposes. If you’re running the data guard set up in maximum performance mode, it makes sense to allow some use of the physical standby DB so as to reduce load on the primary database server. You can […]

Continue Reading

NID-00111: Oracle error reported from target database

I was restoring an Oracle 10g database using RMAN from our production environment to a development environment. I had completed most of the necessary steps, and the database was restored and recovered up to the point in time that I wanted. The next step was to run the NID command in order to change the […]

Continue Reading

Oracle Hidden Parameters

Under normal circumstances you shouldn’t have any need to modify the Oracle hidden parameters, which all start with the underscore character. This is probably why you can’t see them very easily in the database with the normal SHOW command. If you would like to find out what hidden Oracle parameters are set within your database, […]

Continue Reading

Spaces in Source Table show as NULL in Change Tables

The Problem We came across an issue within our Change Data Capture configuration where we would get NULL values in our change tables, but we didn’t understand why because we had unconditional log groups for the columns which were showing as NULL in the change table. The Cause Spaces input by users caused the NULL […]

Continue Reading

Symbol file oraclsra11.SYM does not match binary

The Problem I installed and patched Oracle 11.2.0.1 to patchset version 5 which was the latest one out at the time. The install went without error and I upgraded several of my databases to start using the new software. I then received a call from a developer who was getting the following error message when […]

Continue Reading