Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS: could not resolve the connect identifier specified

user5248437Oct 14 2009 — edited Oct 23 2009
I have a problem connecting to a database, but before someone tells me to check something or other,
I want to make clear:

The database is working well.
I can connect perfectly THROUGH: sqlplus / as sysdba directly from the server where it resides. The OS is Linux.

I can connect through Enterprise Manager (https: / / 172.22.170.198:1158 / em) too.

I can not do:

I can not connect THROUGH Toad
I can not connect from SQL Plus from my laptop.

I have other two databases on Linux in other servers, and I can connect perfectly well on any tool.

This DB, which is giving me problems when trying to connect through Toad or SQL Plus, I get the following message:
ORA-12154: TNS: could not resolve the connect identifier specified.

I repeat, the database is working fine, just that I want to connect from my laptop with these
tools (Toad and SQL plus) and gives me the error explain previously.

Anyone have any idea how I can solve this problem?

Thanks in advance.

ANG

Edited by: user5248437 on Oct 14, 2009 1:17 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2009
Added on Oct 14 2009
54 comments
4,430 views