:

RSS11g

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

Invalid SYS Objects after 10g to 11g Upgrade

The Problem When upgrading from 10.2.0.4 to 11.2.0.1, and applying the latest patchset, which was patchset 8 at the time of writing this, I found there to be several invalid objects in the SYS schema. I raised an SR with Oracle support who informed me that I could drop these objects because they were no […]

Continue Reading

Duplicate SYS Objects after 11g Upgrade

Duplicate SYS Objects after 11g Upgrade The Problem After an 11g upgrade you see the following presented to you: =================================================== Number of Duplicate Objects Owned by SYS and SYSTEM =================================================== Counting duplicate objects …. COUNT(1) ———- 4 ========================================= Duplicate Objects Owned by SYS and SYSTEM ========================================= Querying duplicate objects …. OBJECT_NAME                      OBJECT_TYPE ——————————-  ——————- AQ$_SCHEDULES                   […]

Continue Reading

11g High Version Count – Bind Mismatch

The Problem While running Oracle version 11.2.0.1 I noticed that there were a high number of SQL statements which had a high version count. The CURSOR_SHARING parameter was set to FORCE. When looking in V$SQL_SHARED_CURSOR you will see a Y in the column BIND_LENGTH_UPGRADEABLE. The Cause The reason for this happening is described in detail in […]

Continue Reading