Question: I tried to use external C
procedure from the database and I aam getting the ORA-28575 error at
run time:
28575. 00000 - "unable to open RPC connection to external procedure
agent"
How to I fox the ORA-28575 error?.
Answer: First, if the C program contains
Oracle SQL, you must use the
Pro*C
precompiler as a compile step:
First, use the
oerr utility to look-up the 28575. 00000 - "unable to
open RPC connection to external procedure agent" error:
ORA-28575: unable to open RPC
connection to external procedure agent
Cause: Initialization of a
network connection to the extproc agent did not succeed.
This
problem can be caused by network problems, incorrect listener
configuration, or incorrect transfer code.
Action: Check listener
configuration in LISTENER.ORA and TNSNAMES.ORA, or check Oracle
Names Server.
Start by ensuring that your EXTPROC is present in tnsnames.ora
and listener.ora:
Here are how to add extproc entries to tnsnames.ora and
listener.ora:
TNSNAMES.ORA EXTPROC:
Add this line in $ORACLE_HOME/network/admin/tnsnames.ora
extproc_connection_data
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=your_key))
(CONNECT_DATA=(SID=extproc)))
LISTENER.ORA EXTPROC
Add/edit this line in $ORACLE_HOME/network/admin/listener.ora
LISTENER =
(ADDRESS_LIST
(ADDRESS=(PROTOCOL=ipc)(KEY=yourkey)))
SID_LIST_LISTENER = (SID_LIST
(SID_DESC=(SID_NAME=mydb)(ORACLE_HOME=/myhome/oracle))
(SID_DESC=(SID_NAME=extproc)(ORACLE_HOME=/myhome/orac
le)
(PROGRAM=extproc)))
After verifying the EXTPROC entries, tart with these obvious
diagnostic steps for the ORA-28575 error:
1 - Ensure that your extproc entry exists in your
tnsnames.ora and listener.ora.
2 - Then check the Oracle doc "Network
Configuration Guide" for your OS platform for details on creating an
entry for extproc.
3 - If you add extproc to your listener.ora,
bounce the listener
If that does not fix your ORA-28575 error, try these
steps to troubleshoot your network connectivity:
1 - try changing your IP Address to your Host
name
2 - See if the listener is running with "lsntctl
stat"
3 - Check with "ping" using the IP address ("ping
198.11.34.43" )
4 - Check with "ping" using DNS name (e.g.
"tnsping uranus")
5 - Try telnet to the IP on port 1521 (telnet
1.2.3.4 1521)
6 - Check with "tnsping" using TNS service name (EXTPROC_CONNECTION_DATA1.world)
7 - Invoke SQL*Plus from the OS command line
"sqlplus fred@flintstone". If this fails, check to ensure that your
listener is the flintstone service defined.
8 - Sign-on to SQL*Plus and connect with the TNS
name ("connect
fred/flintstome@service_name"
9 - Within SQL*Plus, try a select from
table@remote_db_link
******************************************************
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
