Listener/Tnsnames Configuration

                                                                    
                                                                   
                                                                   
                                           

Listener configuration

------------------------------------

# listener.ora Network Configuration File: /orahome/oracle/product/10.2.0/networ
k/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_UNIXPI =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = demspi01)(PORT = 1524))
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
   )
 )

SID_LIST_LISTENER_UNIXPI =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /orahome/oracle/product/10.2.0)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SID_NAME = unixpi)
     (GLOBAL_DB = unixpi.cbec.gov.in)
     (ORACLE_HOME = /orahome/oracle/product/10.2.0)
     (SERVICE_NAME = unixpi.cbec.gov.in)
   )
 )

----------------------------------------------------------------------------------------------------------------



tnsnames Configuration

-----------------------------------------------------------

# tnsnames.ora Network Configuration File: /orahome/oracle/product/10.2.0/networ
k/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
   )
   (CONNECT_DATA =
     (SID = PLSExtProc)
     (PRESENTATION = RO)
   )
  )

UNIXPI =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.8.181)(PORT = 1524))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = unixpi)
   )

-----------------------------------------------------------------------------------------

End of Doc