This discussion is archived
3 Replies Latest reply: Jan 31, 2013 2:20 PM by clcarter RSS

Failure to connect to 11G XE from Sql Developer

986006 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 ;)

Legend

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