3 Replies Latest reply: Oct 15, 2012 11:33 AM by gsundaresh RSS

    ora-12560

    gsundaresh
      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
          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
            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
              gsundaresh
              windows 7 home premium is my os