Scripts
DBMS_CAPTURE_ADM.BUILD Hangs
Having recently set-up Change Data Capture (CDC) on a development environment which in use, I was running a command to build a copy of the data dictionary into the redo log, as below: set serveroutput on variable f_scn number; begin :f_scn := 0; dbms_capture_adm.build(:f_scn); dbms_output.put_line(‘The first_scn value is ‘ || :f_scn); end; / Looking at […]
DBMS_APPLY_ADM – ORA-26663
There are lots of times when you are new to a technology that you want to wipe the slate clean and start a 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 message. […]
GLOBAL_NAMES – Change Data Capture
Recently, I configured Asynchronous Change Data Capture (CDC) on two Oracle 10G databases. I used the more manual approach to the creation of the processes within the CDC options, and didn’t require a database link between the source and destination databases. While configuring the two databases, and more specifically the initialization parameters which were required to be […]
Streams Apply Parameter – commit_serialization
Overview When using Change Data Capture (CDC) technology, which is based on streams, there are several ways to configure it. I am using the Asynchronous Autolog Archive option which uses archived redo log file shipping and then mines the log for the changes which we require at the downstream capture DB. We noticed that it […]
“WAITING FOR BUFFER QUEUE TO SHRINK”
The Problem I am running Oracle database 11.2.0.2, patchset 10 on a Windows Server 2003 platform. I have set-up and configured Oracle’s Change Data Capture (CDC), and I am running an asynchronous downstream capture process. One of the developers complained that the capture data change didn’t appear to be running correctly because it was not capturing any […]
ORA-20105: unable to move AWR data to SYS
Oracle Version: 10.2.0.4 & 11.2.0.2 Platform: Windows Server 2003 R2 The Problem I had exported some AWR snapshots from my production DB using the $ORACLE_HOME\RDBMS\ADMIN\awrextr.sql script. This generates a dump file which can then be imported into another DB and the AWR snapshots used for comparison. I copied the dump file across to my DEV […]

ORA-28002: the password will expire within 7 days
The Problem I was working on a project to upgrade our databases from 10g to 11g so we rolled it to one of our TEST environments in order to identify any problems. After some time using it, we came across an ORA-28002 error message. The following error is the full error shown to the user: […]
ORA-28001: the password has expired
The Problem A user called me today and said that they were getting the ORA-28001 error message when logging onto one of the development databases. For those unfamiliar with the ORA-28001 error message, the full error is ORA-28001: the password has expired and it happens, you guessed it, when your password has expired! The Cause […]

ORA-01722: invalid number
There are quite a few reasons why you might be hitting the ORA-01722 error message. First of all I’d like to go through the standard ways and then show you an error that I came across while upgrading my database from 10g to 11g. The issue primarily occurs when you are attempting to convert a […]

ORA-24247: Network Access Denied by Access Control List (ACL)
The Problem After upgrading one of our Oracle databases from 10g to 11g, and executing a package to test sending out email, I received the following error message: BEGIN Mis_Pkg.prcTestEmail; END; * ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at “SYS.UTL_TCP”, line 17 ORA-06512: at “SYS.UTL_TCP”, line 246 ORA-06512: at “SYS.UTL_SMTP”, […]