Help--Oracle9204 Running SuSE8.1 Ent

[wanghongbin]

I have an Oracle9204 running on SuSE 8.1 Ent version.

It has been running properly for almost one year!

But, several days ago, the machine is power off accidently!

When we restart the server, and want to run any other oracle command --"lsnrctl","sqlplus", there is always an error appears，I search it on google, but there is no any idea for that, If you can give me any suggestion, I will appreciate you!!!

The error is following:

Inconsistency detected by ld.so: ../sysdeps/i386/dl-machine.h: 385: elf_machine_rel_relative: Assertion `((reloc->r_info) & 0xff) == 8' failed!

[gogalthorp]

Sounds like it could be low level disk corruption. I'd run a low level disk test and recover program. I use Spinrite but it is not a free program. It is the very best program I know of to recover from low level corruption. Also I think I'd put a UPS on the server.

GRC*|*SpinRite 5.0 to 6.0**

[wanghongbin]

It is difficult to find a version for Linux! Is there any other simlar tool for linux? It is better if it is free.

Thanks

[wanghongbin]

SpinRite is a single program file that offers completely different services when it is run under Windows or DOS. It should first be run under Windows to choose and create some form of bootable media. You can choose to create a self-booting floppy diskette, a bootable CD-R ISO image file, or to prepare a USB flash drive or other bootable device for booting.

Then, when the media prepared by the Windows-side of SpinRite is booted, the FreeDOS operating system included within SpinRite will boot, and it will, in turn, start SpinRite to begin performing data recovery, maintenance, and repair.

So . . . after you download the SpinRite.exe program, run it under Windows to have it create a bootable media format of your choice. Then shutdown and restart the target system, booting it with the SpinRite bootable media to start the FreeDOS operating system which will automatically run SpinRite under FreeDOS.

[gogalthorp]

Spinrite is OS independent. You boot from an image, it actually runs on FreeDos. The setup program is Windows based but I believe it will run under wine. You run the setup program to create a bootable image which you then put on a floppy or CD. Then boot from there.

I'm sure there are some free programs out there but I know of none that is near as good. You might check on the Site of the manufacturer of your hard drive. They often have utilities to do low level scans. But again they may simply mark sectors bad and not do the in depth testing and data rebuilding that Spinrite does. I've seen Spinrite breath life back into drives that no other program will touch.

You definitely have a data corruption problem. But it is not certain it is low level. There may be a DB rebuild function in Oracle that would correct it. But since this is a problem due to power loss it is also likely that it is a low level problem.

[wanghongbin]

Hi

Thanks your kind attention!

I agree that the tool is os independence. And I make a disk to boot the SuSE Server. The tool give me suggestion to do the level2 that is to recover the data. Then I choose the drivers and it begin to process the hard disk.

But it need too many times, My HD has 70G, and the tool need at least 120hours to process.

Do you have same experience for using it?

Thanks again!

[gogalthorp]

Yes. it takes some time the time is dependent on the size of the Drive, the speed of the drive and the speed of the processor. You must have slow equipment. It takes me about 8-10 hours to scan my 160 gig. But in any case there is no real way to speed it up. That is just the estimated time and if it must correct a lot of sectors it can take longer. You could run a level 1 scan to find the bad sectors and then run a fix on those sectors but I don't think it would save all that much time. Just run the scan on the partition that holds Oracle and or it's data.

[wanghongbin]

In fact, I made the tool to recover the disk when I left the server room tonight!

I hope it will finish the recover work tomorrow morning

I will give you the news tomorrow!

Thanks, and good night!

[wanghongbin]

In this morning, I find the tool finished the process. But the error still appears!

I don't have time; The only thing I can do is to restore and recover the database on another SuSE Linux!

Thanks your help!