Thursday, March 21, 2013

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

Yesterday one of our developer facing following error when she was connecting with SQLPLUS to newly setup database(11.2.0.1) on windows.
and also her forms developer 6i was crashing without any error.

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

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 = G:\oracle11gR2\app\Administrator\product\11.2.0\dbhome_1)
)
)

and I had to make change also to G:\oracle11gR2\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

Cheers.....