Robert Jackson

Having studied a generic Business Computing degree at university, I was fortunate to do my work placement as an Oracle DBA. I enjoyed the challenges of the job and found that my skills were suited to it, also.
Since graduating with a 1st class honours degree in Computing - Database Systems, I have worked my way up from a Junior Oracle DBA to a DBA Team Leader.

rss feed Author's Website

Robert Jackson's Latest Posts

ORA-29381: plan/consumer_group referred to by another plan and cannot be deleted

The Problem When attempting to delete a consumer group from your resource manager configuration, you receive the following error message: EXEC DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; PL/SQL procedure successfully completed. EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; PL/SQL procedure successfully completed. EXEC DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(CONSUMER_GROUP=>’REPORTING_GROUP’); BEGIN DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(CONSUMER_GROUP=>’REPORTING_GROUP’); END; * ERROR at line 1: ORA-29381: plan/consumer_group REPORTING_GROUP referred to by another plan and cannot be deleted ORA-06512: […]

Continue Reading

ORA-00600: internal error code, arguments: [kzaxins:sqtxt]

We had a scheduled job which ran each day to delete the archive logs which we no longer required. We noticed that the same job errored intermittently with the following error message: ORA-00600: internal error code, arguments: [kzaxins:sqtxt], [], [], [], [], [], [], [] I don’t think it is specific to the command we […]

Continue Reading

Oracle Agent Ports

To put it simply, I have found that you need to have the following ports open in order to get Oracle’s Enterprise Manager to work: Port 1754 (from OMS to DB) Port 7772 (from DB to OMS) The above refers to the Oracle Management Server (OMS), which is where the Oracle software for Enterprise Manager is […]

Continue Reading

Oracle Implicit Commit

The idea behind this test came from a script which was rolled into a production environment. The script had been tested but the incorrect data was only on the production database and we decided that we would leave the commit out of the script and see what the results were before committing it. Within the script […]

Continue Reading

RAT – Workload Analyzer

I have recently been playing around with Real Application Testing (RAT) and as part of the replaying of a captured workload it is advisable to run the Workload Analyzer if you are using the APIs to replay the workload. This is required to identify any potential problems by analyzing the workload capture files in the […]

Continue Reading

How to use the FINDSTR Command in Windows

After upgrading or patching your Oracle software on a Windows platform it’s necessary to check through the log files for any errors encountered during the process which have not caused the upgrade to fail. In order to do this, I use the findstr command against the log file, and example would be: findstr /B /N […]

Continue Reading

RMAN Performance – Block Change Tracking

A new feature within Oracle 10g is the ability to improve the performance of your RMAN incremental backups by using BLOCK CHANGE  TRACKING. The block change tracking feature uses a file stored on the file system to record which blocks have changed since the last backup. Then, when RMAN starts its backup, it can read the file […]

Continue Reading

MISSING Streams multi-version data dictionary

I was testing out the effects of making changes to tables within the source database in a Change Data Capture (CDC) configuration on Oracle. I was adding columns, removing columns, etc and seeing what changes I needed to make in the destination database in order to keep everything working as it should. I then tried […]

Continue Reading

ORA-15567: replay user encountered an error during a sanity check

The Problem I was playing around with Real Application Testing (RAT) on my Oracle 11g database. I had captured a workload from my production database and was attempting to replay the workload into a development database which was a copy of PROD. While attempting to connect the workload replay client to the database, I received the following […]

Continue Reading

ORA-00600: internal error code, arguments: ktsladdfcb-bsz

The Problem I was playing around with the securefile feature in Oracle 11g, which is used with LOB segments. I was trying to create a tablespace with the smallest extent size possible because I wanted to see the affect of using compression quickly and I thought the easiest way was to create a small extent […]

Continue Reading