Make sure your Oracle 10g Net software (or higher) is installed on the client
Oracle TCP/IP protocol support is available on both the client and database server
EZConnect is enabled for Oracle name resolution. It is usually configured at installation, but prior to using it, you may want to use Oracle Net Manager to check that EZConnect is included as one methods used to resolve connect identifiers to connect descriptors.
The EZConnection identifier can be used wherever you can use a full connection identifier, or a net service name. The exact syntax depends upon the Oracle Net communications protocol your Oracle installation uses.
For more information, refer to the Oracle Net manual appropriate for your protocol or contact your DBA.
If you are connecting to a remote Oracle database, enter the Oracle Net connect identifier in the Host String field. To connect to the default database, leave the Host String field blank.
With an Oracle Wallet defined we can just call: sqlplus /@hostname/servicename
For example: sqlplus /@oraprod1/PAOLOXDB.megacorp.com
Examples of using the Listener with Acquire for UNIX/Linux
An Oracle DBA should be engaged to set up connectivity and to make sure any security and operational requirements are met.
This example assumes that you are trying to connect to an Oracle database with the following connection details:
Database Name = PAOLO
SID = PAOLO
EZConnect string= oraprod1/PAOLOXDB.megacorp.com
Oracle user = Precisely
Oracle password = TopSecret!