Archive | Network

Easy Connect (EZCONNECT) Naming Method with Instance Name

Oftentimes I use the Easy Connect (EZCONNECT) to connect to a new database just to quickly verify database connectivity. The syntax I usually use is as follows: CONNECT username/password@[//]host[:port][/service_name] CONNECT scott/tiger@host1-vip:1522/RACDB In RAC, this will connect to whatever instance based on the service’s load balancing goal. I just learned that with the 11g net services […]

Continue Reading 3

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

Continue Reading 5

Powered by WordPress. Designed by WooThemes