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
vBulletin v3.0.7, Copyright ©2000-2008, Jelsoft Enterprises Ltd.