Re: Can't run external procedure

From: aurum <alz72_at_rambler.ru>
Date: Fri, 10 Jan 2003 10:07:11 +0300
Message-ID: <avlrhl$1q8u$1_at_gavrilo.mtu.ru>

Hello, Karsten!
You wrote on Thu, 09 Jan 2003 17:08:26 GMT:

 KF> aurum wrote:
 >> Hello, Sybrand!
 >> You wrote on 9 Jan 2003 06:56:03 -0800:

 SB>>> "aurum" <alz72_at_rambler.ru> wrote in message
 SB>>> news:<avjm3l$2pn$1_at_gavrilo.mtu.ru>...

>>>> Hello, All!
>>>> Help me please !!!
>>>> I'm can't running external procedure from client computer.From
>>>> server -
>>>> "all richt".I'm typing in SqlPlus this:

>>>> execute EXECOSCOMMAND('dir');

>>>> But have this:
>>>> ORA-28575: unable to open RPC connection to external procedure
>>>> agent

>>>> ORA-12154: TNS:could not resolve service name

>>>> ORA-06512: at "SYSTEM.EXECOSCOMMAND", line 0

>>>> ORA-06512: at line 1

>>>> With best regards, aurum. E-mail: alz72_at_rambler.ru

 SB>>> external procedures run from the server *ONLY*

 SB>>> sorry
 SB>>> Sybrand Bakker
 SB>>> Senior Oracle DBA

 >> May be, but i can running from one client computer.Sorry !!!

 >> With best regards, aurum. E-mail: alz72_at_rambler.ru

 KF> Then that one client where you can run it must have an oracle
 KF> database  and listener on it. That is, it must be configured as both
 KF> an Oracle  client and an Oracle server. The client where you can't
 KF> run it must be  configured as an Oracle client only.

 Thanks for your answer!!!
But i have some questions:

    1.What is mean "configured as both an Oracle client and an Oracle server"?

    2.In client where i can run don't have a listener (at least     listener as started service).

Thanks in advance !!!

With best regards, aurum. E-mail: alz72_at_rambler.ru Received on Fri Jan 10 2003 - 08:07:11 CET