Re: corrupted 8i? how to fix please?

On Sat, 24 Feb 2001 13:48:24 GMT, "Mart Hurst" <Wayfarergenesis_at_worldnet.att.net> wrote:

>Hello, had an "unexpected" system shutdown. When rebooted have been having
>problems with my Oracle 8i (on Win98). First I couldn't access SQL Plus
>from the menu but it created a shortcut icon on the desktop which worked.
>Then the query that had worked before (and works on the system at school)
>won't work.
>
>I know that the "uninstaller" that comes with this version does not work and
>you have to go into the registry to remove files in order to uninstall
>Oracle (but I don't know how to do that) -- question: can you reinstall
>Oracle over itself without uninstalling first to replace possibly corrupted
>files?
>
>Any help/suggestions much appreciated.
>
>Thanks,
>
>Mart
>

Before you re-install (which is just a *rash* measure) could you verify whether the database is actually up and running? Your assertion 'I couldn't access sql*plus' doesn't really tell anything with exact error messages.
In order to verify if and what possibly went wrong, find the bdump directory on your system, and look for a file called alert<SID>.log, your SID most likely is ORCL.
Your assertion uninstalling doesn't work looks also *very* strange to me. And yes, you can reinstall without uninstall, but let's try to find the root of the problem first. Otherwise you're just going to have more problems.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Feb 24 2001 - 09:41:36 CST