]
[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
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
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
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
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
-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
, 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
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
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
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.
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
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
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
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
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,
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
-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:
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
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
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
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
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
: 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
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
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
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
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
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
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
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
:
root@fatcity.Subject: applications patches
com
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
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
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
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
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
]'
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
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
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
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
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
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
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
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
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
: [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
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
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
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
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
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
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
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
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
:[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
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
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
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,
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
,
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
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
(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
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
, 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
78 matches
Mail list logo