ORA-28547: connection to server failed, probable Oracle Net admin error

I got ” ORA-28547: connection to server failed, probable Oracle Net admin error ” error in Oracle database.

 

ORA-28547: connection to server failed, probable Oracle Net admin error

 

Details of error are as follows.

ORA-28547: connection to server failed, probable Oracle Net admin error
Cause: A failure occurred during initialization of a network connection from a client process 
to the Oracle server: The connection was completed but a disconnect occurred while trying to
 perform protocol-specific initialization, usually due to use of different network protocols 
by opposite sides of the connection.

This usually is caused by incorrect Oracle Net administrative setup for database links or 
external procedure calls. The most frequent specific causes are:

-- The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server.

-- The connection uses a connect string which includes an (HS=) specification.

**********************************

Action: Check Oracle Net administration in the following ways:

-- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to
 the ORACLE server uses the correct service name or SID.

-- Check LISTENER.ORA on the connection end point"s host machine to assure that this service
 name or SID refers to the correct server.

-- Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does
 NOT contain (HS=).

 

 

connection to server failed, probable Oracle Net admin error

This ORA-28547 errors are related with the failure occurred during initialization of a network connection from a client process to the Oracle server: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection.

This usually is caused by incorrect Oracle Net administrative setup for database links or external procedure calls. The most frequent specific causes are:

— The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server.

— The connection uses a connect string which includes an (HS=) specification.

 

When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to
the ORACLE server uses the correct service name or SID.

— Check LISTENER.ORA on the connection end point”s host machine to assure that this service
name or SID refers to the correct server.

— Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does
NOT contain (HS=).

 

To solve this error, you shoul add SQL_AUTHENTICATION_SERVICES = (NONE) to your sqlnet.ora file, then restart your listener.

 

Or second case’s solution is as follows.

To resolve this issue, make sure that if a static SID_LIST section is required, then it only contains the SID_NAME value and (if the instance is not in the same Home) the ORACLE_HOME value.
So edit the listener.ora file and remove any other values (unless directed by Oracle Support, such as inclusion of ENVS values specific to your instance).

In the above example, the corrected entry will be as follows:

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL1)
      (ORACLE_HOME = E:\app\oracle\product\11.2.0\dbhome_1)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\app\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

Restart the Listener using “lsnrctl stop LISTENER1” and “lsnrctl start LISTENER1” (or via the Windows Services if on Windows).

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )