tnsping is working ... but can not connect to db
Posted on 2010-12-28
I'm able to ping my server and tnsping my db, but when trying to connect either using sqlplus or toad, giving this error:
ORA-12514: TNS: listener does not currently know of service requested in connect descriptor.
Where as in toad, using TNSNames editor, able to test too and it can ping and also using network utilities it can ping & tnsping too ... but can't connect using sqlplus or even toad too.
Please assist, thanks.