Re: for security patches - going to 9.2.0.4
We've had to set the _optimizer_features_enabled or whatever back to 8.1.7 and/or _new_initial_join_order (which defaults to true in 9.2.0.4, at least) to false after seeing a lot of problems going from 8.1.7 to 9.2.0.4. It's happened a couple of times, but I'm not sure if it's a trend or not. Mogens Paul Drake wrote: if you have compatible set to 8.1.7, I'll bet that optimizer features from 9.2.0 aren't available. you would have to decide if you want to use the 9.2 CBO or the 8.1.7 CBO. The only reason that I can think of that you'd want to use the 8.1.7 CBO is if your code ran well in 8.1.7 and some statements never finish (or run orders of magnitude slower) in 9.2. Pd */[EMAIL PROTECTED]/* wrote: I was just wondering if setting compatible back to 8.1.7 for the CBO reasons was still necessary? -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of *Paul Drake *Sent:* Friday, December 12, 2003 4:49 PM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: for security patches - going to 9.2.0.4 Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset 9.2.0.4.0 is still a pre-requisite for this, as the one-off patchset for 9.2.0.3.0 is not yet available. As far as setting compatible back to 8.1.7, the key thing is not whether you have locally managed tablespaces, but a locally managed _SYSTEM_ tablespace. just wanted to make that clear. Paul */[EMAIL PROTECTED]/* wrote: That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of *Paul Drake *Sent:* Thursday, December 11, 2003 7:04 PM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed - that is a completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly created db. Paul */[EMAIL PROTECTED]/* wrote: Guys, I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question: -any bugs/problems going to 9.2.0.4 and... -should we really change compatible from 9.X to 8.1.7? We are currently migrating a large database to 9.X and I want to know if I should use the latest
RE: for security patches - going to 9.2.0.4
Title: RE: for security patches - going to 9.2.0.4 Paula, I had also bad experience when we upgraded one of our applications from 8.1.7 to 9.2.0.1 There were some queries that executed significantly slower then on 8.1.7. What we have done was: 1. We gathered system statistics with dbms_system.gather_system_stats. This helps CBO to know on what kind of HW configuration it is running on and also turns on the new cpu costing model. The result were better execution plans. Please read Metalink Note: 153761.1 about system stats. I had also replied to several questions regarding system stats on Metalink and I don't know for a case when gathering system stats caused performance degradation. 2. We have installed the latest patch 9.2.0.4 which among other bugs fixes also some optimizer bugs - some of them are still there ;) . This also solved other performance problems and things were again under control. 3. With manual setting system statistics (see the procedures in dbms_stats package to do that) one can achieve the same execution plans as on 8.1.7 version. If the mreadtim is 1.2 times higher than the sreadtim with a multiblockreadcount (mbrc) set to 8, then the I/O cost part will be equivalent to the Oracle8i I/O cost. I haven't tested this yet (there was no need to do that and besides I currently don't have access to proper environment to do that) but it sounds like setting the OPTIMIZER_INDEX_COST_ADJ in 8i to lower values then default. 4. There are several settings related to CBO's behavior that have changed the default value from false to true in 9iR2. Those are: _b_tree_bitmap_plans = true _complex_view_merging = true _index_join_enabled = true _new_initial_join_orders = true _ordered_nested_loop = true _push_join_predicate = true _push_join_union_view = true _table_scan_cost_plus_one = true _unnest_subquery = true We had several times problems with bitmap conversions for b-tree indexes, so we changed _b_tree_bitmap_plans back to false as it was in 8i. The changed plans without this feature were executing faster. Regards, Joze -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 12, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: for security patches - going to 9.2.0.4 I was just wondering if setting compatible back to 8.1.7 for the CBO reasons was still necessary? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Drake Sent: Friday, December 12, 2003 4:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: for security patches - going to 9.2.0.4 Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset 9.2.0.4.0 is still a pre-requisite for this, as the one-off patchset for 9.2.0.3.0 is not yet available. As far as setting compatible back to 8.1.7, the key thing is not whether you have locally managed tablespaces, but a locally managed _SYSTEM_ tablespace. just wanted to make that clear. Paul [EMAIL PROTECTED] wrote: That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Drake Sent: Thursday, December 11, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed - that is a completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly created db. Paul [EMAIL PROTECTED] wrote: Guys, I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet
RE: for security patches - going to 9.2.0.4
Title: RE: for security patches - going to 9.2.0.4 Thanks so much. This was very well explained and I appreciate the time you took to share it. I will go through the Metalink and read this over and test. Thanks Again, Paula -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Joze SenegacnikSent: Monday, December 15, 2003 6:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, I had also bad experience when we upgraded one of our applications from 8.1.7 to 9.2.0.1 There were some queries that executed significantly slower then on 8.1.7. What we have done was: 1. We gathered system statistics with dbms_system.gather_system_stats. This helps CBO to know on what kind of HW configuration it is running on and also turns on the new cpu costing model. The result were better execution plans. Please read Metalink Note: 153761.1 about system stats. I had also replied to several questions regarding system stats on Metalink and I don't know for a case when gathering system stats caused performance degradation. 2. We have installed the latest patch 9.2.0.4 which among other bugs fixes also some optimizer bugs - some of them are still there ;) . This also solved other performance problems and things were again under control. 3. With manual setting system statistics (see the procedures in dbms_stats package to do that) one can achieve the same execution plans as on 8.1.7 version. If the mreadtim is 1.2 times higher than the sreadtim with a multiblockreadcount (mbrc) set to 8, then the I/O cost part will be equivalent to the Oracle8i I/O cost. I haven't tested this yet (there was no need to do that and besides I currently don't have access to proper environment to do that) but it sounds like setting the OPTIMIZER_INDEX_COST_ADJ in 8i to lower values then default. 4. There are several settings related to CBO's behavior that have changed the default value from false to true in 9iR2. Those are: _b_tree_bitmap_plans = true _complex_view_merging = true _index_join_enabled = true _new_initial_join_orders = true _ordered_nested_loop = true _push_join_predicate = true _push_join_union_view = true _table_scan_cost_plus_one = true _unnest_subquery = true We had several times problems with bitmap conversions for b-tree indexes, so we changed _b_tree_bitmap_plans back to false as it was in 8i. The changed plans without this feature were executing faster. Regards, Joze -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 12, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: for security patches - going to 9.2.0.4 I was just wondering if setting compatible back to 8.1.7 for the CBO reasons was still necessary? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Drake Sent: Friday, December 12, 2003 4:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: for security patches - going to 9.2.0.4 Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset 9.2.0.4.0 is still a pre-requisite for this, as the one-off patchset for 9.2.0.3.0 is not yet available. As far as setting compatible back to 8.1.7, the key thing is not whether you have locally managed tablespaces, but a locally managed _SYSTEM_ tablespace. just wanted to make that clear. Paul [EMAIL PROTECTED] wrote: That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Drake Sent: Thursday, December 11, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2
RE: for security patches - going to 9.2.0.4
That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent: Thursday, December 11, 2003 7:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed- that isa completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly createddb. Paul [EMAIL PROTECTED] wrote: Guys,I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question:-any bugs/problems going to 9.2.0.4 and...-should we really change compatible from 9.X to 8.1.7?We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons?Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactivelyThanks,Paula-- Please! see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing
RE: for security patches - going to 9.2.0.4
Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset 9.2.0.4.0 is still a pre-requisite for this, as the one-off patchset for 9.2.0.3.0 is not yet available. As far as setting compatible back to 8.1.7, the key thing is not whether you have locally managed tablespaces, but a locally managed _SYSTEM_ tablespace. just wanted to make that clear. Paul[EMAIL PROTECTED] wrote: That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent: Thursday, December 11, 2003 7:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed- that isa completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly createddb. Paul [EMAIL PROTECTED] wrote: Guys,I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question:-any bugs/problems going to 9.2.0.4 and...-should we really change compatible from 9.X to 8.1.7?We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons?Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactivelyThanks,Paula-- Please! ! see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing Do you Yahoo!? Free Pop-Up Blocker - Get it now
RE: for security patches - going to 9.2.0.4
I was just wondering if setting compatible back to 8.1.7 for the CBO reasons was still necessary? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent: Friday, December 12, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset 9.2.0.4.0 is still a pre-requisite for this, as the one-off patchset for 9.2.0.3.0 is not yet available. As far as setting compatible back to 8.1.7, the key thing is not whether you have locally managed tablespaces, but a locally managed _SYSTEM_ tablespace. just wanted to make that clear. Paul[EMAIL PROTECTED] wrote: That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent: Thursday, December 11, 2003 7:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed- that isa completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly createddb. Paul [EMAIL PROTECTED] wrote: Guys,I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question:-any bugs/problems going to 9.2.0.4 and...-should we really change compatible from 9.X to 8.1.7?We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons?Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactivelyThanks,Paula-- Please! ! see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing Do you Yahoo!?Free Pop-Up Blocker - Get it now
RE: for security patches - going to 9.2.0.4
if you have compatible set to 8.1.7, I'll bet that optimizer features from 9.2.0 aren't available. you would have to decide if you want to use the 9.2 CBO or the 8.1.7 CBO. The only reason that I can think of that you'd want to use the 8.1.7 CBO is if your code ran well in 8.1.7 and some statements never finish (or run orders of magnitude slower) in 9.2. Pd[EMAIL PROTECTED] wrote: I was just wondering if setting compatible back to 8.1.7 for the CBO reasons was still necessary? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent: Friday, December 12, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset 9.2.0.4.0 is still a pre-requisite for this, as the one-off patchset for 9.2.0.3.0 is not yet available. As far as setting compatible back to 8.1.7, the key thing is not whether you have locally managed tablespaces, but a locally managed _SYSTEM_ tablespace. just wanted to make that clear. Paul[EMAIL PROTECTED] wrote: That is the case. I do have tablespaces that are locally managed - I did the migrate with compatible set to 8.1.7. I did startup the database. However, my system tablespace is dictionary managed - all others are not. The migration worked. I have large databases and have been using Oracle's migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and tricky but better than export/import on large databases. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent: Thursday, December 11, 2003 7:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4 Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed- that isa completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly createddb. Paul [EMAIL PROTECTED] wrote: Guys,I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question:-any bugs/problems going to 9.2.0.4 and...-should we really change compatible from 9.X to 8.1.7?We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons?Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactivelyThanks,Paula-- Please! ! ! see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing Do you Yahoo!?Free Pop-Up Blocker - Get it now Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Downloading patches
Hi, This might be a rudimentary question. I'm trying to download patch 3095277 (9.2.0.4) from windows workstation behind a proxy. Is there any way I can use ftp to download the same rather than using the standard browser based download which seems to be a but slower? Regards Naveen -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 9:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: leaf node 90-10 splits Hi, Tanel, Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang I wonder why does statistic leaf node 90-10 splits imply that right-hand index leaf block is split as 90-10, not 100-0 as it really is. (tested on 9.2.0.4 W2k). Historical reasons? Tanel. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Downloading patches
Nope. Not since oracle killed the ftp server they used (ftp://oracle-ftp.oracle.com). You could have used wget when the ftp server was there. That is the primary reason I had to purchase a cable modem connection. On 12/11/2003 03:54:24 AM, Naveen, Nahata (IE10) wrote: Hi, This might be a rudimentary question. I'm trying to download patch 3095277 (9.2.0.4) from windows workstation behind a proxy. Is there any way I can use ftp to download the same rather than using the standard browser based download which seems to be a but slower? Regards Naveen -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 9:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: leaf node 90-10 splits Hi, Tanel, Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang I wonder why does statistic leaf node 90-10 splits imply that right-hand index leaf block is split as 90-10, not 100-0 as it really is. (tested on 9.2.0.4 W2k). Historical reasons? Tanel. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Downloading patches
Try using updates.oracle.com. -Original Message- Mladen Gogala Sent: Thursday, December 11, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Nope. Not since oracle killed the ftp server they used (ftp://oracle-ftp.oracle.com). You could have used wget when the ftp server was there. That is the primary reason I had to purchase a cable modem connection. On 12/11/2003 03:54:24 AM, Naveen, Nahata (IE10) wrote: Hi, This might be a rudimentary question. I'm trying to download patch 3095277 (9.2.0.4) from windows workstation behind a proxy. Is there any way I can use ftp to download the same rather than using the standard browser based download which seems to be a but slower? Regards Naveen -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 9:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: leaf node 90-10 splits Hi, Tanel, Where do you see this statistic? I only see leaf node splits in 8.1.7 and 9.2 documentation. If the index is on strictly monotonically increasing numbers, won't a new node be added to the right without a block split? Yong Huang I wonder why does statistic leaf node 90-10 splits imply that right-hand index leaf block is split as 90-10, not 100-0 as it really is. (tested on 9.2.0.4 W2k). Historical reasons? Tanel. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Naveen, Nahata (IE10) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jerry Hess INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: for security patches - going to 9.2.0.4
Guys, I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question: -any bugs/problems going to 9.2.0.4 and... -should we really change compatible from 9.X to 8.1.7? We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons? Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactively Thanks, Paula -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: for security patches - going to 9.2.0.4
Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to attach to. But this might be a myth of mine, its awhile since I last read the upgrade/migration guide. I can see setting the init.ora parameter optimizer_features_enable = 8.1.7 if the 9.2 CBO acts quite differently from its older brother did, back in 8.1.7. But compatible? I seriously doubt it. If you migrated your db from 8.1.7 to 9.2 and the system tablespace is still dictionary managed- that isa completely different matter. I've been lucky enough that most dbs were small enough to just use exp/imp and move data into a clean, newly createddb. Paul [EMAIL PROTECTED] wrote: Guys,I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not hit it yet) that in this version we could get locks when building indexes. Also, that basically you need to set your compatible parameter to 8.1.7. On some databases we have compatible set to 9.2.0.0. Question:-any bugs/problems going to 9.2.0.4 and...-should we really change compatible from 9.X to 8.1.7?We are currently migrating a large database to 9.X and I want to know if I should use the latest patchset 9.2.0.4 - for security and performance reasons?Also, we have some dev/test databases where once they go into production performance could be an issue - should we change the compatible param. to 8.1.7 proactivelyThanks,Paula-- Please! see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: patches applied to RDBMS
Yep. Should have read the original question a little closer. Thanks for covering. Lon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 8:44 AM Database technology stack patches aren't recorded in AD_ tables in Apps. Only patches going to APPL_TOP are. And OP probably has just DB anyway. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 9:44 AM select * from ad_bugs usually works unless the patch uses the Runinstaller to install. Is this for a straight database or an Apps installation? Lon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:49 AM Hi All, OS: Solaris 2.8 DB: 8i/9i Is there a way to know whether a patch has been applied to the Oracle RDBMS (except lsinventory). I guess there shouldbe some log/history file that will have this info. but can't re-call now. can somebody through some light. Thanks and Regards, Srinivas __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Lon White INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Lon White INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: patches applied to RDBMS
Database technology stack patches aren't recorded in AD_ tables in Apps. Only patches going to APPL_TOP are. And OP probably has just DB anyway. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 9:44 AM select * from ad_bugs usually works unless the patch uses the Runinstaller to install. Is this for a straight database or an Apps installation? Lon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:49 AM Hi All, OS: Solaris 2.8 DB: 8i/9i Is there a way to know whether a patch has been applied to the Oracle RDBMS (except lsinventory). I guess there shouldbe some log/history file that will have this info. but can't re-call now. can somebody through some light. Thanks and Regards, Srinivas __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Lon White INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
patches applied to RDBMS
Hi All, OS: Solaris 2.8 DB: 8i/9i Is there a way to know whether a patch has been applied to the Oracle RDBMS (except lsinventory). I guess there shouldbe some log/history file that will have this info. but can't re-call now. can somebody through some light. Thanks and Regards, Srinivas __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: patches applied to RDBMS
select * from ad_bugs usually works unless the patch uses the Runinstaller to install. Is this for a straight database or an Apps installation? Lon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 11:49 AM Hi All, OS: Solaris 2.8 DB: 8i/9i Is there a way to know whether a patch has been applied to the Oracle RDBMS (except lsinventory). I guess there shouldbe some log/history file that will have this info. but can't re-call now. can somebody through some light. Thanks and Regards, Srinivas __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Lon White INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Merge patches
You should not have to worry unless each of the patches contains the same object file. In that case the second patch will overwrite that part of the first. But, check the patch note before requesting the patch merge. It may have words to the effect that the second patch contains all the changes belonging to the first. Of course, only apply necessary patches. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 10:59 AM To: Multiple recipients of list ORACLE-L OK, maybe I'm going crazy or senile, but I seem to recall Oracle stating that if you needed to apply more than 1 patch, you would need to request a merge patch. I think this was about a year ago and caused us to downgrade a database to resolve a problem since the turn-around time for the merge patch was not going to beet our requirements. Does anyone else remember this? Are they still doing this or can multiple 1-off patches be applied now? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Merge patches
OK, maybe I'm going crazy or senile, but I seem to recall Oracle stating that if you needed to apply more than 1 patch, you would need to request a merge patch. I think this was about a year ago and caused us to downgrade a database to resolve a problem since the turn-around time for the merge patch was not going to beet our requirements. Does anyone else remember this? Are they still doing this or can multiple 1-off patches be applied now? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Merge patches
Hi! I think most of people here have applied several one-off patches successfully, at least I have. But the issue is, as the name says, the one-off patches are only for fixing a certain bit of behaviour, they havent been tested in heavy-loaded envrionments where they could affect each other. But eventually these one-offs make their way to patchsets, which are stress tested for reliability. So, you are on your own risk when going with multiple one-offs, but in my experience it has worked. Others may have different experience, though.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 11, 2003 8:59 PM OK, maybe I'm going crazy or senile, but I seem to recall Oracle stating that if you needed to apply more than 1 patch, you would need to request a merge patch. I think this was about a year ago and caused us to downgrade a database to resolve a problem since the turn-around time for the merge patch was not going to beet our requirements. Does anyone else remember this? Are they still doing this or can multiple 1-off patches be applied now? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Merge patches
As a general rule, one off patches are applied only at the direct request From oracle support. If you need a silver bullet (merge patch), you have to ask for that. If not, wait for the next patchset. I hear that 9.2.0.4 is just around the corner. -- Mladen Gogala Oracle DBA -Original Message- Tanel Poder Sent: Monday, August 11, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hi! I think most of people here have applied several one-off patches successfully, at least I have. But the issue is, as the name says, the one-off patches are only for fixing a certain bit of behaviour, they havent been tested in heavy-loaded envrionments where they could affect each other. But eventually these one-offs make their way to patchsets, which are stress tested for reliability. So, you are on your own risk when going with multiple one-offs, but in my experience it has worked. Others may have different experience, though.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 11, 2003 8:59 PM OK, maybe I'm going crazy or senile, but I seem to recall Oracle stating that if you needed to apply more than 1 patch, you would need to request a merge patch. I think this was about a year ago and caused us to downgrade a database to resolve a problem since the turn-around time for the merge patch was not going to beet our requirements. Does anyone else remember this? Are they still doing this or can multiple 1-off patches be applied now? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: re RAC -- patches ---- was RE: Recipe for application design
Currently we have installed Installed Patch List:2664929 [ Base Bug(s): 2629652 2320407 2599613 2461455 2590120 2157903 2534430 2515844 2598124 2557893 ]2682180 [ Base Bug(s): 2652771 ] and two more are in the pipeline ... maybe early Jan. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: re RAC -- patches was RE: Recipe for application designRaj,Could you list the patches you applied on top of 9.2.0.2 I've upgraded my test RAC environmentfrom 9.2.0.1 to 9.2.0.2.Hemant This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
re RAC -- patches ---- was RE: Recipe for application design
Raj, Could you list the patches you applied on top of 9.2.0.2 I've upgraded my test RAC environment from 9.2.0.1 to 9.2.0.2. Hemant At 05:48 AM 05-12-02 -0800, you wrote: Boris, the example I gave you is 9012 RAC and I have 5 other production systems that are 9202 RAC. BTW remember if you have cluster_database is true, then no matter how many instances, you will see GC traffic and boy those numbers are crooked .. it is a generic problem hopefully there will be patch for it to fix the GC timing.. I think that advise should have been prefixed with something like ... Following statement is issued so that in case your application fails to scale contrary to our well publicized claim that RAC is extensible and scalable, we can always blame on your not-so-well-thought-rac-incompatible design. This way we will be safe and no one in media can blame us. I am pretty sure it is hidden somewhere ... BTW 9202 ... make sure you get all the patches ... this upgrade is a painful story (at-least for us). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recipe for application design to run on RAC On a more serious note the following guidelines look interesting: http://download-west.oracle.com/docs/cd/A97630_01/rac.920/a96600/migrate.htm#1013313 Migrate to RAC ... unless your application was specifically designed to not use cluster database processing. I wonder why would somebody do that? Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Best practice for backing out of Application Patches
Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Best practice for backing out of Application Patches
Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used during an insert or select statment. If the application does not use the column, then removing it from the table might need to be done. On the other hand, if you are using version 8.1.7, you can always drop the column from the table. If your patches are just updates to schema views, you can always simply e-apply the prior version of the views to back the updates out of the database. see, it all depends on the kind of schema update that was performed. and it can get very complicated when you are talking about foreign keys - literally hundreds of tables could be involved - and you probably do not want to be trying to figure out what got touched by an update. probably the best answer is - to back all database changes out of a schema, perform a database point-in-time restore back to before you applied the patches. if I had your job, and this was a purchased application, this is what I would do. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 03, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Best practice for backing out of Application Patches
Thanks to Thomas Mercadante, Stephen Lee and Rick Cale for their responses. I think it's pretty unanimous that if this needs to be done, I would just restore to the point in time taken right before the patches were installed. Either I could do an export/restore/import or refresh from the production Database (As long as the problem was caught before getting put on the production Database). I just want to be covered from all angles before this application goes into production. Thanks again! -Scott Stefick At 12:14 PM 12/3/02 -0800, you wrote: Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used during an insert or select statment. If the application does not use the column, then removing it from the table might need to be done. On the other hand, if you are using version 8.1.7, you can always drop the column from the table. If your patches are just updates to schema views, you can always simply e-apply the prior version of the views to back the updates out of the database. see, it all depends on the kind of schema update that was performed. and it can get very complicated when you are talking about foreign keys - literally hundreds of tables could be involved - and you probably do not want to be trying to figure out what got touched by an update. probably the best answer is - to back all database changes out of a schema, perform a database point-in-time restore back to before you applied the patches. if I had your job, and this was a purchased application, this is what I would do. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 03, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: patches
Title: Pro*C for Oracle 817 on Win2000? Yechiel, If that's your philosophy, and there are known unpatched bugs in the server software, how can you be 100 percent sure it will stay up? Granted, many of these bugs are esoteric, but not all. I am curious what Oracle Support consultants do when they have a 24x7 contract, with all these patches. Surely they have a list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) [Boivin, Patrice J]-Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Friday, November 29, 2002 3:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: patches We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel AdarMehish - Original Message - From: Boivin, Patrice J To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM Subject: patches I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search,I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)
RE: patches
I think I veer towards Yechiel's view here Patrice. I am not sure I have ever heard anyone suggest applying all outstanding relevant patches to a database however much you test first. (To be honest you are not advocating that, just raising the question). Normal policy wherever I have worked is not to patch unless absolutely necessary. Another point is that 1 patch can provide a new code piece of binary and patches are not cumulative. Therefore applying patch a then patch b could well mean that patch a is overwritten and yet your documentation indicates that it has been installed. HTH John -Original Message- Sent: 02 December 2002 12:54 To: Multiple recipients of list ORACLE-L Yechiel, If that's your philosophy, and there are known unpatched bugs in the server software, how can you be 100 percent sure it will stay up? Granted, many of these bugs are esoteric, but not all. I am curious what Oracle Support consultants do when they have a 24x7 contract, with all these patches. Surely they have a list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) [Boivin, Patrice J] -Original Message- Sent: Friday, November 29, 2002 3:49 AM To: Multiple recipients of list ORACLE-L We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel Adar Mehish - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search, I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: patches
John - Excellent points. Patrice - One factor to consider is that patches tend to be tested very little by the software vendor. Full releases get tested extensively, but even then there are gaps, because well, we wouldn't be having patches otherwise. If you've ever been a developer at a software vendor, what happens is one customer reports an error. You verify the error and create a patch to fix that specific error. But no comprehensive system testing is done. You ship that patch to fix that problem. Sometimes a vendor will bundle a group of patches together into a patch bundle. Here the testing is much more extensive than for the single patch, but still far short of the extensive full release testing. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 02, 2002 7:44 AM To: Multiple recipients of list ORACLE-L I think I veer towards Yechiel's view here Patrice. I am not sure I have ever heard anyone suggest applying all outstanding relevant patches to a database however much you test first. (To be honest you are not advocating that, just raising the question). Normal policy wherever I have worked is not to patch unless absolutely necessary. Another point is that 1 patch can provide a new code piece of binary and patches are not cumulative. Therefore applying patch a then patch b could well mean that patch a is overwritten and yet your documentation indicates that it has been installed. HTH John -Original Message- Sent: 02 December 2002 12:54 To: Multiple recipients of list ORACLE-L Yechiel, If that's your philosophy, and there are known unpatched bugs in the server software, how can you be 100 percent sure it will stay up? Granted, many of these bugs are esoteric, but not all. I am curious what Oracle Support consultants do when they have a 24x7 contract, with all these patches. Surely they have a list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) [Boivin, Patrice J] -Original Message- Sent: Friday, November 29, 2002 3:49 AM To: Multiple recipients of list ORACLE-L We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel Adar Mehish - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search, I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: patches
Title: Pro*C for Oracle 817 on Win2000? We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel AdarMehish - Original Message - From: Boivin, Patrice J To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM Subject: patches I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search,I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)
patches
Title: Pro*C for Oracle 817 on Win2000? I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search,I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)
RE: patches
-Original Message- I am wondering how your sites handle patching production servers. We make a copy of the existing product directory structure using tar (everyone else) or cpio (me) before installing the patch. For example: cd /path/path/product/8.1.7 find . -print | cpio -pvmud /some/backup/directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
No patches to install
Hi DBA's i'm trying to do upgrade the 8.1.7 to 8.1.7.3 and when i start the runInstaller, appers the message "There are no patches to install...". I missed my orainventory. How can i do the upgrade now? Thanks. Adriano
Re: No patches to install
You need a valid oraInventory. One way would be to install 8.1.7.0 binaries again and then the patch. I dunno if the hostname is stored - you could try dragging one from another machine (assuming the locations etc are the same) hth connor --- Adriano Freire [EMAIL PROTECTED] wrote: Hi DBA's i'm trying to do upgrade the 8.1.7 to 8.1.7.3 and when i start the runInstaller, appers the message There are no patches to install I missed my orainventory. How can i do the upgrade now? Thanks. Adriano = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: No patches to install
Start the Installer and check on previously installed Oracle products. If the Oracle Inventory file is bad or does not show any installed 8.1.7 product, then you will have to re-install the 8.1.7 version over the existing one, then you can install the patches (8.1.7.4 is the latest). Start the Installer and check on previously Oracle products. RWB Adriano Freire [EMAIL PROTECTED]@fatcity.com on 08/27/2002 12:33:28 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi DBA's i'm trying to do upgrade the 8.1.7 to 8.1.7.3 and when i start the runInstaller, appers the message There are no patches to install I missed my orainventory. How can i do the upgrade now? Thanks. Adriano -- 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: No patches to install
Thanks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 2:58 PM You need a valid oraInventory. One way would be to install 8.1.7.0 binaries again and then the patch. I dunno if the hostname is stored - you could try dragging one from another machine (assuming the locations etc are the same) hth connor --- Adriano Freire [EMAIL PROTECTED] wrote: Hi DBA's i'm trying to do upgrade the 8.1.7 to 8.1.7.3 and when i start the runInstaller, appers the message There are no patches to install I missed my orainventory. How can i do the upgrade now? Thanks. Adriano = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Adriano Freire 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).
OS patches required by Oracle
Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: OS patches required by Oracle
Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, May 21, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject:OS patches required by Oracle Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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:RE: OS patches required by Oracle
You be right!! Dick Goulet Reply Separator Author: Karniotis; Stephen [EMAIL PROTECTED] Date: 5/21/2002 11:22 AM Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, May 21, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: Windows Patches and Oracle
I would be curious to see what answers you got, Lisa. There is another fun utility at http://windowsupdate.microsoft.com, which assesses what Microsoft patches you need, and happily installs them in one batch for you, then all you have to do is reboot. I *think* it lets you download the individual hotfixes individually, but not sure. 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] -Original Message- Sent: Monday, April 22, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Subject:OT: Windows Patches and Oracle Hello everyone, I asked our sysadmin to keep me updated on all OS patches he plans to apply to our test and production servers, to allow ample testing and research prior to implementation in production. (Testing patches is a new idea to him.) Below is a list of all the patches he wants to install. I already nixed having IIS on this server - who needs the headache?? I am now questioning the need for DirectX and .NET. I am not going to argue with him over the security patches, but can someone verify that DirectX and .NET indeed are extraneous to a server that is dedicated to running an Oracle database? I just want to keep this server as clean as possible and I feel like a ton of useless windows crap is ending up on it, taking up disk and resources. However, I can't confirm that. I am borderline clueless when it comes to Windows. To keep traffic down, please reply to me directly. Thank you very much... Q319733: Internet Information Services Security Roll-up Package Q311967: Security Update Security Update, March 28, 2002 (Internet Explorer 5.01 SP2) Security Update, March 7, 2002 Security Update, March 4, 2002 Security Update, February 22, 2002 Security Update, February 14, 2002 (Internet Explorer 5.01) Security Update, February 12, 2002 Security Update, November 20, 2001 Windows 2000 Security Rollup Package, January, 2002 Windows 2000 Service Pack 2 Microsoft Internet Explorer 6 Q318593: Security Update (Windows 2000 Domain Controller) COM+ Rollup Package 18.1 Euro Conversion Tool Windows Critical Update Notification 3.0 Microsoft .NET Framework DirectX 8.1 Root Certificates Update Internet Explorer Error Reporting Windows 2000 Compatibility Updates High Encryption Pack for Windows 2000 Security Update, March 28, 2002 (Internet Explorer 6) Microsoft .NET Framework Service Pack 1 (English) Security Update, February 14, 2002 (Internet Explorer 6) Security Update, February 13, 2002 (MSXML 3.0) Lisa Koivu Oracle Database Batgirl. Fairfield Resorts, Inc. Ft. Lauderdale, FL, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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).
OT: Windows Patches and Oracle
Hello everyone, I asked our sysadmin to keep me updated on all OS patches he plans to apply to our test and production servers, to allow ample testing and research prior to implementation in production. (Testing patches is a new idea to him.) Below is a list of all the patches he wants to install. I already nixed having IIS on this server - who needs the headache?? I am now questioning the need for DirectX and .NET. I am not going to argue with him over the security patches, but can someone verify that DirectX and .NET indeed are extraneous to a server that is dedicated to running an Oracle database? I just want to keep this server as clean as possible and I feel like a ton of useless windows crap is ending up on it, taking up disk and resources. However, I can't confirm that. I am borderline clueless when it comes to Windows. To keep traffic down, please reply to me directly. Thank you very much... Q319733: Internet Information Services Security Roll-up Package Q311967: Security Update Security Update, March 28, 2002 (Internet Explorer 5.01 SP2) Security Update, March 7, 2002 Security Update, March 4, 2002 Security Update, February 22, 2002 Security Update, February 14, 2002 (Internet Explorer 5.01) Security Update, February 12, 2002 Security Update, November 20, 2001 Windows 2000 Security Rollup Package, January, 2002 Windows 2000 Service Pack 2 Microsoft Internet Explorer 6 Q318593: Security Update (Windows 2000 Domain Controller) COM+ Rollup Package 18.1 Euro Conversion Tool Windows Critical Update Notification 3.0 Microsoft .NET Framework DirectX 8.1 Root Certificates Update Internet Explorer Error Reporting Windows 2000 Compatibility Updates High Encryption Pack for Windows 2000 Security Update, March 28, 2002 (Internet Explorer 6) Microsoft .NET Framework Service Pack 1 (English) Security Update, February 14, 2002 (Internet Explorer 6) Security Update, February 13, 2002 (MSXML 3.0) Lisa Koivu Oracle Database Batgirl. Fairfield Resorts, Inc. Ft. Lauderdale, FL, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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: patches for 8.1.7
8.1.7.3 is the latest patch. hth connor --- sarath kumar [EMAIL PROTECTED] wrote: Hai, i have to move my 7.3.4 database to 8.1.7. what are the patches i need to apply once i move to 8.1.7. The OS is SUN SPARC 2.6 TIA Srinivas __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sarath kumar 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
patches for 8.1.7
Hai, i have to move my 7.3.4 database to 8.1.7. what are the patches i need to apply once i move to 8.1.7. The OS is SUN SPARC 2.6 TIA Srinivas __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sarath kumar 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: applications patches
Title: applications patches I wouldn't try it. It could be a Client side patch. When searching Metalink put in your client hardware not your server hardware and see if you see the patch then. If not call support. -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, November 19, 2001 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: applications patches I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I can find it. Any Applications DBAs out there care to comment on the danger of appliying the former without first applying the latter? matt Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi." - Larry Wall (creator of Perl)
applications patches
Title: applications patches I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I can find it. Any Applications DBAs out there care to comment on the danger of appliying the former without first applying the latter? matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
Re: applications patches
Reread the patch readme.txt. The 2092683 is a prereq that is included in 2094819. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] MATT.ADAMS@AP PL.GE.COMTo: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: applications patches com 11/19/01 09:45 AM Please respond to ORACLE-L I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I can find it. Any Applications DBAs out there care to comment on the danger of appliying the former without first applying the latter? matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas 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: applications patches
Best to open a TAR and have Oracle support tell you what the required patches are. Patch information may not be on MetaLink. -Original Message- Sent: Monday, November 19, 2001 8:45 AM To: Multiple recipients of list ORACLE-L I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I can find it. Any Applications DBAs out there care to comment on the danger of appliying the former without first applying the latter? matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo 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: applications patches
Hi Matt, 'Patching' is the bane of the Oracle Applications world and not to be taken lightly. As for the question, you will not be able to apply the patch without previously having installed it's dependencies. Btw, which version of Apps are you at? Break out the docs - you are going to need them! (Help is also available in the form of another Listserv at www.oaug.net http://www.oaug.net - look for the OAUGnet-DBA List). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, November 19, 2001 8:45 AM To: Multiple recipients of list ORACLE-L I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I can find it. Any Applications DBAs out there care to comment on the danger of appliying the former without first applying the latter? matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: applications patches
Title: RE: applications patches Whoops... Ron is right. I read the readme.txt file too fast. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: applications patches Reread the patch readme.txt. The 2092683 is a prereq that is included in 2094819. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] MATT.ADAMS@AP PL.GE.COM To: [EMAIL PROTECTED] Sent by: cc: root@fatcity. Subject: applications patches com 11/19/01 09:45 AM Please respond to ORACLE-L I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I can find it. Any Applications DBAs out there care to comment on the danger of appliying the former without first applying the latter? matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas 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).
Patches for 8.1.5
Does anyone know where I can get the patches for 8.1.5? I can't find them on OTN. Thanks, Kenneth C. Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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).
Oracle Applications patches
I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). 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] -- 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: Oracle Applications patches
Never mind, I discovered the maintenance updates... I have a way to go with this, can you tell? : ) 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: Boivin, Patrice J Sent: Tuesday, August 28, 2001 11:30 AM To: '[EMAIL PROTECTED]' Subject:Oracle Applications patches Importance: Low I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). 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] -- 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: Oracle Applications patches
Dear Patrice, The megapatches are worth installing, since they fix lots of bugs. There is a pulldown list in the patch getter screen that lets you ask for all megapatches or similar. Also check the release notes to see if there are any interoperability patches. (Interops let this version of Apps work with that version of Server, etc. all down the technology stack UGGG!) Have you dicided which products to install? That will tighten up the list! US Payroll has a lot of patches as the legislatures of the 50 states and numerous municipalities create scope creep (however it keeps people employed to apply the resulting patches). -Original Message- Sent: Tuesday, August 28, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). 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] -- 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: Shreter, Hilary 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: Oracle Applications patches
Patrice, Welcome to the wonderful and exciting world of Apps patches! Are some more critical than others? Yes, but it largely depends on the extent you're using the system. Generally, I don't bother with minor patches unless a specific bug is stumbled upon. If you roll with the mega patches, you're pretty much covered. Btw, the separate application modules (AR, GL, etc) don't have to be at the same patch level - this makes for even more fun. I'm speaking from Apps 11.0 experience, so YMMV. Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice J Sent: Tuesday, August 28, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). 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] -- 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: Gary Weber 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: Oracle Applications patches
Title: RE: Oracle Applications patches I presume that is 500 per module and there must be about 30 modules by now, with perhaps an average of 7 or 8 modules on each installation The normal method is to install a full patchset which is a collection of a number of patches (i.e GL Patchset J etc). At sites where I have worked adding a patch is usually the last resort and it has to be a significant problem before the patch is applied. A new patchset install normally involves a lot of testing if there has been any form of customisation of the application. Adpatch will become your best friend :) John -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: 28 August 01 16:37 To: Multiple recipients of list ORACLE-L Subject: Oracle Applications patches I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). 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] -- 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: List of installed patches?
That is to see the releases of any products installed. Therefore you can only see the patchset applied. And comes with 7.X and 8.0.X, not with 8.1.X. Also the script is called inspdver not inspdvers. And finally the script is in OH/orainst. Regards. --- Gene Sais [EMAIL PROTECTED] wrote: There used to be a command under OH/bin called inspdvers. [EMAIL PROTECTED] 07/12/01 02:31PM You have the Oracle script owhat or the command what. However most of the times it doesn't work this way. Therefore you must identify the library that was applied. With the library you get the object file. This can be done with the README.bug number. Then issue an: ar -xv library file object file Compare the two sizes of the object file. If they have the same size, you win. Regards. --- Glenn Travis [EMAIL PROTECTED] wrote: How can I find out what patches are installed in my Oracle Installation? (I searched metalink, but only found references to Oracle Apps). Oracle 8.1.6 Sun Sparc Solaris 8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Gene Sais 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: List of installed patches?
I guess what I was looking for was something in the equivalent to 'showrev -p' in solaris, but for Oracle patches. I just installed the patch for the Oracle Listener buffer overflow security problem (patch 1859654), and wanted to confirm it was there. I guess what I really want is to be able to log in to a foreign system (say I was just hired) and see what rev level and patches are installed for Oracle. My 8.1.6.3 patch is definately in the /xxx/app/oracle/oraInventory/PatchSets/oracle.server.patchset directory but the /xxx/app/oracle/oraInventory/Patches is ambiguous at best. I guess I wish 'select * from v$version' would say more... about patches that is. -Original Message- Sent: Thursday, July 12, 2001 1:29 PM To: LazyDBA.com Discussion If U are looking for PatchSets applied on DB then look into /u01/app/oracle/oraInventory/PatchSets/oracle.server.patchset else for other patches U might look into /u01/app/oracle/oraInventory/Patches HTH Ankur Shah Oracle DBA DHR-GA - Original Message - To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 12:35 PM How can I find out what patches are installed in my Oracle Installation? (I searched metalink, but only found references to Oracle Apps). Oracle 8.1.6 Sun Sparc Solaris 8 Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit 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 [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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).
List of installed patches?
How can I find out what patches are installed in my Oracle Installation? (I searched metalink, but only found references to Oracle Apps). Oracle 8.1.6 Sun Sparc Solaris 8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: List of installed patches?
You have the Oracle script owhat or the command what. However most of the times it doesn't work this way. Therefore you must identify the library that was applied. With the library you get the object file. This can be done with the README.bug number. Then issue an: ar -xv library file object file Compare the two sizes of the object file. If they have the same size, you win. Regards. --- Glenn Travis [EMAIL PROTECTED] wrote: How can I find out what patches are installed in my Oracle Installation? (I searched metalink, but only found references to Oracle Apps). Oracle 8.1.6 Sun Sparc Solaris 8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: List of installed patches?
There used to be a command under OH/bin called inspdvers. [EMAIL PROTECTED] 07/12/01 02:31PM You have the Oracle script owhat or the command what. However most of the times it doesn't work this way. Therefore you must identify the library that was applied. With the library you get the object file. This can be done with the README.bug number. Then issue an: ar -xv library file object file Compare the two sizes of the object file. If they have the same size, you win. Regards. --- Glenn Travis [EMAIL PROTECTED] wrote: How can I find out what patches are installed in my Oracle Installation? (I searched metalink, but only found references to Oracle Apps). Oracle 8.1.6 Sun Sparc Solaris 8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Gene Sais 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).
FW: [Fwd: [ISN] Oracle patches high-risk security hole]
Fyi 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 Subject:[ISN] Oracle patches high-risk security hole Date: Fri, 6 Jul 2001 02:32:18 -0500 (CDT) From: InfoSec News [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://investor.cnet.com/investor/news/newsitem/0-9900-1028-6469566-0.html?t ag=ats http://investor.cnet.com/investor/news/newsitem/0-9900-1028-6469566-0.html? tag=ats By: Stephen Shankland 7/5/01 4:40 PM Source: News.com Researchers have found a security hole in Oracle's 8i database program that could let an outside attacker take over the software and-in the case of a Windows computer-the entire system. Researchers at Covert Labs, part of Network Associates' PGP Security group, discovered the vulnerability and ranked its risk as high. Oracle has acknowledged the problem, fixed it in the newest 9i version of its software and issued a patch for the earlier releases. This is a pretty significant vulnerability for Oracle users, said Jim Magdych, security research manager for PGP Security. The problem occurs in a part of Oracle's database software called the listener, which handles communications between people using the database and the database itself, Magdych said. The attack works by sending more information than the software expects, a process called a buffer overrun. In a buffer overrun attack, the extra characters are written into the computer's memory. A clever attacker can place commands in just the right patch of memory to make the computer's chip run a program that can be used to give access to the attacker, Magdych said. What the attacker does next varies according to what type of system has been compromised. In the case of the Oracle security hole, the attacker would have access privileges to the database itself, granting him permission to view or change any information in the database. Oracle runs with very broad powers on a Windows system, so an attacker there would have complete control over the system, Magdych said. Oracle has narrower powers running under the Unix operating system, but the Oracle permission would be a useful foot in the door for further attacks that could lead to complete control, he said. Covert Labs has a staff of about six scouring software commonly used on the Internet, Magdych said. Earlier this year, the team discovered several serious problems with Berkeley Internet Name Domain (BIND), widely-used software that links a computer's numerical Internet address with its URL. ISN is hosted by SecurityFocus.com --- To unsubscribe email [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).
Yet more info on the patches for the listener security bugs
Hi All! This affects only the homes for any running listeners. PSE's (patchset exceptions) 1489683, 1656431 and 1814117 were withdrawn so that they could be combined into a single PSE. Listed below are the PSE place holder patch #'s for each of the different supported releases. Some PSE's are not yet available (e.g. 8.1.7.0), but when available they will be under the patch #'s listed below. The same patch # is used for all platforms on that release. Version Patch # 8.1.7.1 1859604 8.1.7.0 1859628 8.1.6.3 1859654 8.1.6.2 1859778 8.1.6.1 1859788 8.1.6.0 1859791 8.0.6.3 TBA To access the patches via MetaLink: Patches Click on the flashing red link for new patches Enter one of the above patch #'s If you want to limit your search to a specific platform then select it from the drop down list, otherwise all platforms will be shown Click on submit Scroll down to find the appropriate patch for your OS Due to the nature of Windows NT/Windows 2000, PSE's are not available and require a full 5-digit patchset release. The 8.1.7.1.4 patchset will contain the fixes for PSE 1859604. To access the 8.1.7.1.4 patchset, when it is available, from MetaLink: Patches Click on the flashing red link for new patches Product:RDBMS Server Release:8.1.7.1 (if you select a release that is not currently available, no patches will be found) Platform: MS Windows NT/2000 Ser If you applied one of the earlier PSE's, you don't have to deinstall it before applying one of the above PSE's. The following alerts document the various listener bugs and their respective patches (same as the list above): Note: 151259.1 ALERT: Buffer Overflow Vulnerability in the Oracle8i Listener Note: 151260.1 ALERT: Oracle SQL*Net and Net8 Malformed Packet Denial of Service Vulnerability Note: 151261.1 Oracle Net8 Denial of Service Vulnerabilities - Offset_to_data Value Too Large Note: 151290.1 Net8 Denial of Service Vulnerabilities - Requester_version Value Incorrect Note: 151291.1 Net8 Denial of Service Vulnerabilities - Maximum Transport Data Size Too Small Note: 151292.1 Oracle Net8 Denial of Service Vulnerabilities - Fragmentation Attack HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
Replacement patches for listener security bugs 1656431 and 1814117
Hi all! The following replacement PSE's for listener security bugs 1656431 and 1814117 are available on metalink: For 8.1.7.1: 1859604 For 8.1.6.3: 1859654 These are the only replacement PSE's of which I'm aware, but I expect that replacement PSE's for different releases and OS's will be forthcoming. To download these patches from metalink: Select Patches from the left hand menu Click on the red == Click here for Patches released after February 19, 2001 and for all Application Patches. link Enter one of the above patch #'s You must have the appropriate patchset applied. For example PSE 1859654 can be applied only to 8.1.6.3.0. If you are running an earlier version of 8.1.6 you must wait for the PSE for your version to be released or apply the 8.1.6.3.0 patchset first. For those of you running 64-bit Oracle versions that 8.1.6.3.x patchset released, you must wait for the PSE for your specific 5-digit patchset (i.e you cannot apply the PSE for 64-bit 8.1.6.3.0 to a db running 8.1.6.3.1). HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: Replacement patches for listener security bugs 1656431 and 1814117
On Mon, Jul 02, 2001 at 09:45:29AM -0800, A. Bardeen wrote: To download these patches from metalink: Select Patches from the left hand menu Click on the red == Click here for Patches released after February 19, 2001 and for all Application Patches. link Enter one of the above patch #'s -- The patch is not in tar.Z format, even for unix systems. The 8.1.6.3.0 instructions don't mention any constraints. The script warns you: This procedure assumes that: - Your current working directory /db03/app/oracle/product/8.1.6/patches/1788961 is where you have restored this patch archive to. - You have read the README.* file. - You have at least 120 Mb available in the following filesystem. /db03/app/oracle/product/8.1.6 - You have at least 39 Mb available in following filesystem /db03/app/oracle/product/8.1.6/lib - You have shutdown all database instances under this ORACLE_HOME before running this script. - YOU WILL NOT INTERRUPT THIS PROCEDURE! Are you ready to continue? [N] = y Installation is smooth. However, if you don't adhere to the above, my guess is you will blow several toes off. It would be nice if the readme mentioned this up front. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Oracle Security Bugs./ Patches Requires Passwords
I went to Metalink to obtain the patch. Path finding for Oracle can be a pain. Some patches you find by filling in the plaform and product information on the first patch download screen, some you find on oracle-ftp, and some you find by clicking on the Click here for Patches released after February 19, 2001 and for all Application Patches. link. For this bug the last choice was correct. If you have multiple databases at sundry release levels you need to find the patch for each of those levels. Each patch is protected by a different password. I wanted the patches for 8.1.7.1 and 8.1.6.3 so I needed two passwords. I phoned Oracle support and had them email the passwords which expire in seven days. When did this password requirement start? Has a new Customer Aggravation Department been formed at Redwood Shores? Oracle knows I'm entitled to the patch because I'm already on Metalink. The analyst I talked to was quite sympathetic. He had just dealt with a customer that needed 11 patches and 11 different passwords. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 28, 2001 7:07 AM To: Multiple recipients of list ORACLE-L Team, My Network Manager sent me this URL that has some interesting information about some security issues with Oracle. http://www.theregister.co.uk/content/8/19881.html ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: MacGregor, Ian A. 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).
Oracle Patches
Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc. ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Oracle Patches
try oracle-ftp.us.oracle.com -Daniel -Original Message- Jahnke Sent: Wednesday, April 11, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc. ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Daniel Harron 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: Oracle Patches
Hi, Stefan , try this ftp://oracle-ftp.oracle.com/server/ HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc. ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Vadim Gorbounov 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.7 Patches
I don't believe there is a patch yet. I am waiting for it so they can fix that wonderful cursor_sharing bug that has been around since 8.1.6. Kev -Original Message- [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Metalink shows that there is no patch available for 8.1.7 on NT. Is that correct or am I needing a vacation? I hate to be cynical, but an Oracle product with no patch for 3 months? This I find hard to believe. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation -- 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). -- 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).
RE: 8.1.7 Patches
Oracle8 8.1.7.0.2 Patch is on metalink... it's sql*net patch... * i could not find 8.1.7.0.1 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, March 21, 2001 3:37 PM *To: Multiple recipients of list ORACLE-L *Subject: RE: 8.1.7 Patches * * *I don't believe there is a patch yet. I am waiting for it so they can fix *that wonderful cursor_sharing bug that has been around since 8.1.6. *Kev * *-Original Message- *[EMAIL PROTECTED] *Sent: Wednesday, March 21, 2001 4:30 PM *To: Multiple recipients of list ORACLE-L * * *Metalink shows that there is no patch available for 8.1.7 on NT. Is that *correct or am I needing a vacation? I hate to be cynical, but an Oracle *product with no patch for 3 months? This I find hard to believe. * *Todd Carlson *Oracle 8 8i Certified DBA *Bunge Corporation * *-- *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). * *-- *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).
RE: 8.1.7 Patches
Todd, I think you may need a vacation. There are 8.1.7 patches on NT 8.1.7.0.1 and 8.1.7.0.2 (SQLNET Patches) Do a search on Metablink for all NT patches and you will see a few for Oracle 8.1.7. Suhen Metalink shows that there is no patch available for 8.1.7 on NT. Is that correct or am I needing a vacation? I hate to be cynical, but an Oracle product with no patch for 3 months? This I find hard to believe. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather 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.7 Patches
Todd, Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the latest patch AFAIK. Scott Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. -Original Message- Sent: Wednesday, March 21, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Metalink shows that there is no patch available for 8.1.7 on NT. Is that correct or am I needing a vacation? I hate to be cynical, but an Oracle product with no patch for 3 months? This I find hard to believe. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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.7 Patches
Todd, Sorry, I spoke too soon, we are patching to 8.1.7.0.2 on NT MetaBlurb Quote about 8.1.7.1 "No date on Windows NT, it is still listed as delayed HP-UX 3/23/01 AIX 3/23/01 Compaq 3/16/01 " Sorry about the disinformation. Scott -Original Message- Sent: Wednesday, March 21, 2001 4:57 PM To: '[EMAIL PROTECTED]' Todd, Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the latest patch AFAIK. Scott Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. -Original Message- Sent: Wednesday, March 21, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Metalink shows that there is no patch available for 8.1.7 on NT. Is that correct or am I needing a vacation? I hate to be cynical, but an Oracle product with no patch for 3 months? This I find hard to believe. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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).
Fw: Applying patches - minimizing database down time
- Original Message - To: [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 8:52 PM Steve, Seems like a fast, secure procedure. One question though, Why would you issue the 'shutdown abort' in step 5 ? You never quite know how long instance recovery will take. Someone mentioned replication. It seems that a standby db might be worth taking a look at. A lot of work building, cutting over, and rebuilding, but may result in minimum downtime. dgm - Original Message - From: Elliott, Patrick [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 4:15 PM Subject: RE: Applying patches - minimizing database down time Do you have a test instance to apply the patches to? Check the release notes, and see if any DDL is included in the patch. If none of the database objects change, then you do not need to run the rdbms scripts. Also, I have heard that you cannot copy oracle homes any more with the new "Universal" installer. You have to reinstall the base software to the new directory. It keeps track of the directory it is installed in and will not run out of a new directory. -Original Message- From: Steve Orr [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time Yeah, I like the theory but putting the theory into practice is another story. Maybe I'll try it another day. I thought Oracle supported 24X7 Internet ecommerce. Well I guess it does if you never need to upgrade, as if that were a realistic option. Or if you want to work 80+ hours to reduce database down time from 1 hour to 5 minutes. "Patches? We don't need no stinkin' patches!" L.E. Returning to Dog Patch, Lil' Abner -Original Message- Patrick Sent: Thursday, February 08, 2001 12:21 PM To: Multiple recipients of list ORACLE-L You might consider cloning your database, and then using logminer to extract the changes to the production database that occur during the upgrade to the cloned database. The sql extracted from the logs using logminer can then be run against the upgraded clone after shutting down production and before letting the users loose on the database. Of course you will want to do this at a time of low update/delete activity to minimize the time that it will take to execute the sql on the upgraded clone. I have not actually done this, but in theory it should work. Look into the documentation for logminer. -Original Message- From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time (Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery sh
RE: Applying patches - minimizing database down time
Look again at step 5. The sequence is: alter system checkpoint; shutdown abort; startup; shutdown immediate; The theory is that the checkpoint may take awhile but the database is still available. Then the shutdown abort - startup - shutdown immediate sequence get's us to a consistent state as required by the Oracle patch instructions. Comments? -Original Message- Sent: Friday, February 09, 2001 2:11 PM To: Multiple recipients of list ORACLE-L - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 8:52 PM Steve, Seems like a fast, secure procedure. One question though, Why would you issue the 'shutdown abort' in step 5 ? You never quite know how long instance recovery will take. Someone mentioned replication. It seems that a standby db might be worth taking a look at. A lot of work building, cutting over, and rebuilding, but may result in minimum downtime. dgm - Original Message - Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr 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).
Applying patches - minimizing database down time
Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr 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: Applying patches - minimizing database down time
(Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr 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: Molina, Gerardo 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: Applying patches - minimizing database down time
Do you have a test instance to apply the patches to? Check the release notes, and see if any DDL is included in the patch. If none of the database objects change, then you do not need to run the rdbms scripts. Also, I have heard that you cannot copy oracle homes any more with the new "Universal" installer. You have to reinstall the base software to the new directory. It keeps track of the directory it is installed in and will not run out of a new directory. -Original Message- From: Steve Orr [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time Yeah, I like the theory but putting the theory into practice is another story. Maybe I'll try it another day. I thought Oracle supported 24X7 Internet ecommerce. Well I guess it does if you never need to upgrade, as if that were a realistic option. Or if you want to work 80+ hours to reduce database down time from 1 hour to 5 minutes. "Patches? We don't need no stinkin' patches!" L.E. Returning to Dog Patch, Lil' Abner -Original Message- Patrick Sent: Thursday, February 08, 2001 12:21 PM To: Multiple recipients of list ORACLE-L You might consider cloning your database, and then using logminer to extract the changes to the production database that occur during the upgrade to the cloned database. The sql extracted from the logs using logminer can then be run against the upgraded clone after shutting down production and before letting the users loose on the database. Of course you will want to do this at a time of low update/delete activity to minimize the time that it will take to execute the sql on the upgraded clone. I have not actually done this, but in theory it should work. Look into the documentation for logminer. -Original Message- From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:RE: Applying patches - minimizing database down time (Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Re: Applying patches - minimizing database down time
Steve, Seems like a fast, secure procedure. One question though, Why would you issue the 'shutdown abort' in step 5 ? You never quite know how long instance recovery will take. Someone mentioned replication. It seems that a standby db might be worth taking a look at. A lot of work building, cutting over, and rebuilding, but may result in minimum downtime. dgm - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 4:15 PM Do you have a test instance to apply the patches to? Check the release notes, and see if any DDL is included in the patch. If none of the database objects change, then you do not need to run the rdbms scripts. Also, I have heard that you cannot copy oracle homes any more with the new "Universal" installer. You have to reinstall the base software to the new directory. It keeps track of the directory it is installed in and will not run out of a new directory. -Original Message- From: Steve Orr [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time Yeah, I like the theory but putting the theory into practice is another story. Maybe I'll try it another day. I thought Oracle supported 24X7 Internet ecommerce. Well I guess it does if you never need to upgrade, as if that were a realistic option. Or if you want to work 80+ hours to reduce database down time from 1 hour to 5 minutes. "Patches? We don't need no stinkin' patches!" L.E. Returning to Dog Patch, Lil' Abner -Original Message- Patrick Sent: Thursday, February 08, 2001 12:21 PM To: Multiple recipients of list ORACLE-L You might consider cloning your database, and then using logminer to extract the changes to the production database that occur during the upgrade to the cloned database. The sql extracted from the logs using logminer can then be run against the upgraded clone after shutting down production and before letting the users loose on the database. Of course you will want to do this at a time of low update/delete activity to minimize the time that it will take to execute the sql on the upgraded clone. I have not actually done this, but in theory it should work. Look into the documentation for logminer. -Original Message- From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time (Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sq
