ORA-12170: TNS:Connect timeout

[Roshan]

Hello Erman,

I have installed Oracle client on a server. Listener has been configured. It is up and running.

Firewall has been disabled.

Why can't I connect using toad?

err.png

Rgds,

Roshan

[Roshan]

Red Hat linux 6.5
Oracle Database 11.2.0.4

[Roshan]

RPT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.29.228)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = RPT)
    )
  )

[ErmanArslansOracleBlog]

Send me the following info:

From your client PC where you installed Toad:

telnet 10.210.29.228 1521

From the server where your db is running; with oracle OS user

lsnrctl status <YOUR_LISTENER_NAME>

2017-02-03 15:03 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

RPT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.29.228)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = RPT)
    )
  )

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ORA-12170-TNS-Connect-timeout-tp2064p2066.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Roshan]

listener.png
telnet.png

[ErmanArslansOracleBlog]

If the IP (10.210.29.228) is correct, then your client can't even reach the listener's port.
Check with your network + firewall admin, because it is a firewall or network issue. Basically, client has no access to the db server:port .