The Latest Oracle Posts
ORA-39125: Worker unexpected fatal error in KUPW$WORKER
The Problem I was using our physical standby database to run a data pump export job. I had created a guaranteed restore point so that I was able to flashback the DB to its original state but I was not able to get the export working. There was no real error message on the screen. […]
ORA-13761: invalid filter
The Problem You are trying to populate a SQL Tuning Set (STS) from the cursor cache using the DBMS_SQLTUNE Oracle supplied package, as below: user@DB> EXEC DBMS_SQLTUNE.CAPTURE_CURSOR_CACHE_SQLSET( – > sqlset_name => ’10g_TEST’, – > time_limit => 60, – > repeat_interval => 10, – > capture_option => ‘MERGE’, – > basic_filter => ‘PARSING_SCHEMA_NAME = ”TEST”’, – […]
ORA-38171 Insufficient privileges for SQL management object operation
The Problem You are trying to load plans into a SQL Management Baseline (SMB) in your 11g DB and you receive the following error: SQL> DECLARE 2 my_plans PLS_INTEGER; 3 BEGIN 4 my_plans := DBMS_SPM.LOAD_PLANS_FROM_SQLSET( sqlset_name => ‘TEST’); 5 END; 6 / DECLARE * ERROR at line 1: ORA-38171: Insufficient privileges for SQL management object […]
ORA-01489 result of string concatenation is too long
The Problem The result of string concatenation cannot be more than 4000 characters long. If the string concatenation is too long, you will receive the following error message: ORA-01489: result of string concatenation is too long The Solution Example I If you are using dynamic SQL and the resultant string is greater than 4000 characters […]
Resource Manager Plan After 11g Upgrade
This is critical information for any Oracle DBA looking to upgrade their 10g database to 11g. It concerns a new default resource manager plan which is enabled after you have upgraded your database from 10g to 11g. The name of the plan is called something like “SCHEDULER: DEFAULT_MAINTENANCE_PLAN”. This will show up if you run […]
Archive Log Mode – The Details
In this article I would like to discuss the archiving of REDO logs within the Oracle database. REDO generation is one of the fundamental ways in which your Oracle database is able to recover from failures, use Data Guard, Change Data Capture and many other functions which rely on tracking and using all changes made […]
ORA-00257 archiver error. Connect internal only, until freed
If you come across this error it means that your database is in archivelog mode and it is not possible to archive the current online redo log file. This is usually because the archive log drive has become full and needs to be cleared down. Step 1: make some more space on the archivelog drive You […]
ORA-00600: [32695], [hash aggregation can’t be done]
The Problem You are running a SQL query and come across the following error message: ORA-00600: internal error code, arguments: [32695], [hash aggregation can’t be done], [], [], [], [], [], [] The Cause You may be hitting Bug 6471770 or Bug 5893340. You can check these out on Metalink for more detail. It does […]
Oracle Export & Import Performance Improvements
Index Creation in Parallel In Oracle version 9i, the Oracle import utility runs single threaded which means that you cannot take advantage of parallel processing. It is possible to import just the data through Oracle’s import utility and then create the indexes in parallel afterwards. You can specify a file for the index creation statements […]
IMP-00058 – Using Oracle 10G client with 9i Database
UPDATE: Although these IMP-00058 errors were encountered when using a 10g and 9i client, I believe that it can also apply to other versions of Oracle where there is a mismatch between the client utilities when exporting and importing IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component ‘SET_NO_OUTLINES’ must be declared […]
