RE: Upgrade Question
FWIW : Here is what we have been doing to keep a tab on this oraInventory stuff and make 8.1.6, 8.1.7, 9.0.1 releases work on the same server with their respective patches etc. 1) Keep a separate oraInst.loc file for each release, by renaming it (oraInst.loc.816, oraInst.loc.817 etc) so that there is none with default name (oraInst.loc). 2) Prior to installing Oracle s/w, we set ORACLE_BASE to ORACLE_HOME, so that the oraInventory directory for that release is created in the respective ORACLE_HOME. By default it is created in ORACLE_BASE. (As Ron mentioned, there is a Note on Metalink about this. I forget the Note#. Sorry.) 3) Prior to patching a particular Oracle release, we rename the corresponding oraInst.loc.NNN file to the default name (oraInst.loc), set ORACLE_BASE to ORACLE_HOME, run Installer to apply the patch. Also, we create the 'oui' directory within the respective ORACLE_HOME. We let the Java VM stuff take Oracle's defaults. This process adds more work in the steps while applying patch sets. And we do need to *remember* to follow this process. But is has been working fine without any problems. We came up with this process when our patching of 8.1.6.2 aborted for some reason, but it left the oraInventory directory in a corrupted state and prevented me from re-running the patching process. Per Oracle Support, the corruption in oraInventory directory structures is irreparable, and I had to install 8.1.6.0 and start again. Hope this helps... Regards, - Kirti -Original Message- Sent: Monday, June 03, 2002 8:09 PM To: Multiple recipients of list ORACLE-L You said: There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the Not necessarily (and not recommended). It is very easy to setup an orainventory file for each installation. Check metalink for details. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. stuff deleted -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Upgrade Question
Ron, Thanks for replay, But still don't know what I have to do to solve the problem, do I have to change some thing or what? Can you please explain more? Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Upgrade Question
Oracle database patchsets for UNIX are cumulative. Applying the latest patchset will include all of the fixes in previous patchsets for the same baseline version. (i.e. The 8.1.7.4.0 will include the fixes in 8.1.7.3). Unless otherwise noted, you can apply the latest patchset with out applying lower patchsets first. Read the readme associated with the patch to see if anything is otherwise noted. On Mon, Jun 03, 2002 at 08:18:22AM -0800, Hamid Alavi wrote: My question is for installing any patch do I have to install the previous patch first or what? === 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: Upgrade Question
You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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: Upgrade Question
I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Upgrade Question
I couldn't find/var/opt/oracle/oraInst.loc I am on solaris which directory I have to look for looking at this file -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Upgrade Question
This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message
RE: Upgrade Question
Someone from the list will need to respond. I work on HPs here and I haven't done a Sun install in a few years. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 11:10 AM Please respond to ORACLE-L I couldn't find/var/opt/oracle/oraInst.loc I am on solaris which directory I have to look for looking at this file -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: Upgrade Question
That file is the pointer for the installer to know where to look for things. It's usually in the same place as oratab. As for the SUN install, let me quote the girl from the original Jurassic Park: It's a Unix system! I know how to use that! -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Upgrade Question Someone from the list will need to respond. I work on HPs here and I haven't done a Sun install in a few years. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 11:10 AM Please respond to ORACLE-L I couldn't find/var/opt/oracle/oraInst.loc I am on solaris which directory I have to look for looking at this file -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: Upgrade Question
Hello All Again, I just find the OraInst.loc and here is the content of the file: inventory_loc = /opt/home/rcosme ...don't know what's this mean? inst_group= This is all about this file, Is any body know what contenet this file must have, Do I have to put Oracle userID address here or some thing else. Can some body send me a sample of this file please??? Oracle 8.1.7.0 on sun solaris. Thanks allot -Original Message- Sent: Monday, June 03, 2002 11:14 AM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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
RE: Upgrade Question
1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). I tend to be a bit anal too, but this is perhaps overkill :-) 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). 100% agree with this one. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. While I like different listeners for different versions, one per instance seems like a bit of overkill. Again, 20 different listeners is expensive from a memory POV and I've got to find 20 unused ports. For those on the list that disagree, flame away. No flames here, just seems like overkill to me The number of failures I have gotten that would have been saved by this amount of overkill would fit on maybe 2 or 3 fingers in about 12 years of DBA'ing, and I can't remember a production problem in any event that would have been saved cost benefit isn't there based on that. But hey, I'm all for high availability!! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -Original Message- Sent: Monday, June 03, 2002 2:14 PM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi
RE: Upgrade Question
List, Can some body tell me what's the usage of oratab orainst.loc files (sun solaris OS), I am getteing confused because I have two diffrent Oracle_home but just one one Orainventory Directory, It shouldn,'t be for each oracle_home own Orainventory directory??? Appreciate your HELP. Thanks, -Original Message- Sent: Monday, June 03, 2002 12:58 PM To: Multiple recipients of list ORACLE-L 1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). I tend to be a bit anal too, but this is perhaps overkill :-) 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). 100% agree with this one. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. While I like different listeners for different versions, one per instance seems like a bit of overkill. Again, 20 different listeners is expensive from a memory POV and I've got to find 20 unused ports. For those on the list that disagree, flame away. No flames here, just seems like overkill to me The number of failures I have gotten that would have been saved by this amount of overkill would fit on maybe 2 or 3 fingers in about 12 years of DBA'ing, and I can't remember a production problem in any event that would have been saved cost benefit isn't there based on that. But hey, I'm all for high availability!! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -Original Message- Sent: Monday, June 03, 2002 2:14 PM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from
Re: Upgrade Question
There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the orainventory contains info about what is installed for all versions of Oracle on the system (8i and above). A single oratab file is used by all versions of Oracle to set ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts. In most cases both the oratab and orainventory files are found under /var/opt/oracle. Hamid Alavi wrote: List, Can some body tell me what's the usage of oratab orainst.loc files (sun solaris OS), I am getteing confused because I have two diffrent Oracle_home but just one one Orainventory Directory, It shouldn,'t be for each oracle_home own Orainventory directory??? Appreciate your HELP. Thanks, -Original Message- Sent: Monday, June 03, 2002 12:58 PM To: Multiple recipients of list ORACLE-L 1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). I tend to be a bit anal too, but this is perhaps overkill :-) 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). 100% agree with this one. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. While I like different listeners for different versions, one per instance seems like a bit of overkill. Again, 20 different listeners is expensive from a memory POV and I've got to find 20 unused ports. For those on the list that disagree, flame away. No flames here, just seems like overkill to me The number of failures I have gotten that would have been saved by this amount of overkill would fit on maybe 2 or 3 fingers in about 12 years of DBA'ing, and I can't remember a production problem in any event that would have been saved cost benefit isn't there based on that. But hey, I'm all for high availability!! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -Original Message- Sent: Monday, June 03, 2002 2:14 PM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova
RE: Upgrade Question
Thanks, So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused and looking for a installed patch? What the content of oratab should be? I have the following values in my oratab: STAR:/u01/app/oracle:Y 8.1.6 CQST:/u01/app/oracle:Y 8.1.6 HMS:/u01/app/oracle:N8.1.6 DEVL:/u04/app/oracle:N 8.1.7.0 REPO:/u04/app/oracle:N 8.1.7.0 PROD:/u04/app/oracle:N 8.1.7.0 Actualy I don't know those Y or N infront of each instance name, Do I have to change it to Y for 8.1.7 instances or NOT? Appreciate. -Original Message- Sent: Monday, June 03, 2002 3:23 PM To: Multiple recipients of list ORACLE-L There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the orainventory contains info about what is installed for all versions of Oracle on the system (8i and above). A single oratab file is used by all versions of Oracle to set ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts. In most cases both the oratab and orainventory files are found under /var/opt/oracle. Hamid Alavi wrote: List, Can some body tell me what's the usage of oratab orainst.loc files (sun solaris OS), I am getteing confused because I have two diffrent Oracle_home but just one one Orainventory Directory, It shouldn,'t be for each oracle_home own Orainventory directory??? Appreciate your HELP. Thanks, -Original Message- Sent: Monday, June 03, 2002 12:58 PM To: Multiple recipients of list ORACLE-L 1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). I tend to be a bit anal too, but this is perhaps overkill :-) 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). 100% agree with this one. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. While I like different listeners for different versions, one per instance seems like a bit of overkill. Again, 20 different listeners is expensive from a memory POV and I've got to find 20 unused ports. For those on the list that disagree, flame away. No flames here, just seems like overkill to me The number of failures I have gotten that would have been saved by this amount of overkill would fit on maybe 2 or 3 fingers in about 12 years of DBA'ing, and I can't remember a production problem in any event that would have been saved cost benefit isn't there based on that. But hey, I'm all for high availability!! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -Original Message- Sent: Monday, June 03, 2002 2:14 PM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle
RE: Upgrade Question
that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from
RE: Upgrade Question
Hi List, I just find this on Metalink: If an inadvertent attempt is made to apply this Patch Set to a non-8.1.7 release, then a warning dialog box entitled Dependencies is displayed which contains the following error message: There are no patches that need to be applied from the patch set Oracle8i Patchset 8.1.7.4.0. The installer will not allow the installation to proceed. Just acknowledge the error and click on the Exit button to end the installation session. This means I am trying to upgrade another version of oracle(8.1.6), but when I check the user which I use all point to the 8.1.7 home base. Any Idea? what else I have to check? I am realy confused with this Upgrade Thanks all for HELP. -Original Message- Sent: Monday, June 03, 2002 3:23 PM To: Multiple recipients of list ORACLE-L There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the orainventory contains info about what is installed for all versions of Oracle on the system (8i and above). A single oratab file is used by all versions of Oracle to set ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts. In most cases both the oratab and orainventory files are found under /var/opt/oracle. Hamid Alavi wrote: List, Can some body tell me what's the usage of oratab orainst.loc files (sun solaris OS), I am getteing confused because I have two diffrent Oracle_home but just one one Orainventory Directory, It shouldn,'t be for each oracle_home own Orainventory directory??? Appreciate your HELP. Thanks, -Original Message- Sent: Monday, June 03, 2002 12:58 PM To: Multiple recipients of list ORACLE-L 1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). I tend to be a bit anal too, but this is perhaps overkill :-) 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). 100% agree with this one. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. While I like different listeners for different versions, one per instance seems like a bit of overkill. Again, 20 different listeners is expensive from a memory POV and I've got to find 20 unused ports. For those on the list that disagree, flame away. No flames here, just seems like overkill to me The number of failures I have gotten that would have been saved by this amount of overkill would fit on maybe 2 or 3 fingers in about 12 years of DBA'ing, and I can't remember a production problem in any event that would have been saved cost benefit isn't there based on that. But hey, I'm all for high availability!! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -Original Message- Sent: Monday, June 03, 2002 2:14 PM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See metastink for details on this. 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM
RE: Upgrade Question
] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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
Re: Upgrade Question
to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). For those on the list that dissagree, flame away. This is what I've found works the best in this environment. In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade will not effect it. Since the patch says that there is nothing to upgrade, the /var/opt/oracle/oraInst.loc file probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Upgrade Question 06/03/02 10:23 AM Please respond to ORACLE-L I have also two other instances running on 8.1.6.2, This upgrade may be effected from these version of Oracle or not, or this upgrade can be totaly independent from 8.1.6.2 I am a bit confused, Need your advise guy Thanks allot -Original Message- Sent: Monday, June 03, 2002 9:59 AM To: Multiple recipients of list ORACLE-L You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc points to the wrong OraInventory directory. We just went to 8.1.7.4 to resolve some issues with .2. So far, so good. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. hamid.alavi@quova dx.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade Question 06/03/02 09:18 AM Please respond to ORACLE-L Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: There are no Patches need to be applied from the patch set oracle 8i patch set 8.1.7.4.0 and doesn't go thru at all, My question is for installing any patch do I have to install the previous patch first or what? Is there any Prepatch to Install for any patching or NOT? We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better safer?? If I want to go for Patch 4,is there any comments or recommendation Really appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only
Re: Upgrade Question
You said: There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the Not necessarily (and not recommended). It is very easy to setup an orainventory file for each installation. Check metalink for details. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Re: Upgrade Question 06/03/02 03:23 PM Please respond to ORACLE-L There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the orainventory contains info about what is installed for all versions of Oracle on the system (8i and above). A single oratab file is used by all versions of Oracle to set ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts. In most cases both the oratab and orainventory files are found under /var/opt/oracle. Hamid Alavi wrote: List, Can some body tell me what's the usage of oratab orainst.loc files (sun solaris OS), I am getteing confused because I have two diffrent Oracle_home but just one one Orainventory Directory, It shouldn,'t be for each oracle_home own Orainventory directory??? Appreciate your HELP. Thanks, -Original Message- Sent: Monday, June 03, 2002 12:58 PM To: Multiple recipients of list ORACLE-L 1. Use a separate tech stack (oracle home) for each instance. In general I like the idea, but it gets a bit pricey on disk space if you are running say 20-30 instances on a given box doesn't it?? 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). I tend to be a bit anal too, but this is perhaps overkill :-) 3. Back up the OraInventory directory before and after an install/upgrade. If this directory get hammered, there is no way to recreate it except to re-install (Thank You Oracle! all the sarcasm in the world implied here). 100% agree with this one. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. While I like different listeners for different versions, one per instance seems like a bit of overkill. Again, 20 different listeners is expensive from a memory POV and I've got to find 20 unused ports. For those on the list that disagree, flame away. No flames here, just seems like overkill to me The number of failures I have gotten that would have been saved by this amount of overkill would fit on maybe 2 or 3 fingers in about 12 years of DBA'ing, and I can't remember a production problem in any event that would have been saved cost benefit isn't there based on that. But hey, I'm all for high availability!! RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -Original Message- Sent: Monday, June 03, 2002 2:14 PM To: Multiple recipients of list ORACLE-L This is why we: 1. Use a separate tech stack (oracle home) for each instance. 1a. Use a separate unix account for each oracle home for total isolation. The DBA here is real anal. (BTW, that's me). 1b. I've also found that it is easier to use one listener for each instance instead of one listener for all instances. 1c. We go so far as to give Oracle Names its own tech stack. 2. For each tech stack install, use a separate OraInventory directory. See
RE: Upgrade question
Lee, I don't know of any white papers but we had to upgrade Tru64 to v5.1 in order to install Oracle 8.1.6. I don't recall any other drawbacks to making this conversion. Ron -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001 7:16 AMTo: Multiple recipients of list ORACLE-LSubject: Upgrade question All, Are there any white papers out there (or personal experiences) that you know of specifiying gains/losses in upgrading from Oracle8 to 8i. We are on Compaq Tru64 4.0f and Oracle Version 8.0.5.0.0 TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.