 | |
Re: Can't run external procedure
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Can't run external procedure -
01-09-2003
, 08:56 AM
|
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
#2
| |||
| |||
|
|
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
#3
| |||
| |||
|
|
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 |
client and an Oracle server. The client where you can't run it must be
configured as an Oracle client only.
#4
| ||||
| ||||
|
|
Hello, Sybrand! You wrote on 9 Jan 2003 06:56:03 -0800: |
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.