• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2361
  • Last Modified:

Connected to an idle instance when after logging into oracle database

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,
0
Swadhin Ray
Asked:
Swadhin Ray
  • 5
  • 2
2 Solutions
 
slightwv (䄆 Netminder) 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.
0
 
Swadhin RaySenior Technical Engineer 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
0
 
johnsoneSenior Oracle DBACommented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Swadhin RaySenior Technical Engineer Author Commented:
I have already did that but still facing the same issue.
0
 
slightwv (䄆 Netminder) Commented:
If you cleared out ALL event logs, do you have free disk space?
0
 
Swadhin RaySenior Technical Engineer Author Commented:
@slightwv : Yes  I did and I have enough free space.

Let me uninstall it again and re-install again and check.
0
 
Swadhin RaySenior Technical Engineer 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.
0
 
Swadhin RaySenior Technical Engineer Author Commented:
As re-installing solved my problem but the comments are also helpful to resolve same kind of issues.

Thanks,
Sloba
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now