Question: I am getting the ORA-28544
error with a database link to MS access:
ORA-28544: connect to agent
failed, probable Net8 administration error
What is the solution fix for the ORA-28544 error?
Answer: The oerr utility shows this
for the ORA-28544 error:
ORA-28544: connect
to agent failed, probable Net8 administration error
Cause: Net8 reported a failure to make a
RSLV connection or a protocol mode error when the Oracle
server attempted to establish communication with a
Heterogeneous Services agent or an external procedure agent.
This usually is due to an administration error in setting up
Net8 service definitions in TNSNAMES.ORA or LISTENER.ORA: A
basic network connection is opened, but it connects to a
program which does not use the appropriate protocol. This
often is a sign that the connection goes to the wrong
program.
Action: Check Net8
administration in the following ways:
-- When using
TNSNAMES.ORA or an Oracle Names server, make sure that the
connection from the ORACLE server uses the correct service
name or SID.
-- Check LISTENER.ORA on the agent's
host machine to assure that the service name or SID refers
to the correct agent executable in its (PROGRAM=...) clause.
-- Confirm in TNSNAMES.ORA or the equivalent
service definition that service 'extproc_connection_data'
does NOT contain (HS=), or that the service definition used
by a Heterogeneous Services database link DOES contain
(HS=).
|
|
|
|
|
Oracle Training from Don Burleson
The best on site
"Oracle
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
|
|
|
|
| |
|
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 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
