SQL & PL/SQL

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!

ERROR ORA-12170: TNS:Connect timeout occurred

490126Feb 12 2006 — edited Oct 6 2010

I have this error "ERROR ORA-12170: TNS:Connect timeout occurred" when connecting as user/pwd@instance, but I am able to connect only with the user. What I am doing wrong??

Example:
#sqlplus /nolog
SQL> connect myuser/mypassword@myinstance
ERROR:ORA-12170: TNS:Connect timeout occurred

SQL> connect myuser
Enter password: ***********
Connected.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2010

Added on Feb 12 2006

#from, #oracle, #to

18 comments

313,829 views