Many thanks Mary, that was it!
Hellmar
-----Ursprüngliche Nachricht-----
Von: Mary Bahrami [mailto:[Email Address Removed] Mittwoch, 31. Oktober 2001 20:23
An: 'Hellmar Becker'
Betreff: RE: Shutdown issue
Hellmar,
You have either memory segments or semaphores still assigned to the oracle
processes. Are you solaris?
if so, do:
ipcs -s to see semaphores belonging to oracle
ipcs -m to see memory segs belonging to oracle
Note: don't touch segments belonging to root! Also, if you have multiple
databases, shut the others down if possible so you don't kill the wrong
databases.
remove the semaphores by: ipcrm -s pid and ipcrm -m for memory
If you have metalink, see note 68281.1 for info on how to get the
semaphores from within the dbase (for any OTHER dbases you have
running)....but I have found that the process ids are not always
accurate....better to shutdown first.
HTH,
mary
-----Original Message-----
From: Hellmar Becker [mailto:[Email Address Removed] Wednesday, October 31, 2001 11:08 AM
To: LazyDBA.com Discussion
Subject: WG: Shutdown issue
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 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