listener, tnsnames difference for sap and nonsap databases

From: yls177 <yls177_at_hotmail.com>
Date: 21 Sep 2004 23:17:34 -0700
Message-ID: <c06e4d68.0409212217.289d8137@posting.google.com>

Hi, i noticed that there are some differences between the listener.ora and tnsnames.ora between sap and non sap databases. i have attached them as belows.

listener.ora

non-sap

testinstance =
 (DESCRIPTION =
(ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP)(HOST = SUNHOST03)(PORT = 1521))    )
(CONNECT_DATA =

     (SERVICE_NAME = testinstance)
   )
 )

sap

LISTENER =
 (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = DEV.WORLD))
(ADDRESS = (PROTOCOL = IPC)(KEY = DEV))
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST =
HPHOST03)(PORT = 1527))
 )

tnsnames.ora

non-sap

testinstance =
 (DESCRIPTION =
(ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP)(HOST = SUNHOST03)(PORT = 1521))    )
(CONNECT_DATA =

     (SERVICE_NAME = testinstance)
   )
 )

sap

DEV.WORLD=
 (DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =

       (ADDRESS =
         (COMMUNITY = SAP.WORLD)
         (PROTOCOL = TCP)
         (HOST = HPHOST03)
         (PORT = 1527)
       )

   )
(CONNECT_DATA =

      (SID = DEV)
      (GLOBAL_NAME = DEV.WORLD)

   )
 )

1. what is this service_name about?
2. from the listener status, i noted that sap databases has "has 1 service handler(s) while non-sap has more than 1. do they mean the client connections?

Received on Wed Sep 22 2004 - 01:17:34 CDT