Re: Oracle startup not working

On 19 sep, 18:17, "fp" <francesco.pi..._at_hotmail.it> wrote:
> "DA Morgan" <damor..._at_psoug.org> ha scritto nel messaggionews:1190206753.846224_at_bubbleator.drizzle.com...
>
> > fp wrote:
> >> Hi, I have a problem with a customer pc.
> >> [CUT]
> >> Anyone got hints?
>
> >> --
> >> francesco pighi
>
> > ORA-00600 is an internal Oracle issue. Reinstall.
>
> I resolved the original problem without a new installation.
>
> In case someone find it useful, this is the procedure i followed:
>
> - stop Oracle Service
> - remove the corrupt Control file
> - restart Oracle Service
> - type in a cmd window sqlplus "/ as sysdba"
> - in the sqlplus shell type "SHUTDOWN IMMEDIATE;"
> - type "STARTUP NOMOUNT;"
> - launch your CREATE CONTROLFILE script
> - restart Oracle Service
>
> Then i was faced with another problem (ORA-25153: Temporary tablespace is
> empty).
> To resolve this type the following sql command:
> ALTER TABLESPACE temp ADD TEMPFILE 'C:\oraclexe\oradata\xe\TEMP.DBF' REUSE;
>
> Bye
>
> --
> francesco pighi

"- remove the corrupt Control file "

So you only had ONE controlfile? Not multiplexed?

Ah! It's OracleXE again! ;-)

Cheers.

Carlos. Received on Wed Sep 19 2007 - 11:51:41 CDT