Database – Page 4 – Ittichai Chammavanijakul

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 »

11.2.0.1 on Solaris is now available

11g, Database / Leave a Comment

Oracle Database 11g Release 2 (11.2.0.1.0) for Solaris (SPARC) (64-bit) platform is now available for download.

11gR2 New Feature – Alter Database Link to Change Password

11g, Database / 4 Comments

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 »

11gR2 New Feature – File Watchers

11g, Database / 8 Comments

The File Watcher is a scheduler object that starts a job whenever files whose attributes met the defined criteria arrived on a system. These criteria include the name, location, and other properties of a file. When the file watcher detects the arrival of the designated file, it raises a file-arrival event. The event message, which …

11gR2 New Feature – File Watchers Read More »

11gR2 New Feature – DBFS Database File System

11g, Database / 4 Comments

The DBFS (Database File System), one of the new 11gR2 features, takes advantage of the SecureFiles feature (which is new in 11gR1). The SecureFiles provide powerful file storage features (including de-duplication, compression, etc.) which removes performance barrier to storing files in the database. This stands in contrast to LOB (now called the BasicFiles). Not only …

11gR2 New Feature – DBFS Database File System Read More »

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

11g, Database, PL/SQL / 5 Comments

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 »