dbTalk Databases Forums  

Re: Can't run external procedure

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Re: Can't run external procedure in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sybrand Bakker
 
Posts: n/a

Default Re: Can't run external procedure - 01-09-2003 , 08:56 AM






"aurum" <alz72 (AT) rambler (DOT) ru> wrote

Quote:
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 (DOT) ru

external procedures run from the server *ONLY*

sorry
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #2  
Old   
aurum
 
Posts: n/a

Default Re: Can't run external procedure - 01-09-2003 , 09:05 AM






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

SB> "aurum" <alz72 (AT) rambler (DOT) ru> wrote in message
SB> news:<avjm3l$2pn$1 (AT) gavrilo (DOT) mtu.ru>...
Quote:
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


Quote:
With best regards, aurum. E-mail: alz72 (AT) rambler (DOT) 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 (DOT) ru




Reply With Quote
  #3  
Old   
Karsten Farrell
 
Posts: n/a

Default Re: Can't run external procedure - 01-09-2003 , 11:08 AM



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

SB> "aurum" <alz72 (AT) rambler (DOT) ru> wrote in message
SB> news:<avjm3l$2pn$1 (AT) gavrilo (DOT) 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 (DOT) 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 (DOT) ru


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



Reply With Quote
  #4  
Old   
aurum
 
Posts: n/a

Default Re: Can't run external procedure - 01-10-2003 , 01:07 AM



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

KF> aurum wrote:
Quote:
Hello, Sybrand!
You wrote on 9 Jan 2003 06:56:03 -0800:
SB>>> "aurum" <alz72 (AT) rambler (DOT) ru> wrote in message
SB>>> news:<avjm3l$2pn$1 (AT) gavrilo (DOT) mtu.ru>...
Quote:
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


Quote:
With best regards, aurum. E-mail: alz72 (AT) rambler (DOT) ru

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

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

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

With best regards, aurum. E-mail: alz72 (AT) rambler (DOT) 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 (DOT) ru




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.