| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: updating singly sys packages
Sounds reasonable based on WHAT?? This is a wrapped package, so you have no
idea the interactions that this package may have with other Oracle
processes, and what processes might well intereact with this package. Things
might work for a week, or a month and then crater when one specific process
runs. This is INSANE, repeat INSANE, in my opinion. You are essentially
making yourself an Oracle developer without the available assistance of
oracle support should your database go belly up. Ideas are wonderful things,
but we must be ready to dismiss them when they are clearly wrong, as this
one is in my humble opinion.
Robert
-----Original Message-----
From: Juan Cachito Reyes Pacheco
To: oracle-l_at_freelists.org
Sent: 2/27/2004 2:48 PM
Subject: Re: updating singly sys packages
Thanks, migrate all the sys package is insane, but one, like utl_file,
sounds reasonable,
always you test it right, finally this is a package. And if this not
works,
you will see soonly, and you can go back easily, I'm not thinking
seriously
in doing this, but I'm analyzing the positiblity to try on of this days.
> Juan
>
> Installing 9.2.0.4 packages in a 9.2.0.1 database one package at a
time
> doesn't sound reasonable at all. Migrating to a new level is not just
about
> the internal packages. As other's have said, it is also about
updating or
> inserting records into the sys tables. If you install a 9.2.0.4
package
> without updating the supporting database tables, things could go bad
fast.
>
> No. There is no reasonable reason to do this in a production
database.
>
> You could certainly try anything in a test database. But even if it
worked,
> I would not move it forward to production.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com]
> Sent: Friday, February 27, 2004 3:32 PM
> To: oracle-l_at_freelists.org
> Subject: Re: updating singly sys packages
>
>
> we have several customer with the same system, about 8, and about 100
forms,
> and a critical
> software, for example if they don't give a daily about 8 report to the
> government until 10:00 they can have a penalty about 50U$ for each,
other
> monthly, etcs.
>
> We can't be up to date in patches in deevloper 6i, because the amount
of
> customer, and you know developer 6i runtime, not web.
>
> We can update't easily a database, something like today we update all
> database, we have to update late in the night usually. update all
database
> can take about 2 months, because some of them can reject the update.
>
> So, a change like updating a patch, can create serious problems, for
example
> to need to recompile a form connecting to that database, to get it
work.
> Because there are several bugs in developer 6i, once happened and we
don't
> want to have problems again.
>
> We are not going to patch 9i, because we don't have bugs create
problems,
> about security, there is no problem beacuse they are not connected to
the
> internet and has few clients, between 3 to 20.
>
> Then I though, if a package wrapped is a package, why not to try?
> Obviously Tom was not going to say "do it!", but it seems to sound
> reasonable.
>
> ----- Original Message -----
> From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM>
> To: <oracle-l_at_freelists.org>
> Sent: Friday, February 27, 2004 3:37 PM
> Subject: RE: updating singly sys packages
>
>
> > Juan
> > Can you elaborate on "can't run patches"? Does that mean you are
using
> > 9.2.0.1? I had some real bad errors until I added the 9.2.0.4 patch
set.
> >
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito
Reyes
> > Pacheco
> > Sent: Friday, February 27, 2004 1:31 PM
> > To: oracle-l_at_freelists.org
> > Subject: updating singly sys packages
> >
> >
> > Hi, I asked recently to Tom if I could do an extract ddl from
utl_file
> from
> > 9.2.4 and run in 9.2,
> > Because I can't run patches.
> >
> > Tom obviously said NO.
> >
> > But what can go wrong, except something not working.
> >
> > Some experience?
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Feb 27 2004 - 15:01:51 CST
 |
 |