Oracle Networking

How to Configure Listener ?

There are Utilites to configure Listener and Tns service.

$ Netmgr: network manager   

$ Netca   : network configuration assistance

These files resides in..

Default location of listener.ora and tnsnames.ora is :

$ORACLE_HOME/network/admin

Contents of listener.ora are…

Listener (Listener name)

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=tcp) (HOST=192.168.0.101) (PORT=1524))

     )

    SID_LIST_LISTENER =

     (SID_LIST =

       (SID_DESC =

           (GLOBAL_DBNAME = prod1)

           (SID_NAME = prod1)

           (ORACLE_HOME=/u01/home/app/product/11.2.0/dbhome_1)

        )

     )

Contents of Tnsnames.ora are…

 SERVICE_NAME=

(DESCRIPTION=

  (ADDRESS_LIST=

    (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.101)(PORT=1524))

 (CONNECT_DATA =

    (SERVICE_NAME/SID =sid)

 )

How to Control Listener control (Utility used) ?

$lsnrctl

$lsnrctl   <option> listener_name

            -reload   -   to reload the settings of listener file

            -status    -    to see status of listener

            - start     -    to start the listener

            - stop     -     to stop the listener

            -services – db/instances currently serve by

 

$lsnrctl>

How to Check listener at os level ?

$ps –ef |grep tns

Testing oracle networking:

 $tnsping  <service_name>       

Eg: $tnsping tolist