Home » RDBMS Server » Server Administration » ORA-28575
ORA-28575 [message #53836] Mon, 14 October 2002 10:56 Go to next message
Richard Ali
Messages: 1
Registered: October 2002
Junior Member
Hi,
I have the oracle database on a windows 2000 machine. we applied the windows service pack and the server start failing to connect the RPC onnections. Before upgrading it used to work fine. but as soon as we upgraded the machine and restarted, it started giving the (in)famous error "ORA-28575: unable to open RPC connection to external procedure agent" when i try to run a remote procedure thru an sql statement. I checked the listener.ora and tnsname.ora files. I restarted the listener service. could not figure out whats wrong.
Does anyone know what I should do now?
Thanks.
Re: ORA-28575 [message #54352 is a reply to message #53836] Tue, 12 November 2002 11:47 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Couple of things to check for this error:

1. Does the sqlnet.ora file contain the NAMES.DEFAULT_DOMAIN = parameter. If it does, either remove the entry or comment it out with a # sign in the first column.

2. Ensure that the MTS parameter is utilizing IPC in your INITsid.ORA file if MTS is used on the database.

If problem persists, please enable tracing to view the expected net service name.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: db trigger and dblink
Next Topic: STS Oracle 8i and 9i
Goto Forum:
  


Current Time: Thu Sep 19 19:37:15 CDT 2024