Extproc listener configuration

I'm trying to set up a database so that external procedures can be used.

The following is straight out of the Oracle Documentation.

For environments where the configuration files have been overwritten, edit the LISTENER.ORA and TNSNAMES.ORA files as follows:

   1.Add a system identifier (SID) name and a program name for EXTPROC in the server's LISTENER.ORA file (entries are

     shown in boldface text):

      LISTENER =
             (ADDRESS_LIST =


                     (ADDRESS =


                     (PROTOCOL = IPC)


                     (KEY = INVENTORY)


                  )


                     (ADDRESS =


                     (PROTOCOL = IPC)


                     (KEY = ORCL)


                 )


                     (ADDRESS =


                     (PROTOCOL = IPC)


                     (KEY = extproc)


                       )


                     (ADDRESS =


                     (PROTOCOL = TCP)


                     (Host = INVENTORY)


                     (PORT = 1521)


                 )
             )
     STARTUP_WAIT_TIME_LISTENER = 0
     CONNECT_TIMEOUT_LISTENER = 10
     TRACE_LEVEL_LISTENER = ADMIN
     SID_LIST_LISTENER =
             (SID_LIST =
                (SID_DESC =
                    (SID_NAME = ORCL)
                )
               (SID_DESC =
                    (SID_NAME = extproc)
                            (PROGRAM = extproc)
                   )
             )

   2.Add a service name entry for EXTPROC in the server's TNSNAMES.ORA file (entries are shown in boldface text):

     INVENTORYDB.WORLD =
                          (DESCRIPTION =
                                            (ADDRESS =
                                            (PROTOCOL = TCP)
                                            (Host = INVENTORY)
                                            (PORT = 1521)
                                           )
                                            (CONNECT_DATA = (SID =
ORCL)) )
     extproc_connection_data.world =
                   (DESCRIPTION =
                   (ADDRESS =
                   (PROTOCOL = IPC)
                   (KEY = ORCL)
            )
     (CONNECT_DATA = (SID=extproc))
        )

Please note that the value for KEY must match the KEY value specified in the LISTENER.ORA file. In order to support a multiple Oracle home environment, the Oracle Installer automatically creates unique keys for the external procedures in different Oracle homes.

Correct me if I'm wrong but it says that the value for KEY in tnsnames.ora must match
the value for KEY in listener.ora. In their example, the KEY in tnsnames.ora is
ORCL, and in listener.ora it's extproc, no? Do they really mean the SID? Or is
this just a bad example on how to do it? (are these things case sensitive by the way).

• Thanks,

Dc. Received on Mon Jul 19 1999 - 14:14:33 CDT