:

The Latest Oracle Posts

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

ORA-28002: the password will expire within 7 days

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

Continue Reading

ORA-01722: invalid number

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

Continue Reading

ORA-24247: Network Access Denied by Access Control List (ACL)

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

Continue Reading

Find Blocking Sessions in Oracle Database

In this article I would like to describe how to check for blocking sessions within the Oracle DB in 11g. I used to use the dba_blockers view in Oracle 10g but that doesn’t seem to do the trick the same way as in 11. So, there is another way to find out which sessions are […]

Continue Reading