This discussion is archived
5 Replies Latest reply: Feb 26, 2012 9:00 PM by 904205 RSS

unable o connect database

904205 Explorer
Currently Being Moderated
Hi Experts,

when i am trying to connect database in my local machine i am getting error like below from past 3 days.

please help me for this problem, i have very important data in my db.

Os:Win xp.

Error is:

SQL> conn scott/password
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


SQL> conn sys/password AS SYSDBA
ERROR:
ORA-28056: Writing audit records to Windows Event Log failed
OSD-248170904: Message 248170904 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) The event log file is full.
ORA-01075: you are currently logged on



Thanks in Advance.
surya.
  • 1. Re: unable o connect database
    912595 Expert
    Currently Being Moderated
    1) Check if you are not running out of disk space first...
    2) Check if OracleService<SID> is running in services.msc
  • 2. Re: unable o connect database
    rp0428 Guru
    Currently Being Moderated
    Did you just reboot the pc?
    >
    ORA-01033: ORACLE initialization or shutdown in progress
    >
    That is the error you would get after you restart the pc and Oracle hasn't finished startup.
  • 3. Re: unable o connect database
    sb92075 Guru
    Currently Being Moderated
    surya wrote:
    Hi Experts,

    when i am trying to connect database in my local machine i am getting error like below from past 3 days.

    please help me for this problem, i have very important data in my db.

    Os:Win xp.

    Error is:

    SQL> conn scott/password
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress
    Process ID: 0
    Session ID: 0 Serial number: 0


    SQL> conn sys/password AS SYSDBA
    ERROR:
    ORA-28056: Writing audit records to Windows Event Log failed
    OSD-248170904: Message 248170904 not found; product=RDBMS; facility=SOSD
    O/S-Error: (OS 1502) The event log file is full.
    ORA-01075: you are currently logged on



    Thanks in Advance.
    surya.
    O/S-Error: (OS 1502) The event log file is full
    O/S-Error: (OS 1502) The event log file is full
    O/S-Error: (OS 1502) The event log file is full

    do you require any additional clues?


    Handle:     surya
    Status Level:     Newbie (60)
    Registered:     Dec 7, 2011
    Total Posts:     151
    Total Questions:     50 (35 unresolved)

    why so many unanswered questions?

    Edited by: sb92075 on Feb 26, 2012 8:30 PM
  • 4. Re: unable o connect database
    Shivananda Rao Guru
    Currently Being Moderated
    Your windows event log (Start->Run->eventviewer) is full. Clear old logs and then try to connect to the database.

    Mark the thread as answered by providing appropriate points or else even this thread would add up to your account of heap of unanswered questions that you are having ;)

    Keep the forum clean by marking your questions as answered !!!
  • 5. Re: unable o connect database
    904205 Explorer
    Currently Being Moderated
    Hi sb92075,

    I didn't get proper correct answers for my threads that's why i am having that many unanswered questions.

    Any way database connecting problem is solved.

    Regards,
    Surya.

Legend

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