Re: Can't get extproc listener working - help?

On Tue, 17 Apr 2001 20:53:30 GMT, philo_at_radix.net (Philo) wrote:

>I'm trying to get intermedia configured on my Oracle 8i server, but
>can't get the external procedure mapping going. Can someone help?
>
>tnsnames.ora:
>
>LOCAL.PHILO =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = cj49297-b)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID_NAME = ORCL)
> )
> )
>
>EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)
> (KEY = ORCL))
> (CONNECT_DATA = (SID_NAME = ep_agt1)))
>
>
>listener.ora:
>
>LOCAL =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = cj49297-b)(PORT = 1521))
> )
>
>SID_LIST_LOCAL =
> (SID_LIST =
> (SID_DESC = (SID_NAME = ep_agt1)
> (ORACLE_HOME = e:\oracle)
> (ENVS = LD_LIBRARY_PATH=e:\oracle\ora81\ctx\data)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = local.philo)
> (ORACLE_HOME = E:\ORACLE)
> (SID_NAME = ORCL)
> )
> )
>
>Trying to run
>exec ctx_output.start_log('log')
>
>From SQLPlus gives me this error:
>ORA-20000: interMedia Text error:
>DRG-50704: Net8 listener is not running or cannot start external
>procedures
>
>What am I missing?
>
>TIA,
>Philo

You are missing

      (ADDRESS = (PROTOCOL = IPC)(key=extproc)) in listener.ora
and the key= in your tnsnames.ora needs to read EXTPROC too.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Apr 17 2001 - 19:02:23 CDT