:

The Latest Oracle Posts

ORA-12519 TNS no appropriate service handler found

Oracle Version: 11.2.0.2, Patchset 10 Platform: Windows Server 2003 R2 The Problem We were receiving the following error message when a developer was attempting to run a query across a DB link on a DEV environment. The DB server had just been restarted the night before. I checked and I could not connect using SQLPlus. ORA-12519: […]

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading