- 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
- UNIX
- $ORACLE_HOME/network/admin
- Windows
- %ORACLE_HOME%\network\admin
- $ 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:
- UNIX
- Run netca from $ORACLE_HOME/bin
- Windows
- Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Net Configuration Assistant
Configuration Steps
Here are our steps to configure a new listener named ATGOID using netca. Note that highlighted options are our selections.
- Welcome
- Choose the configuration you would like to do:
- Listener configuration
- Naming Methods configuration
- Local Net Service Name configuration
- Directory Usage Configuration
- Listener Configuration, Listener
- Select what you want to do:
- Add
- Reconfigure
- Delete
- Rename
- Listener Configuration, Listener Name
- Listener name: ATGOID
- Listener Configuration, Select Protocols
- See Figure 1
- Listener Configuration, TCP/IP Protocol
- Which TCP/IP port number should the listener use? (Default)
- Listener Configuration, IPC Protocol
- To communicate with the database using the IPC protocol, an IPC key value is required.
- IPC Key value: EXTPROC1522
- Listener Configuration, More Listeners
- Would you like to configure another listener? (No)
- Listener Configuration, Select Listener
- Select a listener you want to start: ATGOID
- Listener Configuration Done
Log location
In case there is error found during configuration, you can find more details from the log files located here:
- $ORACLE_HOME/cfgtoollogs/netca
For example, we have found two files in there:
$ORACLE_HOME/cfgtoollogs/netca
$ ls -lrt
total 60
-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
Console Ouput
If the configuration succeeded, you should find the following messages from the console:
$ ./netca
Oracle Net Services Configuration:
Configuring Listener:ATGOID
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
listener.ora
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:
ATGOID =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.oracle.com)(PORT = 1521))
)
)
ADR_BASE_ATGOID = /export/home/oracle/atg/Oracle11gR2
No comments:
Post a Comment