3 Replies Latest reply: Jan 31, 2013 4:20 PM by clcarter RSS

    Failure to connect to 11G XE from Sql Developer

    986006
      Hi Gurus,

      I have been trying for more than a week to make this work. Basically I am trying to install XE database 11.2.0 on my windows 7 64 bit computer.
      I have had problems with the getting the listener up , finally managed to get it up by deleting the Oracle_home and reinstalling 11g XE.
      Changed the listener.ora file to include the sid XE - restarted th listener so now its working.

      -- I am able to start the instance from command prompt as
      *********************************************
      SQL> conn / as sysdba
      Connected.
      SQL> startup
      ORACLE instance started.

      Total System Global Area 1071333376 bytes
      Fixed Size 1388352 bytes
      Variable Size 620757184 bytes
      Database Buffers 444596224 bytes
      Redo Buffers 4591616 bytes
      ORA-00205: error in identifying control file, check alert log for more info**

      When I checked the log files here are the details
      from C:\Oracle11XE\app\oracle\diag\rdbms\xe\xe\alert

      <txt>ORA-00210: cannot open the specified control file
      ORA-00202: control file: &apos;C:\ORACLE11XE\APP\ORACLE\ORADATA\XE\CONTROL.DBF&apos;
      ORA-27041: unable to open file
      OSD-04002: unable to open file
      O/S-Error: (OS 2) The system cannot find the file specified.
      </txt>
      ***********************************************************************************************
      Please let me know how I can resolved this issue. The eventual goal is to get the database up and running and be able to conenct from Sql Developer installed on the same machine.

      any help will be greatly appreciated.

      Here are some details

      tnsnames.ora
      **********

      XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <Cumputername>)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = XE)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      listener.ora
      ********
      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\Oracle11XE\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\Oracle11XE\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\Oracle11XE\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
      )

      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = <ComputerName>)(PORT = 1521))
      )
      )

      DEFAULT_SERVICE_LISTENER = (XE)

      lsnrctl status result
      *****************************
      LSNRCTL> status
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
      ction
      Start Date 30-JAN-2013 11:35:47
      Uptime 0 days 0 hr. 0 min. 13 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Default Service XE
      Listener Parameter File C:\Oracle11XE\app\oracle\product\11.2.0\server\network
      \admin\listener.ora
      Listener Log File C:\Oracle11XE\app\oracle\diag\tnslsnr\ZaidHP\listener\
      alert\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ZaidHP)(PORT=1521)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "XE" has 1 instance(s).
      Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully

      Thanks

      Edited by: user12026382 on Jan 30, 2013 10:57 AM
        • 1. Re: Failure to connect to 11G XE from Sql Developer
          clcarter
          ORA-00205: error in identifying control file, check alert log for more info
          That's one symptom of an incomplete installer run, basically you don't have a database to startup. That's my guess, anyways.

          Only suggestion is to do an uninstall, following all deinstall steps in the Install Guide for Windows, and try running installer again.

          With the later versions of Windows some things need a "run as administrator" session. And that is about as much as I know of the Windows OS.

          See http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#CIHDDHJD
          • 2. Re: Failure to connect to 11G XE from Sql Developer
            986006
            Hi clcarter

            Thanks for your input. I actually did a complete de-install and re-install.
            The two things I did differently this time was

            1. Delete any ORACLE_HOME or ORACLE_SID variables that were existing and just to make sure check from cmd> set ORACLE_HOME - should return not defined.
            (This I found at a different forum)
            2. Run the setup (as administrator) this time.

            And you guessed it.. It worked. I was able to login to the database. Also could go to the database home page.
            Thanks for your inputs.

            On a side note.. since I am new to forums, I wanted to know how you quote things in the grey area as you did when you replied 'ORA-00205: error in identifying control file, check alert log for more info'.
            • 3. Re: Failure to connect to 11G XE from Sql Developer
              clcarter
              Start a line with a "greater than" (&gt;) symbol and paste in the copied text.

              Quite a few formatting tips in the forum FAQ, see the "FAQ" hyperlink under "Your Control Panel" , "Sign Out" links. Like how to link to a thread or a reply, link to a different forum, using code tags, etc.

              There are quote tags too, but that is ... 13 extra keystrokes ;)