I am not able to connect to database from the client. When I check with tnsping SID, it is ok. But when I try to login from sqlplus, it shows me the following error:
ORA-12154: TNS:could not resolve service name
What could be the problem?
Printable View
I am not able to connect to database from the client. When I check with tnsping SID, it is ok. But when I try to login from sqlplus, it shows me the following error:
ORA-12154: TNS:could not resolve service name
What could be the problem?
Hi,
Make sure the tnsnames.ora and listener.ora files have an entry for the database your trying to connect to (you may have to restart the listener to pick up the new config.
Cheers
Moff.
Hello,
Do you have 2 or more oracle version on your server? If yes, maybe your application don't use the good tnsname.ora.
Regards,
Steph.