RE: Help on Upgrade - I'm an idiot
That's what I ended up doing. While I was struggling with it I was told by my boss that the decision was made that we can't install the 8.1.6.3 patch because we only have 8.1.6.2 in QA. So I've killed the database entirely (processes and files) and am now reinstalling 8.1.6 from the beginning to redo the upgrade from the backup. Sigh, late night ahead. -Original Message- Sent: Tuesday, June 12, 2001 4:39 PM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Help on Upgrade - I'm an idiot
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Help on Upgrade - I'm an idiot
Jay: Did the error generate a trace file? Jon Walthour, BSCD Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Miller, Jay" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 6/12/01 3:30:31 PM > >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
