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

Collection Status Disabled by Upload Manager – EM Agent

I was investigating an issue whereby our Oracle 10g management agent had stopped uploading its XML files to the Oracle Management Service (OMS). We could not see why, and we had not made any changes. The agent just would not work as it should do. We found the following out: Collection Status: Disabled by Upload […]

Continue Reading

Oracle Enterprise Manager Grid (lock)…HTTP Error 500

After having our 10g Grid control Enterprise Manager system set-up and working well for many months, we started to see issues with  slowness, occasional timeouts on the web pages and jobs becoming suspended more and more frequently and in what seemed to be a random pattern. We were also receiving errors like the below when attempting to […]

Continue Reading

Variables in Batch Files – Using with Oracle SQL Scripts

When writing SQL scripts it is often a requirement to pass in variables like passwords and usernames so that the script is generic and can be used across multiple environments. The same is true when using Windows command files. However, the difference between the two is that you can use 10 or more in SQL […]

Continue Reading

ORA-07445 exception encountered: core dump ACCESS_VIOLATION

While upgrading an Oracle database from 9i to 10g, I got the  following error message. This was completed after having just restored the 9i  database from an RMAN backup. The database was started using the STARTUP UPGRADE option.  This error was seen when running the catupgrd.sql script and taken from the  alert log. ORA-07445: exception […]

Continue Reading

ORA-00600: internal error code, arguments: [ksu_register_tac-1]

The Problem When running an alter table command to add a constraint in parallel, the error below was received: ALTER TABLE policy ADD CONSTRAINT p_risk_key_fk FOREIGN KEY (product_risk_key) REFERENCES product_details(product_details_key); ORA-00600: internal error code, arguments: [ksu_register_tac-1], [], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [skgmrf_release+2236] [PC:0x5631150] [ADDR:0x3ED0] [UNABLE_TO_WRITE] [] The […]

Continue Reading

Using Oracle LogMiner

Log miner is an amazingly useful Oracle utility. I love to use it when there is a dispute about what transactions happened and when. Alert Log Transaction Information If you have been looking in your alert log, and perhaps you are even using CDC, and have seen a number which has the format 0040.027.002c8951, then […]

Continue Reading

ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

The Problem You are receiving the error message: ORA-00257: archiver error. Connect internal only, until freed. You log into the database and try to archive the redo log files and get another error: sys@TEST> archive log all; ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST The Solution alter system set log_archive_dest_state_1=’ENABLE’ scope=both; sys@TEST> archive log […]

Continue Reading

The Job Coordinator and Job_queue_processes

If you are running jobs within the database by using the DBMS_JOB package to submit your jobs to the job queue, you will no doubt know that the job_queue_processes parameter is responsible for determining how many jobs can run at the same time. Each job which runs within the database will be viewable from the v$session dynamic view. […]

Continue Reading

ORA-00600 Internal Error Code, arguments [3020], [9]

The Problem We are running Windows Server 2003, Sp2 on both the primary  and standby DB servers, using Oracle We are using a data guard  physical standby DB, also. We have a large tablespace due to a migration that we had completed as a one-off to load the data into the new database. I attempted […]

Continue Reading

ORA-38701: Flashback database log, ORA-27070: async read/write failed

The Problem I had created a guaranteed flashback restore point in my 11g ( base release) database and I was running in some updates which were very intensive in terms of I/O resource. I should point out that this is on a Windows Server 2003 R2 OS. I noticed that there were disk queues showing […]

Continue Reading