Re: SQLPlus problem (ORA-01033)

I had something similar happen to me just today (8.0.5 on Win2K). All of the Oracle tools reported that Oracle was unavailable, even after several restarts of the server, and even though Services showed all of the appropriate services as Started. In the Application Event Log it showed each time the startup and then an immediate shutdown of Oracle.

After futzing around for a couple of hours to no avail, I finally uninstalled and reinstalled Oracle, then imported a backup dmp file. Now I'm up and running, and fortunately this was an expendable development database, but I'd sure like to know how to resolve this next time without such drastic measures (or even better, prevent it).

--
Jim Davis
Informatique Ressources Humaines


"Glenn Moodie" <glennm_at_i2.co.uk> a écrit dans le message news:
397e9a84$1_2_at_nnrp1.news.uk.psi.net...


> I'm running Oracle 8i on NT4, but I have the following problem:

>

> 1) Run sqlplusw.exe (in <Oracle product>/Ora81/bin), with system/manager,

> but no connect string. System returns error:

>

> Oracle ORA-01033: ORACLE initialisation or shutdown in progress

>

> Program goes back to login.

>

> 2) Run plus80w.exe (in <Enterprise Manager>/bin), with system/manager, but

> no connect string. Connects with no problems.

>

> It appears that something has been corrupted, but why the difference with

> sqlplus and plus80?

>

> What I'm really trying to do is import an Oracle dump file (from 'exp'),

 but


> this also refuses to recognise the username and password when I run

>

> >imp system/manager file=abcd.dmp log=import.log

>

> Any ideas?

>

> Thanks.

>

> Glenn.

>

>

>

>

>