Scripts
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 […]
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: […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]