getting an error while opening the sql(oracle) command prompt?

Posted on 2009-12-24
Last Modified: 2013-12-18
Hi i am installed oracle 10g  in my system .and when i am trying to open my oracle command prompt window i am facing a problem like

Enter user-name : scott
Enter password  :tiger
ORA-12560: TNS:protocol adapter error
Question by:haneefnb
    LVL 15

    Expert Comment

    by:Shaju Kumbalath

    Check whether the Windows Service for Oracle is started properly
    Check Oracle_SID parameter is set correctly in the registry
    If u have multiple homes check TNS_ADMIN environment variable is set
    Check File permission on the PC
    LVL 6

    Accepted Solution

    got to
    "ControlPannel -> AdministrativeTools -> Services"
    in your XP/Vista Operating system.
    Now, right click on each entry in the list that start with the name "oracle" and click "Start".

    Now, try to reopen the command prompt and login. This should be working.

    All the best.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    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.  …
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now