:

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. […]

Continue Reading

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”’, – […]

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

ORA-00257 archiver error. Connect internal only, until freed

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

Continue Reading

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

Continue Reading

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

Continue Reading

IMP-00058 – Using Oracle 10G client with 9i Database

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

Continue Reading