RE: 8.1.6 upgrade
No, You could actually have those running on a workstation, mine does right here.. Check under your services panel.. -Original Message- Kostyszyn Sent: Wednesday, February 28, 2001 08:56 To: Multiple recipients of list ORACLE-L Wow, that is the type of response I was looking for. However, no one should exactly sweat for me, this is a practice db, I would never do this to the production until I practiced. Also, it's not a server, it's NT Worksation, so i don't beleive that I have any of those processes running. Am I right? -Original Message- Sent: Wednesday, February 28, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Hi Kevin, We had this exact problem. It is a known issue, according to Oracle "Support". They said it was caused by the following services being left running during the patch: MSDTS, SNMP and IIS Admin Services You need to stop these before applying the patch. Basically you're hosed. I hope it's not production (as it was with us!). The "workaround" is to install /upgrade to 8.1.6.3 on another machine (our DBA used his laptop), and copy all the dll's over. Hope this helps! Jerry - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:11 PM All dlls are showing. If nt can find, why isn't oracle? Is it possible that something in the registry got hosed and it is looking in the wrong spot to execute? -Original Message- Housholder Sent: Wednesday, February 28, 2001 12:52 PM To: Multiple recipients of list ORACLE-L if i remember correctly, on some of the patches for 8.1.6, some of the dlls had an ATTRIB of hidden...make sure to check folder option, show all types...as well as going out to DOS screen...and running ATTRIB *.* patrick === Patrick Housholder Sr. Staff Anl Tech Spt Design United Airlines Flight Training Center Denver CO *-Original Message- *From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin *Kostyszyn *Sent: Wednesday, February 28, 2001 8:26 AM *To: Multiple recipients of list ORACLE-L *Subject: 8.1.6 upgrade * * *Hi all, * Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I *have done *exactly what oracle said to do and it appears as though it is *missing a .dll *and without the installation is hosed. Do you have to upgrade to *some other *version first? The instance I upgraded was 8.1.6.1, then when it *crashed I *tried a reinstall and it still gives me the same error. Any help would be *great, I see nothing in the documentaition with the patch that says I have *to be at anything other than 8.1.6. * *Sincerely, *Kevin Kostyszyn *DBA *Dulcian, Inc *www.dulcian.com *[EMAIL PROTECTED] * *-- *Please see the official ORACLE-L FAQ: http://www.orafaq.com *-- *Author: Kevin Kostyszyn * 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: Patrick Housholder 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 Kostyszyn 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ:
Re: 8.1.6 upgrade
We have done this on several machines without a problem. Don't use the patch on server running Designer 6.5. Bad Mojo. I have an open iTAR with Oracle about this. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation "Kevin Kostyszyn" To: Multiple recipients of list ORACLE-L kevin@dulcia[EMAIL PROTECTED] n.com cc: Sent by: Subject: 8.1.6 upgrade root@fatcity. com 02/28/2001 09:25 AM Please respond to ORACLE-L Hi all, Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I have done exactly what oracle said to do and it appears as though it is missing a .dll and without the installation is hosed. Do you have to upgrade to some other version first? The instance I upgraded was 8.1.6.1, then when it crashed I tried a reinstall and it still gives me the same error. Any help would be great, I see nothing in the documentaition with the patch that says I have to be at anything other than 8.1.6. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: 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: 8.1.6 upgrade
I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to 8.1.6.3.1.. You can get 8.1.6.3.1. at ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat chsets/81631/ I had previously installed a trial version of Savant QDiagnostics, but after de-installing the thing I am left with a QDBA account that cannot be deleted. Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or svrmgrl. I logged a TAR with Oracle, their response was to ask me a dozen questions, as if they haven't seen this before. I created a dummy user, created a table, inserted some records into it, then successfully dropped the table and the user. So I think this has to do with either memory shortage on my test machine, or the QDBA user itself. Perhaps those "compressed" packages it owns in the database. Anyway, I had no apparent problems, except now the Oracle Management Server service refuses to start, it says something like "the environment pointers have changed". I haven't logged a TAR regarding that yet, I have to answer the dozen questions Oracle Support threw at me. Let me know if you find out anything more, we plan to upgrade to 8.1.6 this summer and I have to verify that this version is actually stable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Subject:8.1.6 upgrade Hi all, Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I have done exactly what oracle said to do and it appears as though it is missing a .dll and without the installation is hosed. Do you have to upgrade to some other version first? The instance I upgraded was 8.1.6.1, then when it crashed I tried a reinstall and it still gives me the same error. Any help would be great, I see nothing in the documentaition with the patch that says I have to be at anything other than 8.1.6. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Boivin, Patrice J 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: 8.1.6 upgrade
Check to see if the QDBA account has any jobs set to run. If so, you should break and remove them. It does set up jobs so the chances are good that this is the issue. -Original Message- Sent: Wednesday, February 28, 2001 8:55 AM To: Multiple recipients of list ORACLE-L I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to 8.1.6.3.1.. You can get 8.1.6.3.1. at ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat chsets/81631/ I had previously installed a trial version of Savant QDiagnostics, but after de-installing the thing I am left with a QDBA account that cannot be deleted. Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or svrmgrl. I logged a TAR with Oracle, their response was to ask me a dozen questions, as if they haven't seen this before. I created a dummy user, created a table, inserted some records into it, then successfully dropped the table and the user. So I think this has to do with either memory shortage on my test machine, or the QDBA user itself. Perhaps those "compressed" packages it owns in the database. Anyway, I had no apparent problems, except now the Oracle Management Server service refuses to start, it says something like "the environment pointers have changed". I haven't logged a TAR regarding that yet, I have to answer the dozen questions Oracle Support threw at me. Let me know if you find out anything more, we plan to upgrade to 8.1.6 this summer and I have to verify that this version is actually stable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Subject:8.1.6 upgrade Hi all, Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I have done exactly what oracle said to do and it appears as though it is missing a .dll and without the installation is hosed. Do you have to upgrade to some other version first? The instance I upgraded was 8.1.6.1, then when it crashed I tried a reinstall and it still gives me the same error. Any help would be great, I see nothing in the documentaition with the patch that says I have to be at anything other than 8.1.6. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Boivin, Patrice J 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: Kimberly Smith 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: 8.1.6 upgrade
Title: RE: 8.1.6 upgrade as QDBA do execute q$bgproc.stop_driver; note the results log out, then in as internal drop user qdba cascade; and let us know what happens, OK? -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: 8.1.6 upgrade I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to 8.1.6.3.1.. You can get 8.1.6.3.1. at ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat chsets/81631/ I had previously installed a trial version of Savant QDiagnostics, but after de-installing the thing I am left with a QDBA account that cannot be deleted. Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or svrmgrl. I logged a TAR with Oracle, their response was to ask me a dozen questions, as if they haven't seen this before. I created a dummy user, created a table, inserted some records into it, then successfully dropped the table and the user. So I think this has to do with either memory shortage on my test machine, or the QDBA user itself. Perhaps those compressed packages it owns in the database. Anyway, I had no apparent problems, except now the Oracle Management Server service refuses to start, it says something like the environment pointers have changed. I haven't logged a TAR regarding that yet, I have to answer the dozen questions Oracle Support threw at me. Let me know if you find out anything more, we plan to upgrade to 8.1.6 this summer and I have to verify that this version is actually stable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Subject: 8.1.6 upgrade Hi all, Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I have done exactly what oracle said to do and it appears as though it is missing a .dll and without the installation is hosed. Do you have to upgrade to some other version first? The instance I upgraded was 8.1.6.1, then when it crashed I tried a reinstall and it still gives me the same error. Any help would be great, I see nothing in the documentaition with the patch that says I have to be at anything other than 8.1.6. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Boivin, Patrice J 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: 8.1.6 upgrade
Hi Kevin, We had this exact problem. It is a known issue, according to Oracle "Support". They said it was caused by the following services being left running during the patch: MSDTS, SNMP and IIS Admin Services You need to stop these before applying the patch. Basically you're hosed. I hope it's not production (as it was with us!). The "workaround" is to install /upgrade to 8.1.6.3 on another machine (our DBA used his laptop), and copy all the dll's over. Hope this helps! Jerry - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:11 PM All dlls are showing. If nt can find, why isn't oracle? Is it possible that something in the registry got hosed and it is looking in the wrong spot to execute? -Original Message- Housholder Sent: Wednesday, February 28, 2001 12:52 PM To: Multiple recipients of list ORACLE-L if i remember correctly, on some of the patches for 8.1.6, some of the dlls had an ATTRIB of hidden...make sure to check folder option, show all types...as well as going out to DOS screen...and running ATTRIB *.* patrick === Patrick Housholder Sr. Staff Anl Tech Spt Design United Airlines Flight Training Center Denver CO *-Original Message- *From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin *Kostyszyn *Sent: Wednesday, February 28, 2001 8:26 AM *To: Multiple recipients of list ORACLE-L *Subject: 8.1.6 upgrade * * *Hi all, * Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I *have done *exactly what oracle said to do and it appears as though it is *missing a .dll *and without the installation is hosed. Do you have to upgrade to *some other *version first? The instance I upgraded was 8.1.6.1, then when it *crashed I *tried a reinstall and it still gives me the same error. Any help would be *great, I see nothing in the documentaition with the patch that says I have *to be at anything other than 8.1.6. * *Sincerely, *Kevin Kostyszyn *DBA *Dulcian, Inc *www.dulcian.com *[EMAIL PROTECTED] * *-- *Please see the official ORACLE-L FAQ: http://www.orafaq.com *-- *Author: Kevin Kostyszyn * 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: Patrick Housholder 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 Kostyszyn 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C 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).
QDBA has been banished from my test server (was RE: 8.1.6 upgrade )
Well, that was gruesome. I couldn't log in as QDBA, so forget about using dbms_job. I ended up revoking CONNECT, RESOURCE, and every other role it had. Then I did a shutdown abort, startup restrict. QDBA's job was still listed. I took the risk of issuing a DELETE statement against dba_jobs, and against the job$ view. I don't know if that did anything useful but at least there were no rows returned. I granted connect, resource back to qdba. I bounced the database again. Then I managed to log in as QDBA, and as that user I manually (well, using SQL scripts) dropped all of this user's objects. Then I logged in as SYSTEM and I quite enjoyed deleting this beast from my test machine. Obviously when you issue a DROP USER command, Oracle doesn't do anything to clean up that user's jobs - it just hangs. Live and learn, now I know what to do if this happens again - use a liberal does of REVOKE statements, GRANT again, then log on as that user. Drop everything that user owns manually, because DROP USER is too lazy to do it. Once you have done DROP USER's job for it, you can issue the DROP USER command. Strangely it still took 8i at least ten seconds to drop the user, even though it didn't own anything. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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).
