ORA-01092: ORACLE instance terminated. Disconnection forced

Hello

Oracle Database 8i has the following error
ORA-01092: ORACLE instance terminated. Disconnection forced

When I checked  Alert.Log I have seen the following , but the error at 11 AM and Database is disconnected at 19:00 PM !!

Any Ideas ?


Errors in file C:\Oracle\admin\neec\bdump\neecRECO.TRC:
ORA-12535: TNS:operation timed out

Thu Sep 10 11:03:14 2015
Thread 1 advanced to log sequence 639665
  Current log# 2 seq# 639665 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thu Sep 10 12:48:27 2015
Thread 1 advanced to log sequence 639666
  Current log# 3 seq# 639666 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639667
  Current log# 1 seq# 639667 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639668
  Current log# 2 seq# 639668 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639669
  Current log# 3 seq# 639669 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thu Sep 10 16:56:59 2015
Thread 1 advanced to log sequence 639670
  Current log# 1 seq# 639670 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639671
  Current log# 2 seq# 639671 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639672
  Current log# 3 seq# 639672 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639673
  Current log# 1 seq# 639673 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639674
  Current log# 2 seq# 639674 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639675
  Current log# 3 seq# 639675 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639676
  Current log# 1 seq# 639676 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639677
  Current log# 2 seq# 639677 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639678
  Current log# 3 seq# 639678 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639679
  Current log# 1 seq# 639679 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639680
  Current log# 2 seq# 639680 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639681
  Current log# 3 seq# 639681 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thu Sep 10 17:04:18 2015
Thread 1 advanced to log sequence 639682
  Current log# 1 seq# 639682 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639683
  Current log# 2 seq# 639683 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639684
  Current log# 3 seq# 639684 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639685
  Current log# 1 seq# 639685 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639686
  Current log# 2 seq# 639686 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639687
  Current log# 3 seq# 639687 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639688
  Current log# 1 seq# 639688 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639689
  Current log# 2 seq# 639689 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639690
  Current log# 3 seq# 639690 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639691
  Current log# 1 seq# 639691 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
Thread 1 advanced to log sequence 639692
  Current log# 2 seq# 639692 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO02.LOG
Thread 1 advanced to log sequence 639693
  Current log# 3 seq# 639693 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO03.LOG
Thread 1 advanced to log sequence 639694
  Current log# 1 seq# 639694 mem# 0: C:\ORACLE\ORADATA\NEEC\REDO01.LOG
m_jundiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
>>When I checked  Alert.Log I have seen the following

There is nothing around 7PM in the alert log?

Do you have some process that recreates the alert log every night?

Look for some archived or older version of the alert log that might have the 7PM time in it.
m_jundiAuthor Commented:
No it is the same Alert file since database creation, size is 73 MB , I meant DB gave us the error at 19 PM and not found in the alert log what about this error :
Errors in file C:\Oracle\admin\neec\bdump\neecRECO.TRC:
ORA-12535: TNS:operation timed out
m_jundiAuthor Commented:
I have restarted the server and Oracle is working but need to understand why this happened ? also I noticed that the server Response was very slow when connected via RDP , then after a while error apeared
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

slightwv (䄆 Netminder) Commented:
>>I meant DB gave us the error at 19 PM and not found in the alert log

To clarify:  There is nothing in the alert log around 7PM on the date the ORA-01092 occurred?

>>what about this error :

What about it?

I suppose the ORA-12535 might have caused some application to generate a ORA-01092.

Was that error in the alert log about 7PM?
slightwv (䄆 Netminder) Commented:
>>I have restarted the server and Oracle is working but need to understand why this happened ?

Not sure if you will ever know if you cannot find the trace files that might have been generated.

From the original error message it looks to me like the database crashed.  There should be trace files on the server somewhere that captured the event.  You will just have to go digging through the trace files if you cannot get to the exact one from the alert log.
m_jundiAuthor Commented:
neecLGWR.TRC has the following :

*** 2015-09-10 18:57:35.472
*** SESSION ID:(3.1) 2015-09-10 18:57:35.456
ORA-00321: log 2 of thread 1, cannot update log file header
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\NEEC\REDO02.LOG'
ORA-27091: skgfqio: unable to queue I/O
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
error 321 detected in background process
slightwv (䄆 Netminder) Commented:
That seems to tell you what happened:
Oracle couldn't write to the file C:\ORACLE\ORADATA\NEEC\REDO02.LOG

That might have caused the instance to crash.

Now what caused that:  I have no idea.

Check the Windows event log around that time.  You might have had some type of disk failure.
m_jundiAuthor Commented:
Already Checked that but can't find anything, I have raid 5 and hard disks are fine, , what do you recommend  to fix the redo log ?
m_jundiAuthor Commented:
By the way the DB running without archive mode
slightwv (䄆 Netminder) Commented:
>>what do you recommend  to fix the redo log ?

Nothing right now.  There may not be anything wrong with it.

See which redo log is currently active:
select member, l.status from v$log l, v$logfile f where l.group#=f.group#;


If redo2 isn't active, switch them until it is:
alter system switch logfile;

Let things run for a while.  Eventually Oracle will naturally switch the logs.  When redo2 is no longer being used and nothing 'happened', then the file itself was fine.
slightwv (䄆 Netminder) Commented:
>>By the way the DB running without archive mode

I hope the data isn't important and you are allowed to have data loss when the database crashes.
m_jundiAuthor Commented:
C:\ORACLE\ORADATA\NEEC\REDO01.LOG
 INACTIVE
C:\ORACLE\ORADATA\NEEC\REDO02.LOG
 INACTIVE
C:\ORACLE\ORADATA\NEEC\REDO03.LOG
 CURRENT

Can I keep it on REDO03 ? or Should switch for "2" in order to test, the DB crashed while no updates are done, do you think might lost data ?
slightwv (䄆 Netminder) Commented:
>>Can I keep it on REDO03 ? or Should switch for "2" in order to test,

If you want to test REDO2 for possible corruption, Oracle will need to write to it.  You can either force the switch to it or wait until Oracle migrates back around to it.

>>the DB crashed while no updates are done, do you think might lost data ?

The alert log should tell you.  It should have done an "instance recovery" when you restarted.  If that was successful, Oracle was able to recover all committed transactions.


If you are worried about data loss, you should be in archive log mode.  It wouldn't help here for a corrupt online redo log, if you have one, but it will save you in the future.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
m_jundiAuthor Commented:
If the redo 2 corrupted and Oracle Crashed again,how to fix it?
slightwv (䄆 Netminder) Commented:
>>If the redo 2 corrupted and Oracle Crashed again,how to fix it?

Then you can drop and recreate the log group.
slightwv (䄆 Netminder) Commented:
Can I ask what additional information you needed before providing an "A" grade?
m_jundiAuthor Commented:
Some details about recreating Redo Logs, Iam not familiar with Oracle 8i.
Appreciate your help
slightwv (䄆 Netminder) Commented:
If you wanted more information, all you had to do was ask.

In my opinion, I didn't feel the file was corrupt and would be just fine.  I didn't want to provide it and confuse things if the log file wasn't corrupted.

I would probably add a new member to that log group and remove the 'corrupt' one.

Adding a member:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/onlinere.htm#471

Dropping a member:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/onlinere.htm#624
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.