ORA-01092: ORACLE instance terminated. Disconnection forced

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Reshmi Jacob
    New Member
    • Sep 2006
    • 50
    #1

    ORA-01092: ORACLE instance terminated. Disconnection forced

    Hi

    I am facing this error while working with a database, about 40-50 persons are using this DB.

    I searched thru the sites to refer these error. They are saying t look into ALERT.LOG. I searched the entire server but couldn't find ALERT.LOG. Can any body help in finding this file???

    Also, why this happens??? In the server, I have One database, 2 Users, 1 Listener, 1 Service Name.

    Anybody Help..........

    Regards
    Reshmi
    Tags: None
    • ManjunathRG
      New Member
      • May 2007
      • 5
      #2
      Hi Reshma
      you can find the alert file in oracle\admin\yo urdatabasename\ bdump

      reason:i am not sure.. some problem with memory allocation i guess. :)

        Comment

        • Reshmi Jacob
          New Member
          • Sep 2006
          • 50
          #3
          Hi

          Thanks, i was seaching for Alert.LOG !!!


          Thaks again
          Reshmi

          Originally posted by ManjunathRG
          Hi Reshma
          you can find the alert file in oracle\admin\yo urdatabasename\ bdump

          reason:i am not sure.. some problem with memory allocation i guess. :)

            Comment

            • Reshmi Jacob
              New Member
              • Sep 2006
              • 50
              #4
              Hi

              In the ALERT LOG I found...


              Sat May 05 11:15:42 2007
              alter database open
              Beginning crash recovery of 1 threads
              Sat May 05 11:15:43 2007
              Thread recovery: start rolling forward thread 1
              Recovery of Online Redo Log: Thread 1 Group 1 Seq 30112 Reading mem 0
              Mem# 0 errs 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 3.LOG
              Sat May 05 11:15:43 2007
              Thread recovery: finish rolling forward thread 1
              Thread recovery: 7 data blocks read, 4 data blocks written, 7 redo blocks read
              Crash recovery completed successfully
              Sat May 05 11:15:43 2007
              Thread 1 advanced to log sequence 30113
              Thread 1 opened at log sequence 30113
              Current log# 2 seq# 30113 mem# 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 2.LOG
              Successful open of redo thread 1.
              Sat May 05 11:15:44 2007
              SMON: enabling cache recovery
              SMON: enabling tx recovery
              Sat May 05 11:15:51 2007
              Completed: alter database open
              Sat May 05 11:20:53 2007
              Thread 1 advanced to log sequence 30114
              Current log# 3 seq# 30114 mem# 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 1.LOG
              Sat May 05 11:23:08 2007
              Thread 1 advanced to log sequence 30115
              Current log# 1 seq# 30115 mem# 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 3.LOG
              Sat May 05 11:25:23 2007
              Thread 1 advanced to log sequence 30116
              Current log# 2 seq# 30116 mem# 0: D:\ORACLE\ORADA TA\ORACLE\REDO0 2.LOG

              What may be the problem with my Database????

                Comment

                • Reshmi Jacob
                  New Member
                  • Sep 2006
                  • 50
                  #5
                  Hi

                  Is this the corruption of REDO log file. How can I rectify it

                  Reshmi

                    Comment

                    Previous template Next
                    Working...