Configuring Oracle Net Services

You can configure Oracle Database Client to communicate with Oracle Net Services by adding the appropriate entries to the tnsnames.ora and listener.ora files.

If you have a previous release or Oracle software, you can just copy information in the Oracle Net tnsnames.ora and listener.ora configuration files from the previous release to the corresponding files in the new release.

Note:

The default location for the tnsnames.ora and listener.ora files is the ORACLE_HOME\network\admin directory.

To create Oracle Connection Manager (CMAN) services, create a CMAN alias entry in cman.ora under ORACLE_HOME\network\admin. For example:

cman_proxy=

(CONFIGURATION=

(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

(RULE_LIST=

(RULE=(SRC=*)(DST=*)(SRV=*)(ACT=accept)))

(PARAMETER_LIST=

(MIN_GATEWAY_PROCESSSES=1)

(MAX_GATEWAY_PROCESSES=2)))

This accepts connection from all clients as mentioned in the rule.

CMAN services are created when CMAN is started for the first time using cmctl command-line tool. When creating services, cmctl prompts for a password if Windows User Account is specified as Oracle Home User during installation. If Windows Built-in Account is specified as Oracle Home User during installation, then cmctl does not prompt for password.

Listener can be configured by adding an alias entry in listener.ora. Listener service is created when the listener is started for the first time. The listener control utility, lsnrctl prompts for a password if Windows User Account is specified as Oracle Home User during installation. If Windows Built-in Account is specified as Oracle Home User during installation, then it does not prompt for password.