- Listener names and protocol addresses
- Naming methods the client will use to resolve connect identifiers to connect descriptors
- Net service names in a tnsnames.ora file
- Directory server usage
In this article, we will show you how to configure a new listener named ATGOID using netca.
Running Net Configuration Assistant
Configuration files are typically created in
- $ export TNS_ADMIN=/export/home/oracle/atg/Oracle11gR2/product/11.2.0/dbhome_1/network/admin
- $export ORACLE_HOME=/export/home/oracle/atg/Oracle11gR2/product/11.2.0/dbhome_1
Log on to your computer as a member of the administrative group that is authorized to install Oracle software and create and run the database. To start Oracle Net Configuration Assistant:
- Run netca from $ORACLE_HOME/bin
- Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Net Configuration Assistant
Here are our steps to configure a new listener named ATGOID using netca. Note that highlighted options are our selections.
- Choose the configuration you would like to do:
- Listener configuration
- Naming Methods configuration
- Local Net Service Name configuration
- Directory Usage Configuration
- Select what you want to do:
- Listener name: ATGOID
- See Figure 1
- Which TCP/IP port number should the listener use? (Default)
- To communicate with the database using the IPC protocol, an IPC key value is required.
- IPC Key value: EXTPROC1522
- Would you like to configure another listener? (No)
- Select a listener you want to start: ATGOID
In case there is error found during configuration, you can find more details from the log files located here:
For example, we have found two files in there:
$ ls -lrt
-rw-r--r-- 1 oracle oinstall 52023 Jan 14 16:49 trace-13011512AM2431.log
-rw-r--r-- 1 oracle oinstall 371 Jan 14 16:49 netca-13011512AM2431.log
If the configuration succeeded, you should find the following messages from the console:
Oracle Net Services Configuration:
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/export/home/oracle/atg/Oracle11gR2/product/11.2.0/dbhome_1/bin/lsnrctl start ATGOID
Listener Control complete.
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0
After the configuration, configuration file listener.ora located in $TNS_ADMIN folder will be updated. This configuration file for the listener may include:
- Protocol addresses it is accepting connection requests on
- Database and nondatabase services it is listening for
- Control parameters used by the listener
In our case, two entries were added in listener.ora:
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.oracle.com)(PORT = 1521))
ADR_BASE_ATGOID = /export/home/oracle/atg/Oracle11gR2