Re: Problem restarting an instance after interrupting sqlload

Bill Wood wrote:
>
> I am an inexperienced Oracle user. This is the evolution of my current
> problem:
>
> 1) I created a table in a db and then began to use the sqlload
> application to stuff it with data. During this process, I noticed an
> error and stopped the sqlload with a control-c.
>
> 2) I tried to start over and the sqlload process just sat there -
> couldn't load anything, so I stopped it and tried to drop and recreate
> the table.
>
> 3) This got me an ORA:00054 error that the table is locked and I can't
> drop it.
>
> 4) I tried shutting down and restarting the instance and now it gives me
> an ORA:00205 error in identifying control file and an
> ORA-09782: sfifi: another instance has the same database mounted.
>
> 5) I tried changing the ifile to use different control file names and I
> still got the ORA:00205 errors.

  Check the lock and kill it.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841