This discussion is archived
3 Replies Latest reply: Oct 15, 2012 9:33 AM by gs RSS


gs Newbie
Currently Being Moderated
this is the error im getting too often while using cmd prompt to access the instance...what are the steps to rectify it.plz any 1 help me in solving it.
  • 1. Re: ora-12560
    orafad Oracle ACE
    Currently Being Moderated
    Common user errors that ORA-12560 is indication of: 1) improper environment settings or 2) service not started (windows OracleService<sid>).

    If that does not help, you would need to provide some background information first:

    What do you have? (versions, os, env, etc.)

    What does "using cmd prompt to access the instance" actually involve?
    Show us your steps and output via copy-paste from command line session.

    Edited by: orafad on Sep 26, 2012 10:37 PM
  • 2. Re: ora-12560
    clcarter Expert
    Currently Being Moderated
    If your OS is windows, ora-12560 is a symptom of the database service not running, check your services applet (Start/Run/services.msc) and check the OracleXETNSListener and OracleServiceXE services are running.

    The services may be set to autostart, or not. Without a running database service you won't be able to connect to the instance.
  • 3. Re: ora-12560
    gs Newbie
    Currently Being Moderated
    windows 7 home premium is my os


  • Correct Answers - 10 points
  • Helpful Answers - 5 points