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!

ORA-12170: TNS:Connect timeout occurred on the same host as DB

user10623291May 25 2014 — edited May 25 2014

Hello,

I just  installed Oracle on mu Ubuntu 12.4 following the instructions provided here:

http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bits

and here:

Install Oracle Database 11gR2 on Ubuntu 12.04

However, when I try to log on to the database I've created during install using sqlplus, it hangs for a minute or two until it errors out with:

ORA-12170: TNS:Connect timeout occurred.

My tnsnames.ora:

MYSID =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mySID)
    )
  )

I verified that the listener is running and listening at the post 1521:

s$ sudo netstat -tulpn|grep 1521

tcp6       0      0 :::1521                 :::*                    LISTEN      16732/tnslsnr 

$ ps -ef|grep 16732

oracle   16732     1  0 06:58 ?        00:00:00 /opt/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit

Thoughts?

This post has been answered by user10623291 on May 25 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2014
Added on May 25 2014
18 comments
13,121 views