8.4.4 Configuring Easy Connect Naming on the Client

Learn about the required conditions and configuration tasks that clients need to ensure before using the Easy Connect naming method.

Clients can connect to Oracle Database using Easy Connect naming if the following conditions are met:

  • Oracle Net Services software is installed on the client.

  • Oracle TCP/IP protocol is supported on both the client and database server.

  • No features require a more advanced connect descriptor.

Easy Connect naming is not suitable for large or complex environments with advanced features, such as external procedure calls, or Heterogeneous Services, that require additional connect information. In these cases, another naming method is recommended.

Easy Connect naming is automatically configured at installation. Before using it, you must ensure that EZCONNECT is specified by the NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file. This parameter specifies the order of naming methods Oracle Net can use to resolve connect identifiers to connect descriptors.

Note:

If you use the Easy Connect naming method for TCPS connections (PROTOCOL=TCPS), then SSL_SERVER_DN_MATCH is set to TRUE by default. With the SSL_SERVER_DN_MATCH=TRUE setting, the client performs a partial DN matching to ensure that the server and listener certificates are valid.

If you want to check with the full DN (not partial DN), then you must also specify the DN in SSL_SERVER_CERT_DN. If you do not set SSL_SERVER_CERT_DN, then a partial DN match must succeed for the client to establish a connection to the server. If you set SSL_SERVER_CERT_DN, then a full DN match (with certificates for both the server and listener) must succeed for the client to establish a connection to the server.

The following procedure describes how to verify that the Easy Connect naming method is configured:

  1. Start Oracle Net Manager.

  2. In the navigator pane, expand Local, and then select Profile.

  3. From the list in the right pane, select Naming.

  4. Click the Methods tab.

    Verify that EZCONNECT is listed in the Selected Methods list. If it is not, then proceed to Step 5. If it is listed, then proceed to Step 7.

  5. From the Available Methods list, select EZCONNECT, and then click the right-arrow button.

  6. In the Selected Methods list, select EZCONNECT, and then use the Promote button to move the selection to the top of the list.

  7. Select Save Network Configuration from the File menu.

    The sqlnet.ora file updates the NAMES.DIRECTORY_PATH parameter, listing hostname first: 

    NAMES.DIRECTORY_PATH=(ezconnect, tnsnames)

Related Topics

Parent topic: Configuring the Easy Connect Naming Method