:

The Latest Oracle Posts

ORA-01341: LogMiner out-of-memory

The Problem Having recently set-up and configured an environment using Change Data Capture (CDC), we were running through a test which was a representative workload on the main system. After some time we encountered the following error: ORA-01280: Fatal LogMiner Error. ORA-01341: LogMiner out-of-memory This error was at the downstream database. We were using Asynchronous […]

Continue Reading

ORA-27038 Dump File Already Exists

Oracle Version: 11.2.0.3 Platform: Windows Server 2003, SP2 The Problem When running a data pump export job you get the error listed below: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 With the Partitioning and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file “USER_EXP.dmp” ORA-27038: […]

Continue Reading

Using a Physical Standby Database in Read Write Mode

Using a Physical Standby Database in Read Write Mode OS: Windows Server 2003, SP2 DB: 10.2.0.4, patchset 3 (base release) Requirements We currently have two physical standby databases, one of which is at a physically different location several hundreds of miles away from the primary database site. We use these physical standby databases in case of a […]

Continue Reading

ORA-26663 – When Dropping a CDC Change Set

There are lots of times when you are new to a technology that you want to wipe the slate clean and start your process again because you are not sure where it went wrong. I attempted this after receiving several errors within Change Data Capture, and the capture and/or apply processes were receiving the ORA-26663 error. So, […]

Continue Reading

ORA-00600, arguments: [3020]

Platform: Windows Server 2003, SP2 Oracle: 11.0.2.0, patchset 10 The Problem From our PROD DB servers we have two data guard DBs up and running as physical standby DBs; one very nearby and another one across the water in another country. These standby DBs were running along very happily, shipping logs from the primary DB […]

Continue Reading

Oracle UNDO

In this article I will cover a few important topics surrounding UNDO management in Oracle, specifically automatic undo, including the follwing: How to monitor the amount of UNDO being used UNDO_RETENTION parameter setting ORA-30036 unable to extend segment in undo tablespace ORA-01555 snapshot too old How to change the default UNDO tablespace Undo in Oracle […]

Continue Reading

00600: internal error code, arguments: [rworupo.1]

The Problem I am running Oracle version 10.2.0.4, patchset 3 which is the base release patchset for 10.2.0.4 on Windows. We received an Oracle Ora-00600 error message just the other day which is always cause for concern. The error message we received was: 00600: internal error code, arguments: [rworupo.1], [10], [7], [], [], [], [], […]

Continue Reading

ORA-31626: job does not exist

The Problem We have a scheduled data pump job which runs every month to export an old partition of a table which we subsequently drop – it’s no longer needed in the application but we keep it as an export just in case we need to get the data back for some reason. Anyway, this […]

Continue Reading

ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’

The Problem While attempting to gather statistics within my schema, I received the following error: ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’ The Cause I was unsure what the problem was so I wanted to check that I had the basic parameters set correctly. SQL> show parameter undo NAME       […]

Continue Reading

NID-00137: All datafiles that are not dropped should be readable

The Problem You are using the DBNEWID utility (The NID command) to change the name and/or ID of your database and you receive the following error: Cannot read the header of the following datafiles: D:\ORADATA\GENERAL\TEMP01.DBF (1), error: 4 D:\ORADATA\GENERAL\TEMP02.DBF (2), error: 4 D:\ORADATA\GENERAL\TEMP03.DBF (3), error: 4 D:\ORADATA\GENERAL\TEMP04.DBF (4), error: 4 D:\ORADATA\GENERAL\TEMP05.DBF (5), error: 4 NID-00137: […]

Continue Reading