ORA-12170 TNS:Connect timeout occurred

Posted on 2009-02-14
Last Modified: 2013-12-18

I think this is not the first time this question is being asked.

I am using oracle 10g on vista.. suddenly i started facing difficulty in login in using the host name orcl. I'm getting the error ORA-12170 TNS Connect timeout occurred. But i could login successfully without typing in the host name...

please help me out..

Question by:vinodkumarn37
    LVL 16

    Accepted Solution

    1 Try to use tnsping to check network connectivity.
    2. Please check if the oracle instance is running.  You may try to telnet to the oracle server port 1521 (or your defined port).
    3. If you are inside a firewall, please check if the port 1521 (or your defined port) on the oracle server is open for you to access.
    4. Increase "SQLNET.INBOUND_CONNECT_TIMEOUT" value to a larger value in sqlnet.ora, especially when u are connecting through database link.
    LVL 7

    Expert Comment

    try to ping the server. it could be due to slow network connection or a firewall issue. if everything is ok from network side, then check tnsping side

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now