I tried killing all the ora_xxxx_sid processes and even the remaining
tnslsnr, but I still get ORA-03113 when I open svrmgrl!

Hellmar

-----Ursprüngliche Nachricht-----
Von: Hellmar Becker [mailto:[Email Address Removed] Mittwoch, 31. Oktober 2001 19:49
An: LazyDBA.com Discussion
Betreff: Shutdown issue


Hi all,

I shot myself in the foot by trying to delete rows from a table that might
be corrupt. Anyway, after some hours I decided to stop it and tried a
shutdown immediate, which stayed hanging too. The next thing was I killed
svrmgrl and tried to re-open it, in order to do a shutdown abort. However, I
always get

ORA-03113: end-of-file on communication channel

when trying to connect. How can I shut down the database? Just waiting won't
do because I don't have the time!

- This is Oracle 8.1.6 on Solaris/Sparc

Thanks, Hellmar


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page