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
Cell 818 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).
--
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).
