Oracle Networking-I Netca (Listener and Tns-service)

Netca: network configuration assistance

             Utility to configure Listener and Tns service.

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=

         (SID_NAME=sid)

     )

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