We help IT Professionals succeed at work.

Connected to an idle instance when after logging into oracle database

Swadhin Ray
Swadhin Ray asked
on
Hello Experts,

I installed Oracle 11g express edition. It was installed successfully.

But when I logged in then I get the below :

SQL*Plus: Release 11.2.0.2.0 Production on Tue Aug 14 20:56:26 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

Open in new window


I cleared all my event log from my windows machine.
Checked my >echo %ORACLE_HOME%:
output: C:\oraclexe\app\oracle\product\11.2.0\server

Even checked my Regedit : the values is been set to same oracle
C:\oraclexe\app\oracle\product\11.2.0\server

When loged in again and check still I am getting the same issue.

Need urgent help to resolve this issue,
Comment
Watch Question

SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
The Service isn't running and/or the database is down.

Check to see if the Service is running.  If it is, check the alert log to see why the database isn't starting.
BRONZE EXPERT

Author

Commented:
Services are running.
But I see few errors on my alert log :
C:\oraclexe\app\oracle\diag\rdbms\xe\xe\alert

AUD: OS Error = 1502 encountered while writing audit record
johnsoneSenior Oracle DBA
BRONZE EXPERT
Commented:
Based on this post:

http://answers.microsoft.com/en-us/windows/forum/windows_vista-performance/error-1502-delete-event-log/8a263c50-4a22-4529-82bd-a314c292b0e2

It appears to have something to do with the event log.  It links to a note with some more information.  I have no idea if that is relate to Oracle not starting, but that seems to be what the error points to.
BRONZE EXPERT

Author

Commented:
I have already did that but still facing the same issue.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
If you cleared out ALL event logs, do you have free disk space?
BRONZE EXPERT

Author

Commented:
@slightwv : Yes  I did and I have enough free space.

Let me uninstall it again and re-install again and check.
BRONZE EXPERT

Author

Commented:
After re-installing oracle XE solved my problem but still I am not sure what caused this issue.

Even I was having enough disk space.
BRONZE EXPERT

Author

Commented:
As re-installing solved my problem but the comments are also helpful to resolve same kind of issues.

Thanks,
Sloba