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



9 comments:

Anonymous said...

Excellent!! Your solution worked for me..Cheers

Anonymous said...

darThanks a lot!
You made my day :)
Cheers,
Brit

Anonymous said...

Thank you! It worked for me

Cheers,
Quangnn@etc.vn

Anonymous said...

thanks!!! this worked

Unknown said...

Thank you So much

Anonymous said...

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

SHRIJEET SOWAL said...

Thanks a lot ..i was troubleshooting this issue from last 2 days ...your solution worked for me..Thanks again

SHRIJEET SOWAL said...

Thanks a lot ..i was troubleshooting this issue from last 2 days ...your solution worked for me..Thanks again

Anonymous said...

Excellent!