ORA-28547

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.

Solution:- 

I had got the solution by commenting following line from listerner file of the DB.
(PROGRAM = extproc) . like below

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
#(PROGRAM = extproc)
(SID_NAME = orcl)
(ORACLE_HOME = /u01\app\Administrator\product\11.2.0\dbhome_1)
)
)

and I had to make change also to  \u01\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora file like below.


#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

and then reload the listener like

cmd > lsnrctl
lsnrctl> reload