Saturday, 6 January 2018

F. Listener Configuration

Steps to be Executed:-

1. Set the environment and put "netca" command to open Network Configuration Assistant and click
Listener Configuration".

[oracle@oracle11gr2 ~]$ which netca
/u01/app/oracle/product/11.2.0.4/db_1/bin/netca
[oracle@oracle11gr2 ~]$ netca
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
    Running Listener Control:
      /u01/app/oracle/product/11.2.0.4/db_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0
[oracle@oracle11gr2 ~]$


2. Click "Add" to create a listener.


3. Put the listener name.


4. Choose the protocols for listener.


5. Choose the port no in which listener will run. (Default port is 1521)


6. Clock No and proceed with next as we are not configuring any other listener.


7. Click Next and Finish to start the listener.


8. Check the Listener.ora file for confirmation.

[oracle@oracle11gr2 ~]$ cat /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11gr2.oracle.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@oracle11gr2 ~]$
[oracle@oracle11gr2 ~]$ ps -ef|grep tns
root        15     2  0 14:49 ?        00:00:00 [netns]
oracle   10361     1  0 15:47 ?        00:00:00 /u01/app/oracle/product/11.2.0.4/db_1/bin/tnslsnr LISTENER -inherit
oracle   10375 10191  0 15:49 pts/1    00:00:00 grep tns

[oracle@oracle11gr2 ~]$



G. Net Service Name Configuration

No comments:

Post a Comment