Author name: ittichai

Ittichai C.

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 »

Oracle Universal Installer (OUI) did not start when installing OAS 10.1.3.1 on Windows 2003

Last week we installed the OAS 10.1.3.1 on multiple Windows 2003 servers on the VM farm. All went well except the last one. When double-clicking on the setup.exe file, the system verification window popped up. Next I expected the Oracle Universal Installer (OUI) window, but nothing happened. The same installation files and procedure have been …

Oracle Universal Installer (OUI) did not start when installing OAS 10.1.3.1 on Windows 2003 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 »

Oracle Application Express (APEX) Certification Exam

Oracle is working toward having the first certification exam for Oracle APEX. This “Oracle Application Express Developer Certified Expert” pilot program is intended for intermediate and advanced APEX developers. You will have to indicate the relevant APEX trainings you’ve completed, years of APEX experiences and, of course, the agreement to provide feedback in order to …

Oracle Application Express (APEX) Certification Exam Read More »

Scroll to Top