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.....
11 comments:
Excellent!! Your solution worked for me..Cheers
darThanks a lot!
You made my day :)
Cheers,
Brit
Thank you! It worked for me
Cheers,
Quangnn@etc.vn
thanks!!! this worked
Thank you So much
listener11gr2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ftdcsssdb038.ftdc.cummins.com)(PORT = 1526))
(ADDRESS = (PROTOCOL = TCP)(HOST = ftdcsssdb038.ftdc.cummins.com)(PORT = 1527))
(ADDRESS = (PROTOCOL = TCP)(HOST = ftdcsssdb038.ftdc.cummins.com)(PORT = 1528))
(ADDRESS = (PROTOCOL = TCP)(HOST = ftdcsssdb038.ftdc.cummins.com)(PORT = 1529))
)
)
)
SID_LIST_listener11gr2 =
(SID_LIST =
(SID_DESC = (SID_NAME=sblobas1)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0)
)
)
inbound_connect_timeout_listener11gr2=10
os solaris
i get this error on my first attempt and get successfully connected on my second attempt.
I am facing this problem with two newly created instances and there listeners
can u please help
Thanks a lot ..i was troubleshooting this issue from last 2 days ...your solution worked for me..Thanks again
Thanks a lot ..i was troubleshooting this issue from last 2 days ...your solution worked for me..Thanks again
Thanks a lot
This work for me.
It worked for me also! thanks
Thanks, It worked for me as well :)
Post a Comment