Re: COM Cartridge (Program interface for NT)

"Yury Skandarov" <yskandarov_at_westcall.ru> wrote in message news:9b490a$2fbe$1_at_ws.west-call.com...
> Hi All!
> Did anybody use subj.?
> There are some docs:
> 1. %ORA-HOME%\com\readme.doc
> 2. %ORA-HOME%\com\technote.doc
> but it isn't quite clear how should I adjust listener.ora, tnsnames.ora
> because error still exists:
>
> ORA-28575: unable to open RPC connection to external procedure agent
> ORA-06512: at "WESTCALL.OACREATE", line 0
> ORA-06512: at "WESTCALL.ORDCOM", line 263
> ORA-06512: at "WESTCALL.ORDEXCEL", line 30
> ORA-06512: at line 26
>
> best wishes,
> Yury
>
> PS.
> My listener.ora:
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXCEL0))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = SID_DB.DOMAIN_NAME)
> (ORACLE_HOME = E:\ORANT)
> (SID_NAME = SID_DB)
> )
> (SID_DESC =
> (PROGRAM = D:\Program Files\Microsoft Office 2000\Office\excel.exe)
> (SID_NAME = EXCEL)
> (ORACLE_HOME = E:\ORANT)
> )
> )
>
> My tnsname.ora:
> MY_DB=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXCEL0))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = SID_DB.DOMAIN_NAME)
> )
> )
>
>

Your listener.ora is incorrect.
You don't have it setup to run external procedures at all. the sample directory below the admin directory should have a working example.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Apr 15 2001 - 07:51:26 CDT