| 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
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.
> 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
> -----------------------------------------------------------------
>
-- 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 - 14:39:05 CST
 |
 |