11g

Oracle 11g Network Access Denied by Access Control List (ACL) when using UTL_INADDR

I wrote in my previous post about the Access Control Lists to Network Services (e.g., UTL_HTTP, UTL_SMTP, UTL_TCP, etc.) in Oracle 11g. However, it did not cover another PL/SQL network utility package named UTL_INADDR which retrieves host names and IP addresses of local and remote hosts. You can read some usage samples of the UTL_INADDR …

Oracle 11g Network Access Denied by Access Control List (ACL) when using UTL_INADDR Read More »

11gR2 New Feature – Alter Database Link to Change Password

Our organization requires a regular password change on some database accounts for security compliance. If this account is used in the database link in other database, that database link has to be dropped and recreated with an updated password. This changes in 11gR2 because it now offers the alter database link to change password. No …

11gR2 New Feature – Alter Database Link to Change Password Read More »

The Access Control Lists to Network Services (e.g., UTL_HTTP, UTL_SMTP, UTL_TCP, etc.) in Oracle 11g

This is one of the 11g features I read it once when it was first released but did not see its significance until now. Last week we just migrated an application from 9i to 11g. During a test of the send mail package using UTL_SMTP, we got this error, “ORA-24247: network access denied by access …

The Access Control Lists to Network Services (e.g., UTL_HTTP, UTL_SMTP, UTL_TCP, etc.) in Oracle 11g Read More »

11g OCP upgrade exam

I just passed the 11g OCP upgrade after many excuses to postpone it. I have to admit I was nervous a little bit because the last Oracle exam I’ve taken was more than one year ago. I was struggling a little bit at first. I tend to read too quickly (= careless). So at the …

11g OCP upgrade exam Read More »

Scroll to Top