Ora-28544 Connect to Agent Failed

 ORA-28544 connect to agent failed, probable Net8 administration error

    Oracle Database Error Code Messages ORA-28544 Help About Description;

Connect to agent failed, probable Net8 administration error.

    Cause for Error and Problem;

Net8 reported a failure to make a RSLV connection or a protocol mode error when the Oracle database 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.

    How to Solve;ORA-28544 connect to agent failed, probable Net8 administration error?

    Action for Solve and Fix Ora-28544;

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=).

Next Post Ora-00914;

Ora-00914 Missing ADD Keyword