Re: Monthly maintenance

Lber wrote:
> "sybrandb" <sybrandb_at_gmail.com> wrote in message
> news:1162982055.127785.225250_at_i42g2000cwa.googlegroups.com...
> >
> >
> > On Nov 8, 11:25 am, "Lber" <l..._at_smartitc.co.uk> wrote:
> >> Hi,
> >> I'm in the process of setting up an Oracle server.
> >> what sort of maintenance does Oracle need to keep it running at it's
> >> optimum
> >> levels?
> >>
> >> FYI it's an 8i server
> >>
> >> TIA
> >
> > 8i was desupported several years ago.
> > One would question whether this is for legitimate purposes.
> > The current version is 10gR2. It contains many administration
> > enhancements and automated procedures.
> > I would seriously reconsider.
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> It's due to the fact the firm I'm working for have this version and wish to
> stay with it.
> There are no immediate plans to upgrade to the new version, however I wish
> we were.
> But in the mean time i need to "go with the flow" as it were and do as i'm
> told.
> In the meantime I would like to know that what we use is running at it's
> peak
>
> This is very legitimate, and I can't understand why you think it may not be!
> I would imagine that this version is still in frequent use for legacy
> reasons!
>

I don't think that Sybrand was stating that your use of Oracle 8i is not for legitimate purposes, but rather that there is no legitimate reason to stay with Oracle 8i rather than upgrading to Oracle 9i or 10g, if you have an active Oracle maintenance agreement.

We are running two (slightly old) commerical applications that are certified to run on Oracle up to version 8.1.7.3. The company that produced one of the applications stated absolutely that the product would not work with Oracle 10g, and as a matter of fact the latest patch for Oracle 9.2 breaks all of the more recent versions of the application, except the latest release. The recycle bin in 10g causes significant problems for the most recent version of this commercial application, when new users are added to the system, drop dead errors such as "Getting an 'SYSADM.BIN$1Gs7x9eQSMigiXFLGDEGsA==$0' error" occur when permissions are attempted to be assigned to tables in the recycle bin. The suggestion by the company that produced the commercial application to fix this problem: delete from SYS.OBJ$ where name like 'BIN%' and name not like 'BINARY%'; Blindly upgrading to a new version of Oracle is not a good idea. We have been successfully running these two (slightly old) commerical applications that are certified to run on Oracle up to version 8.1.7.3 on 10.2.0.2 since April... There are legitimate reasons for staying still, and there are legitimate reasons for moving forward - find your comfort level.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 08 2006 - 06:29:53 CST