:

The Latest Oracle Posts

RMAN-00554: initialization of internal recovery manager package failed

The Problem I wanted to check out some of the RMAN parameters on a database and make sure that they were configured properly and I received the error below: Recovery Manager: Release 11.2.0.2.0 – Production on Tue Jan 18 16:28:06 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. target database Password: […]

Continue Reading

Remove Parameter from SPFile

I have seen the point made several times where an Oracle document says to remove or unset a parameter in the database. Based on what I have seen and tried, here is the way that I would recommend to do it. I’ll start with an example of how to do it: ALTER SYSTEM RESET remote_archive_enable […]

Continue Reading

Change Password in Oracle 11g – Password Column Empty

In Oracle 10g it was possible to select the encrypted password from the DBA_USERS view so that you could effectively hack into someones account and then change the password back without them knowing. The way to do this was as follows: SELECT username, password FROM DBA_USERS WHERE username LIKE ‘SECRET%’; Once you have the password […]

Continue Reading

ORA-01873: the leading precision of the interval is too small

The Problem I was regularly receiving the following error messages in the emagent.trc file for my Oracle 11g agent. This may or may not have been after I switched tracing on but I only noticed them after it had been switched on because I was investigating an issue we were having with high CPU load […]

Continue Reading

Data Pump Import Hangs – Inactive

When running an import using data pump, the session logs on but doesn’t do anything. The only message present within the alert log is this: kupprdp: master process DM00 started with pid=24, OS id=7244 to execute – SYS.KUPM$MCP.MAIN(‘SYS_IMPORT_SCHEMA_01’, ‘SYS’, ‘KUPC$C_1_20100416103259’, ‘KUPC$S_1_20100416103259’, 0); It took me a while to realise it but there was no TEMP […]

Continue Reading

Oracle Database 11g Information

Here at ORA00600.com we like to try and bring you the latest information from within the database community. We put up solutions to error messages we come across and configuration issues we encounter. Before you even get started with Oracle database 11g, you may come across an error while attempting to install the Oracle software where […]

Continue Reading

ORA-38880: Cannot advance compatibility from 10.2.0.4.0 to 11.2.0.2.0 due to guaranteed restore points

The Problem I had created a guaranteed restore point in my 10g, 10.2.0.4, database with the idea that I would have a fail back plan should anything go wrong with the upgrade process to 11g. After creating the restore point, running the necessary pre-upgrade checks and changes and then starting up the DB in upgrade […]

Continue Reading

Prerequisite check “CheckActiveFilesAndExecutables” failed

Prerequisite check “CheckActiveFilesAndExecutables” failed

Oracle Database: 11.2.0.3 Platform: Windows Server 2003, Sp2 The Problem When using Opatch utility 11.2.0.1.3, and attempting to patch an Oracle 11g home, I got the following: Verifying environment and performing prerequisite checks… Prerequisite check “CheckActiveFilesAndExecutables” failed. The details are: Following files are active : D:\oracle\product\11.2.0\dbhome_1\bin\oraclient11.dll D:\oracle\product\11.2.0\dbhome_1\bin\orageneric11.dll D:\oracle\product\11.2.0\dbhome_1\bin\orapls11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oracommon11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oci.dll D:\oracle\product\11.2.0\dbhome_1\bin\orahasgen11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oraocr11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oraocrb11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oraocrutl11.dll D:\oracle\product\11.2.0\dbhome_1\bin\oran11.dll D:\oracle\product\11.2.0\dbhome_1\bin\orantcp11.dll […]

Continue Reading

ORA-38785: Media recovery must be enabled for guaranteed restore point

The Problem You want to use the Flashback Database feature and are trying to create a guaranteed restore point before you carry out any work. As you attempt to create the guarantee restore point you get the ORA-38785: Media recovery must be enabled for guaranteed restore point error message. The Cause The database is not […]

Continue Reading

ORA-16433: The database must be opened in read/write mode

ORA-16433: The database must be opened in read/write mode

You’re here because you’re getting the ORA-16433: The database must be opened in read/write mode error message. Below you will find the solution… But first, here is how I got the error. The reason I’m writing this is so that it will help you understand the ORA 16433 error message a little better as it could […]

Continue Reading