Discussion Locked

Oracle on WinNT4.0

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm facing problem while starting up Oracle8.
In svrmgr30 when I Startup with Mount Option Database is mounted.
But as soos as i'm opening the DB it giving
Dr.Watson Error:-

"An application error has occurred
and an application error log isbeing generated."

"Oracle80.exe"
Exception: (0xc000001e), Address: 0x0100e18e.

It is giving this error since NT4.0 run chkdsk and found bad block. However Nt detected & fixed/moved
the files from the bad block to other cluster.
filesthat were moved from bad block are:-

1. pagefile.sys,
2. one lotus domino help file,
3. one old Oracle archive file,
4. one oracle pls804.dll file.

While NT-4.0 & Lotus Domino R-5 is running ok, but not Oracle8.0.4.0.
Instance is starting, service is starting, but Database is not opening.
My Oracle8 is in archivelog mode.

Pls. help me. it's urgent...!!!

5 replies

by craig_hochgraef

I would start with re-installing Oracle, since the oracle exe is probably bombing due to the dll that was corrupted. If there were any problems with your datafiles, oracle would error on the corrupted data files and not open the database but tell you which ones its having problems with. Since its bombing out completely, then I would definatly have suspisions obout the integrity of the Oracle installation itself.

Installing oracle over an previous insatllation is pretty easy if you just letthe Oracle Installer do its business. Your old instances should still be in tact once oracle comes back up. For safety's sake, stop ALL oracle services before starting the reinstall. At the very worst you may have to re-create your services foreach sid with oradim.

by amba

As far as I know Oracle use different read/write block model. It usualy consist of multiplication of O/S blocks. That's why I think that when NT moved corrupted O/S block which was part of Oracle block - Oracle can struggle. Probably reinstallation is the easiest method to solve this problem. You could start playing with export/import but again reinstaling is probably less overhead.

This discussion is closed to new replies.