RE: updating singly sys packages
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Feb 2004 15:42:00 -0500
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@xxxxxxxxxxxxxxxx]
Sent: Friday, February 27, 2004 3:32 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Juan Cachito Reyes
> Pacheco
> Sent: Friday, February 27, 2004 1:31 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
