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