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:Connection Closed

castrogenerisMay 18 2016 — edited May 18 2016

Hi,

I can't connect to Oracle Database using tnsnames, that is what appears to be.

Scenario: In the database server, using sqlplus I can log in if I type sqlplus sys as sysdba. BUT in the same server I can not log in if I type sqlplus@<service> as sysdba.

So you can imagine I can not logging from a client computer with sqlplus or running SQL Developer for example.

I have checked listener.ora, tnsnames.ora and all seem right, also the status of the listener show up and shows the handler for the service.

Firewall down and still same issue.

What info should I share to get some help?

Thanks in advance.

This post has been answered by castrogeneris on May 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2016
Added on May 18 2016
8 comments
1,234 views