extproc again

From: Björn-Åke Segrell <pinne_at_pegit.se>
Date: Sat, 05 Feb 2000 16:33:32 +0000
Message-ID: <389C50DB.7450809B@pegit.se>

Oracle 8.0.5 on RH Linux 5.2 w Kernel 2.2.13

I don't know if I am a total idiot or what. But I'm just unable to get the extproc demo to work when it comes to configuring the listener.
I'm also sorry for this big posting, but it just drives me nuts. These are the instructions:
######################################################->

    1.Edit the tnsnames.ora file by adding an entry that enables you to connect to the listener process (and subsequently, the

      EXTPROC process).
    2.Edit the listener.ora file by adding an entry for the "external procedure listener."

    3.Start a separate listener process to exclusively handle external procedures.

    4.The EXTPROC process spawned by the listener inherits the operating system privileges of the listener, so Oracle strongly

      recommends that you make sure that the privileges for the separate listener process are restrictive. The process should not

      have permission to read or write to database files, or the Oracle server address space.

      Also, the owner of this separate listener process should not be "oracle" (which is the default owner of the server executable

      and database files).

    5.If not already installed, place the extproc executable in $ORACLE_HOME/bin.
#######################################################<-

Here point 3 puzzles me: is starting a separate listener process something i will have to do manually from the command line ?

Here is my config, the original one created at installation, (from the little i can read out from it, it seems like it should allready be setup for external procedures):
#######################################################->

#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#

extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = PEG1))     (CONNECT_DATA = (SID = extproc))
  )

PEG1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= seasiren.pegit.se)(Port= 1521))     (CONNECT_DATA = (SID = PEG1))
  )

PEG1_BEQ =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /u01/app/oracle/product/8.0.5)

               (argv0 = oraclePEG1)
               (args = '(DESCRIPTION =
(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
               (envs =

'ORACLE_HOME=/u01/app/oracle/product/8.0.5,ORACLE_SID=PEG1')

    )
  )

#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= PEG1))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= seasiren.pegit.se)(Port= 1521))

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= seasiren.pegit.se.)
      (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
      (SID_NAME = PEG1)

    )
    (SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /u01/app/oracle/product/8.0.5)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
#######################################################<-

Do I really need to add this ??? It seems to me like it is allready done:

#######################################################->
Sample Entry in tnsnames.ora

The following is a sample entry for the external procedure listener in tnsnames.ora.

extproc_connection_data = (DESCRIPTION =

                              (ADDRESS = (PROTOCOL=IPC)
                                         (KEY=extproc_key)
                               )
                             (CONNECT_DATA = (SID = extproc_agent)
                           )

Sample Entry in listener.ora

The following is a sample entry for the external procedure in listener.ora.

EXTERNAL_PROCEDURE_LISTENER = (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL=ipc)

               (KEY=extproc_key)
     )

)
...
SID_LIST_EXTERNAL_PROCEDURE_LISTENER = (SID_LIST =

     (SID_DESC = (SID_NAME=extproc_agent)
                 (ORACLE_HOME=/oracle)
                 (PROGRAM=extproc)
      )

)
#######################################################<-

When i start the listener it completes successfully and says that: "PEG1 has 1 service handler
extproc has 1 service handler"

Shouldn't it all be ok then, or do i need yet another extproc handler ???

tnspings on PEG1, seasiren.pegit.se and localhost are all successfull. Yet when i try to run the extproc.sql i get this: "ORA-28575: Unable to open RPC connection to external procedure agent"

If someone could help me out here I'd be etremely grateful

/Björn Received on Sat Feb 05 2000 - 10:33:32 CST