The Latest Oracle Posts
Error from SQLPLUS 255
The Problem When running a job from the Oracle Enterprise Manager Grid Control, I kept getting the error message: Error from SQLPLUS: 255 The target was valid and up, along with the agent and everything looked OK. Jobs were also working fine for other targets on the same host, using the same Oracle management agent. […]
ALTER INDEX MONITORING USAGE
In order to maintain an efficient database, it can be very useful to prune indexes from time to time as the system usage changes. An index that may have been used very often when the schema was first designed, may not be used after a new code release for example. It’s also common when implementing […]
NID-00135 – New DB ID Error
NID-00135: There are 1 active threads Generic: NID-00135: There are x active threads The Cause The database crashed the last time it was shut down. The Solution Ensure that all threads are closed before retrying the operation. Start and open the database to perform crash recovery, then shut down with the NORMAL or IMMEDIATE options […]
ORA-15554: cannot start workload replay client because the database server is not in PREPARE mode
The Problem I was trying to start a replay client so that I was able to then start the DB replay, but when running the command below I received an error. D:\Oracle\Product\11.2.0\dbhome_1\BIN>wrc wrc/wrc@test MODE=replay REPLAYDIR=U:\flash_recover_TEST\TEST\WRC Workload Replay Client: Release 11.2.0.2.0 – Production on Thu Feb 17 09:16:04 2011 Copyright (c) 1982, 2009, Oracle and/or its […]
ORA-20223: Invalid input. Database has not been INITIALIZED for REPLAY
The Problem As part of the set-up work you have to do before replaying a captured workload into the DB using Real Application Testing, you have to run various commands. This is one of them, but I was receiving errors: SQL> BEGIN 2 DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY ( 3 synchronization => ‘SCN’, 4 connect_time_scale => 100, 5 think_time_scale […]
ORA-06508: PL\SQL:could not find the program unit being called
I was installing the Java and the NCOMP libraries into the Oracle software home and into the DB, version 10.2.0.4. and I got the following error: ORA-04065: not executed, altered or dropped stored procedure “PUBLIC.DBMS_OUTPUT” ORA-06508: PL\SQL:could not find the program unit being called: “PUBLIC.DBMS_OUTPUT” In order to resolve this issue I ran the following: […]
ORA-00600 internal error code, arguments: [1403]
I’m running an Oracle database version 9.2.0.8 and we have Data Guard configured which replicates our production DB to a physical standby. Then, when we want to refresh a development database we clone, at the SAN level, from the physical standby to one of our DEV environments. That’s what we did and I was re-configuring the database to start […]
ORA-31538 Change Set Disabled
The Problem Using CDC on Oracle version 11.2.0.1 and running with Asynchronous Autolog mode for the capture at a separate downstream database. I was trying to activate a previously created subscription when I received the following: — When activating a subscription begin dbms_cdc_subscribe.activate_subscription( subscription_name => ‘Acturis_Subscrpt’); end; / ERROR at line 1: ORA-31538: change set […]
Error 604 received logging on to the standby
When setting up the environment for Change Data Capture (CDC), which uses streams and, in our case, archive redo log shipping, I noticed that it wouldn’t work straight away and there were some errors in the alert log of the primary database: Wed Apr 07 09:37:59 Error 604 received logging on to the standby I […]