TNS Listener not running - Oracle Error

Posted on 2007-07-22
Last Modified: 2013-12-18
Seem to be getting intermittent errors while trying to connect to my Oracle 10g database, installed on my laptop. both server and the TOAD client GUI run on the same machine. I have tweaked the tnsnames.ora and the listener.ora to either or  computerName and tried but no luck. Windows XP - is the Operating system. All services /are running as checked in the Services folder of the Control Panle in windows.  Can anyone help me please . many thanks in advance.
Question by:singlekasi
    LVL 14

    Expert Comment

    go to command prompt :
    start > run > cmd > lsnrctl >

    issue :
    lsnrctl > start
    lsnrctl > status

    copy and paste the result of the error and also paste your tnsnames.ora
    LVL 14

    Expert Comment

    Check if there are any firewall issues blocking ports
    LVL 8

    Accepted Solution

    Check this Accepted Solution by paquiba, to see if it helps you, on january 26, 2007 in this website:

    I would start to modify the hosts file with the Ip address of the db's and their host name.
    Also the OMS host name added and the name of the host of the repository if not in the same server.

    Also on the node you are monitoring the ip address of the OMS and the repository and their Ip address must be added also.

          ID:18407519Author:paquicubaDate:01.26.2007 at 05:13PM ASTAccepted Solution      

    Rank: Sage
    Your laptop uses the DHCP protocol ( Dynamic Host Configuration Protocol ) to connect to the internet. In a DHCP setup, the software tracks IP addresses, which simplifies network administration. This lets you add a new computer to the network without having to manually assign that computer a unique IP address. However, before installing Oracle Database onto a computer that uses the DHCP protocol, you need to install a loopback adapter to assign a local IP address to that computer.

    The loopback adapter means that Oracle will function regardless of whether the laptop is connected to the network or not

    Follow the steps in the link below on how to install the loopback adapter and then re-install Oracle. I've implemented this "fake IP address" workaround several times and always works.

    Hope this helps!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    779 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

    17 Experts available now in Live!

    Get 1:1 Help Now