Re: 8.1.7.4 interim patch management strategy

2003-07-30 Thread Hemant K Chitale
I do not apply any one-off patch [except for Security patches] unless I have actually encountered a situation where I need it or the application requires it [e.g Apps R11 on 8.1.7.2 and 8.1.7.4 requires additional one-off patches]. The one-off patches are not "regression-tested". Security Patches

RE: 8.1.7.4 interim patch management strategy

2003-07-30 Thread Hallas, John, Tech Dev
Always a difficult activity although the opatch utility available with 9i could prove a real benefit Most sites I have worked on don't have a policy as such but they only apply patches as and when necessary. The other difficulty is that out of say the 180 patches you mention, many may apply to

RE: 8.1.7.4 interim patch management strategy

2003-07-30 Thread Jesse, Rich
Our strategy is to not apply them and migrate to 9iR2 instead. At least that's the plan for now, until we find out something won't work with 9i. It's probably cheaper to do in the long run, and it'll be supported thru 2005, unlike 8.1.7, which "expires" at the end of this year. Rich Rich Jesse

Re: 8.1.7.4 to 9.2

2003-02-11 Thread chao_ping
Rishi.Jain, If downtime is allowed, I would like choose exp/imp.This full reorg the database and you can fully utilize new features like segment management auto, which cannot be changed after tablespace is created.And Exp/imp is more safe than mig.But mig is much faster than exp/

Re: 8.1.7.4 to 9.2

2003-02-11 Thread Hemant K Chitale
I created a new database in 9i and used export/import so that I could a. Reorganise all the file systems / mount-points and file-naming convention b. Create Locally Managed Tablespaces [incl SYSTEM] with Auto Allocation and Automatic Segment Space Management Point b. is what you would be l

RE: 8.1.7.4 databases going bad

2003-02-11 Thread Jesse, Rich
My knee-jerk would be to check the file dates on the 8.1.7.4's ORACLE_HOME to make sure that nothing changed accidentally. Perhaps a rogue libary or some such? GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex,

RE: 8.1.7.4 patch for Linux

2002-06-21 Thread Ji, Richard
Good catch. That was the problem. Thanks a lot. -Original Message- Sent: Friday, June 21, 2002 2:32 PM To: Multiple recipients of list ORACLE-L Richard, The glibc patch has to be applied during every patchset application as the patchset may overwrite the relinking makefiles. Alessan

Re: 8.1.7.4 patch for Linux

2002-06-21 Thread Alessandro Guimaraes
Richard, The glibc patch has to be applied during every patchset application as the patchset may overwrite the relinking makefiles. Alessandro GuimarĂ£es - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 10:57 AM > After ins

RE: 8.1.7.4 patch for Linux

2002-06-21 Thread Ji, Richard
After installing the patch, Oracle ask you to put _system_trig_enabled=false in your init.ora before you run catalog catproc etc. I took it out and still have the problem. I also compared the init parameter values in alerg.log before and after applying the patch. Nothing's changed. I even trie

RE: 8.1.7.4 patch for Linux

2002-06-21 Thread Robertson Lee - lerobe
Unless I am having a senior moment, won't Oracle put some changes into your init.ora file for you when installing/upgrading Oracle 8i. I am sure I was bitten with this a few months back. Get a copy of your old init.ora file (if you have it )or at least check through you init.ora file for a comment

RE: 8.1.7.4

2002-05-23 Thread Arun Chakrapani
They have royally messed up the library cache, We are applying applying .. work arounds for this 8.1.7,Each time we call up they come back saying that there is a work around for this. We have very heavy contentions on library cache, the sql which are using bind variables are not getting shared

Re: 8.1.7.4

2002-05-23 Thread Mladen Gogala
I heard that too, but I think that they'll be weighing their options. If 8.1.7.4 is messed up badly, they'll probably give us 8.1.7.5 for Christmas. On 2002.05.23 09:33 Hemant K Chitale wrote: > > Nope. .4 is supposed to be the last PSR (patchset release) > for 8.1.7 > > Hemant K Chitale > >

Re: 8.1.7.4

2002-05-23 Thread Hemant K Chitale
Nope. .4 is supposed to be the last PSR (patchset release) for 8.1.7 Hemant K Chitale - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, 23 May, 2002 4:33 AM > > I hear that .5 is right around the corner. > > Vinny > > > --- Ruth Gramo

Re: 8.1.7.4

2002-05-22 Thread Vincent Cimino
I hear that .5 is right around the corner. Vinny --- Ruth Gramolini <[EMAIL PROTECTED]> wrote: > I thought that .3 was the final patch. I guess they found more stuff that > needed fixing. > > Ruth > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTE

Re: 8.1.7.4

2002-05-22 Thread Ruth Gramolini
I thought that .3 was the final patch. I guess they found more stuff that needed fixing. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 8:58 PM > Has anyone patched up to 8.1.7.4 yet??? > > Anything we should be aw