Oracle Networking-I

 

Utilites to configure Listener and Tns service.

             Netmgr: network manager   

 Netca: network configuration assistance

Location:

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

$ORACLE_HOME/network/admin

 

Contents of listener.ora

Listener (Listener name)

    (ADDRESS_LIST=

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

     )

    SID_LIST_LISTENER =

     (SID_LIST =

       (SID_DESC =

           (GLOBAL_DBNAME = prod)

           (SID_NAME = prod)

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

        )

     )

 

Tnsnames.ora

 

 SERVICE_NAME=

(DESCRIPTION=

  (ADDRESS_LIST=

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

 (CONNECT_DATA =

    (SERVICE_NAME/SID =sid)

 )

 

Listener control utility

$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>

Checking listener at os level

$ps –ef |grep tns

 

Testing oracle networking:

 $tnsping  <service_name>        Eg: $tnsping tolist