Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
rthomas_at_hypercom.com
"The problem with some people is that when they aren't drunk, they're
sober." --William Butler
Yeats.
hamid.alavi_at_quova dx.com To:ORACLE-L_at_fatcity.com
Sent by: cc: root_at_fatcity.com 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
rthomas_at_hypercom.com
"The problem with some people is that when they aren't drunk, they're
sober." --William Butler
Yeats.
hamid.alavi_at_quova dx.com To:ORACLE-L_at_fatcity.com
Sent by: cc: root_at_fatcity.com 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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: hamid.alavi_at_quovadx.com 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: ListGuru_at_fatcity.com (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: rthomas_at_hypercom.com 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: ListGuru_at_fatcity.com (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: hamid.alavi_at_quovadx.com 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: ListGuru_at_fatcity.com (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: rthomas_at_hypercom.com 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: ListGuru_at_fatcity.com (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: Freeman, Robert INET: Robert_Freeman_at_csx.com 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: ListGuru_at_fatcity.com (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: hamid.alavi_at_quovadx.com 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: ListGuru_at_fatcity.com (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).Received on Mon Jun 03 2002 - 16:24:16 CDT
![]() |
![]() |