Monday, April 16, 2018

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



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?


Answer



For each and every unexpected behaviour/error see the installation logs at C:\oraclexe\app\oracle\product\11.2.0\server\config\log. It will tell what went wrongs during notifications.



In my case, it shows some thing related to windows events are full. I cleared all the events, de-install oracle and re-install. Everything is perfect.



No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...