A domain can be specified that indicates the domain from which the client most often requests names. When the domain is set, it is automatically appended to the net service name in a connect string. For example, if INVENTORYDB is the net service name configured in TNSNAMES.ORA and NAMES.DEFAULT_DOMAIN=COM is set, the connect string SCOTT/TIGER@INVENTORYDB gets searched in the TNSNAMES.ORA as INVENTORYDB.COM. If the connect string includes the DOMAIN extension, (such as SCOTT/TIGER@INVENTORYDB.COM), the domain is not appended.

To specify a domain:

1. Click the Profile icon.

2. Choose Naming from the drop-down list box.

3. Click the Oracle Names tab.

4. Enter the domain in the Default Domain field.

5. Choose Save Network Configuration from the File menu to save changes to SQLNET.ORA in $ORACLE_HOME/network/admin on UNIX or ORACLE_HOME\network\admin on Windows platforms, or choose Save As from the File menu to save under a different file name or path.