How can I resolve Oracle 11g XE connection failure straight after installation?

Posted by d3vid on Server Fault See other posts from Server Fault or by d3vid
Published on 2011-12-28T14:55:06Z Indexed on 2012/07/04 3:17 UTC
Read the original article Hit count: 688

I have just installed Oracle 11g XE on a Windows 7 VirtualBox VM, using all the default options.

"Getting Started" fails

When I click on Getting Started I get taken to http://127.0.0.1:8080/apex/f?p=4950 which fails. After some browsing I came across a suggestion to confirm the HTTP port, but I can't get this far, because I can't connect.

connect system fails

If I select Run SQL command line I get taken to a SQL prompt. I enter connect system and get prompted for a password. I enter the password. I immediately get the following error:

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Info: Start database

This happens whether or not I run Start database first. (Start database just opens a Windows command prompt window.)

Info: Windows services

My Oracle services start as follows:

Oracle XE services default startup

Starting the manual services doesn't resolve the problem. Enabling and starting the disabled service doesn't resolve the problem.

Is there something I haven't done? How can I resolve this connection error?

© Server Fault or respective owner

Related posts about windows-7

Related posts about Oracle