5 Replies Latest reply: Feb 26, 2012 11:00 PM by 904205 RSS

    unable o connect database

    904205
      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
          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
            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
              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
                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
                  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.