:

RSSScripts

Useful Commands in RMAN

Note: If you want the date in RMAN to be formatted in a specific way, different to the default, have a read of my other article on how to change the RMAN date format. # Find out the tag for the backup set that you want RMAN> LIST BACKUP SUMMARY COMPLETED BETWEEN ’25-04-2013 21:00:00′ AND ’25-04-2013 22:00:00′; # List the backup […]

Continue Reading

ORA-16037: Message 16037 not found

These errors were appearing very regularly on our physical standby databases. They are shown when you stop the recovery operation on the  standby database and we were doing this at regular intervals per day to open the physical standby database for read only access. These errors are not an issue and no further action is required. MRP0: […]

Continue Reading

SP2-0734: unknown command beginning “purge dba_” – rest of line ignored

The SP2-0734 error certainly made me scratch my head for a while. First off, I thought I had got the command wrong because I don’t execute it that much because we have all of our DEV environments configured with the recyclebin off. So I went to the Oracle documentation and realised that I had entered it correctly. Then […]

Continue Reading

ORA-15590: encountered incomplete workload capture files

The Problem I had captured the workload from our production database, copied the workload  capture files to a development database server, upgraded the development database from 10g to 11g  and then attempted to run in this procedure and received the error below: SQL> BEGIN 2    DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE  (capture_dir => ‘WRC’); 3    END; 4    / BEGIN * ERROR at line […]

Continue Reading

Real Application Testing Hangs on Replay

Oracle Version: 11.2.0.3 Platform: Windows Server 2003 SP2 The Problem I was using Real Application Testing, and more specifically the Database Replay tool to get some performance comparison testing done. When running the replay it appeared to hang. I had changed one thing, and that was the following hidden parameter “_disable_flashback_archiver”. This is a hidden […]

Continue Reading

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