PDA

View Full Version : Can't run external procedure


Sybrand Bakker
01-09-2003, 06:56 AM
"aurum" <alz72@rambler.ru> wrote in message news:<avjm3l$2pn$1@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@rambler.ru


external procedures run from the server *ONLY*

sorry
Sybrand Bakker
Senior Oracle DBA

aurum
01-09-2003, 07:05 AM
Hello, Sybrand!
You wrote on 9 Jan 2003 06:56:03 -0800:

SB> "aurum" <alz72@rambler.ru> wrote in message
SB> news:<avjm3l$2pn$1@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@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@rambler.ru

Karsten Farrell
01-09-2003, 09:08 AM
aurum wrote: Hello, Sybrand! You wrote on 9 Jan 2003 06:56:03 -0800: SB> "aurum" <alz72@rambler.ru> wrote in message SB> news:<avjm3l$2pn$1@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@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@rambler.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.

aurum
01-09-2003, 11:07 PM
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@rambler.ru> wrote in message
SB>>> news:<avjm3l$2pn$1@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@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@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@rambler.ru


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service