| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help on Upgrade - I'm an idiot
There is always the ultimate last resort Jay. If you can not stop the DB any other way you can always kill all of its processes.
This is not recommended as a way or normally stopping a DB, but I have used it in the past when I was out of choices.
After killing the processes, I brought the DB up a step at a time .... nomout, shutdown .... mount , shutdown ... open ... shutdown . Then finally opened it up. I wanted to see how it faired on each step before I commited anything.
You might give it a whirl if its your only alternative.
Kevin
-----Original Message-----
Sent: Tuesday, June 12, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
Jay:
You may have some semaphore stuff screwed up... (i'm not a UNIX Admin and I don't play one on TV) I ran into this before too. We had to bounce the box to fix the problem.
Kevin
-----Original Message-----
Sent: Tuesday, June 12, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
I'm doing a test upgrade from 8.0.4 to 8.1.6.3. Finished the 8.1.6 upgrade. Was about to do the patch installation when I was called into a meeting then got 2 phone calls (this all kept happening during the upgrade also) and had several people stop by. Finally got back to it, started the patch installation and soon realized that I hadn't shut the database down before doing so. I immediately stopped to patchset installation and tried to shut down the database but I get the following errors:
$ svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-03113: end-of-file on communication channel
SVRMGR> connect internal
Password:
Is there anything I can do or do I need to restore from backup and start the whole procedure from scratch?
2nd question: Is it possible to do the patch install and then do the
upgrade? The patchset instructions imply not, but there's a technical forum
response that implies you can. Which is it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jun 12 2001 - 14:33:32 CDT
 |
 |