10.7/UX10.2 to UX11
Date: Fri, 18 Jun 1999 14:45:18 -0700 (PDT)
From: Chris Taylor cwt_cfa@yahoo.com
Subject: HPUX: 10.20 to 11.0 file system upgrade for R10.7
We are migrating our 10.7 installation from HPUX 10.20 to HPUX 11.0.
If anyone's done that, please comment on this approach.
First, we'll migrate the database over to the new OS running an HPUX
11.0 version of the Oracle RDBMS. That's done.
Now for the file system:
1. Install new HPUX 11.0 APPL_TOP
2. Get HPUX 11.0 version of all patches with "libin", "libout" or
"link" directives in patch.drv
3. Apply patch.drv components of all patches applied to HPUX 10.20
APPL_TOP, in the same order as originally applied, to HPUX 11.0
APPL_TOP
Do you agree that this would create an HPUX 11.0 APPL_TOP
functionally identical to the 10.20 version?
Thanks for your thoughts.
--Chris Taylor
Chick-fil-A, Inc.
Date: Fri, 25 Jun 1999 18:36:45 -0400
From: "Timothy Brewer" tbrewer@tbsolns.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: HPUX: 10.20 to 11.0 file system upgrade for R10.7
Chris,
Having just completed this very process this week, I would agree that you
have hit upon all the steps required.
My only question is your bullet point number 2. ??? Not sure what this is
or where you heard this.
Bullets 1 & 3 are correct. Also, when you say "migrate over", I presume
you're merely copying the log/dbf files and recreating the control file for
HP UX 11.0.
All in all, no major surprises, no major problems.
Let me know if you have any questions.
Tim
Timothy J. Brewer
Senior Oracle Consultant
TB Solutions, Inc.
Date: Thu, 1 Jul 1999 08:02:39 -0700 (PDT)
From: Chris Taylor cwt_cfa@yahoo.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: HPUX: 10.20 to 11.0 file system upgrade for R10.7
Thanks for the comments. We had over 120 patches applied to
production, so I was looking for a shortcut. It looked to me like the
only *necessary* steps in the patches had to do with object code and
binaries, which are different on 10.20 and 11.0. I was able to
eliminate 75 or 80 patches that contained only character forms,
reports, or SQL.
To make sure our HPUX 11.0 APPL_TOP got those forms, reports, etc.,
we copied forms, srw, sql and several other subdirectories directly
from the 10.20 APPL_TOP to the 11.0 APPL_TOP and then regenerated all
character forms and reports for good measure.
We are now live in production on R10.7, HPUX 11.0, 8.0.5.1-64bit in
server-partitioned mode. Not without problems, mind you. The 8.0.5.1
import utility is as buggy as a cricket farm.
--Chris Taylor
Date: Mon, 05 Jul 1999 09:46:44 PDT
From: Pete Beer pbeer@hotmail.com
Subject: Re: HPUX: 10.20 to 11.0 file system upgrade for R10.7
Somewhere around 40 patches is a good number. Especially if you install
HR/Payroll (which takes about about 12 with two additional product installs
- vertex and microfocus cobol).
Regards;
Pete
peteb@ccai.net
10.7 SmartClient 16.0 to SmartClient 16.1
From: louis_avrami@es.adp.com[SMTP:louis_avrami@es.adp.com]
Reply To: oraapps-dba@cpa.qc.ca
Sent: Tuesday, 15 June 1999 07:33
Subject: 16.1 upgrade, invalid PA_ADW% objects
Hello all,
We just did a 10.7 SmartClient 16.0 to SmartClient 16.1
upgrade on
one of our test databases.
We now have 27 invalid objects within the database, all
beginning
with PA_ADW%. The list is below.
Has anyone encountered this before? Anyone aware of a fix?
I'm
currently working with Support on this, but we haven't found
anything
out yet. Looking under $PA_TOP, it looks like the package
PA_ADW_CREATE_VIEWS has something to do with the creation of at
least
some of these view.
Any insights would be greatly appreciated.
Thanks,
Lou Avrami ( louis_avrami@es.adp.com )
OWNER/ OBJECT_NAME /OBJECT_TYPE
--------- ---------------------------------------- -------------
APPS/ PA_ADW_ACT_CMT_B_V /VIEW
APPS /PA_ADW_ACT_CMT_V /VIEW
APPS /PA_ADW_BGT_LINES_B_V /VIEW
APPS /PA_ADW_BGT_LINES_V /VIEW
APPS /PA_ADW_COLLECT_DIMENSIONS /PACKAGE BODY
APPS /PA_ADW_COLLECT_FACTS /PACKAGE BODY
APPS /PA_ADW_COLLECT_MAIN /PACKAGE BODY
APPS /PA_ADW_LOWEST_RLMEM_B_V /VIEW
APPS /PA_ADW_LOWEST_RLMEM_V /VIEW
APPS /PA_ADW_PRJ_CLASSES_B_V /VIEW
APPS /PA_ADW_PRJ_CLASSES_V /VIEW
APPS /PA_ADW_PRJ_TYPES_B_V /VIEW
APPS /PA_ADW_PRJ_TYPES_V /VIEW
APPS /PA_ADW_PROJECTS_B_V /VIEW
APPS /PA_ADW_PROJECTS_V /VIEW
APPS /PA_ADW_RES_LISTS_B_V /VIEW
APPS /PA_ADW_RES_LISTS_V /VIEW
APPS /PA_ADW_R_ACT_CMT_B_V /VIEW
APPS /PA_ADW_R_ACT_CMT_V /VIEW
APPS /PA_ADW_R_BGT_LINES_B_V /VIEW
APPS /PA_ADW_R_BGT_LINES_V /VIEW
APPS /PA_ADW_R_ST_ACT_CMT_B_V /VIEW
APPS /PA_ADW_R_ST_ACT_CMT_V /VIEW
APPS /PA_ADW_TOP_RLMEM_B_V /VIEW
APPS /PA_ADW_TOP_RLMEM_V /VIEW
APPS /PA_ADW_TOP_TASKS_B_V /VIEW
APPS /PA_ADW_TOP_TASKS_V /VIEW
Date: Tue, 15 Jun 1999 09:27:46 +1200
From: Erica Harris EricaH@wairc.govt.nz
To: "'oraapps-dba@cpa.qc.ca'" oraapps-dba@cpa.qc.ca
Subject: RE: 16.1 upgrade, invalid PA_ADW% objects
I presume you've tried manually recompiling these objects. Is there
anything in user_errors for apps? That might give you some clues.
Regards,
Erica
Erica Harris
Oracle DBA/System Administrator Ph +64 7 856 0555 ext
8759
Environment Waikato Fax +64 7 856
0551
401 Grey Street email:
ericah@wairc.govt.nz
PO Box 4010
Hamilton East
New Zealand
Date: Fri, 25 Jun 1999 16:04:45 -0400
From: louis_avrami@es.adp.com (Louis Avrami)
To: oraapps-dba@cpa.qc.ca
Cc: EricaH@wairc.govt.nz
Subject: Re: 16.1 upgrade, invalid PA_ADW% objects
Hi all,
I did finally solve the problem of invalid PA_ADW% objects. The
problem was that the underlying views PA_PROJECTS, PA_PROJECT_TYPES
and PA_RESOURCE_LISTS did not include the column ADW_NOTIFY_ITEM.
Running the $PA_TOP/patchsc/107/sql scripts pavw166.sql, pavw188.sql
and pavw230.sql fixed it.
Lou Avrami
Ugrade Db from 8.0.4.2.1 to either 8.0.4.3 or 8.0.5
Date: Wed, 30 Jun 1999 21:26:03 +0200
From: "Worthington, S." S.Worthington@ahpg.com
To: "'oraapps-dba@cpa.qc.ca'" oraapps-dba@cpa.qc.ca
Subject: 8.0.4.3 or 8.0.5
v
We are currently 8.0.4.2.1, R11.0.2, AIX 4.3.2, OWS 3.0.2, and D2000
patchset 4.
We are considering an upgrade of the database to either 8.0.4.3 or 8.0.5 to
fix some 600 [17034] errors. 8.0.4.3 is obviously easier in the short term,
but we might save time in the long run by going to 8.0.5 Does anyone have
any words of wisdom, or warnings?
Also, does anyone know of any known problems with D2000 patchset 6 (forms
listener 4.5.10.13).
Thanks, Stu
stuartw@email.com
Date: Wed, 30 Jun 1999 16:10:47 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
To: "'oraapps-dba@cpa.qc.ca'" oraapps-dba@cpa.qc.ca
Subject: RE: 8.0.4.3 or 8.0.5
We have the same problem ( getting ORA-00600 error messages). We contact the
oracle support and they are telling to upgrade the database from 8.0.4.2.1
to 8.0.4.3 or higher. I also would like to know about any problems appeared
during the upgrade with resolutions.
we are on HP-UX 11.0. OWS 3.0 with R11.0.2
I also prefer to go with 8.0.5.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Thu, 1 Jul 1999 09:43:39 -0400
From: Margaret Murray mmurray@delorme.com
To: "'oraapps-dba@cpa.qc.ca'" oraapps-dba@cpa.qc.ca
Subject: RE: 8.0.4.3 or 8.0.5
Hi Stu and Bharat,
When we went live on 11.01 last summer (we have Solaris) we tried 8.0.4.2.1
for only a few days before upgrading production to 8.0.4.3. At the time
support said if they'd known we were live they would have strongly
recommended 8.0.4.3. (??) We had serious difficulties upgrading to
8.0.5.1; in fact we only successfully upgraded one test instance. This
might only be Solaris, but support said (when we called in about 6 tars for
issues with 8.0.5.1) that while it's certified it's not technically
supported. The reason (they said) had to do with Developer 1.6.1 being
incompatible with some of 8.0.5.1 libraries, so it's possible there is a
patch for this problem or it's been resolved with a higher developer
patchset than we have (we're on patchset 4). Developer should be installed
in a separate ORACLE_HOME, which isn't possible with Applications. I do
know (from this list) there are others on 8.0.5.x, but I don't know what OS
and if they too had/have difficulties.
HTH,
Margaret Murray, DBA
DeLorme Mapping
Date: Thu, 1 Jul 1999 11:30:06 -0700
From: skirby@bco.com
Subject: RE: 8.0.4.3 or 8.0.5
We did an 8.0.4.2.1 to 8.0.5.0.0 on an AIX system in January. The upgrade
took 3 days because the architecture of 8.0.5 didn't have certain libraries
that Applications required. We fixed that, but were then stuck with a
listener that did not work. After 2 months of having an open tar we
downgraded the database. We could function that long because we used the
8.0.4 listener.
My response would be to not go to 8.0.5. Between my experience and what I
have read on this list Oracle still doesn't have it all nailed down.
Steve Kirby
skirby@bco.com
Date: Mon, 05 Jul 1999 09:43:51 PDT
From: Pete Beer pbeer@hotmail.com
Subject: RE: 8.0.4.3 or 8.0.5
Hi;
I've been running on AIX 4.3.1 with Oracle 8.0.5.1 and Applications 11.0.2
for several months with multiple databases using one 8.0.5.1 listener. No
problems. I suspect something else is going on.
Regards;
Pete Beer
Conley - Canitano
peteb@ccai.net
Date: Tue, 6 Jul 1999 10:13:44 -0700
From: skirby@bco.com
To: oraapps-dba@cpa.qc.ca
Subject: RE: 8.0.4.3 or 8.0.5
With your feedback I would suggest that they fixed the problem in 8.0.5.1.
The details are that the OE listener and the FNDFS listener quit working
after 8.0.5 was installed. There were multiple problems because the
original 8.0.5 AIX architecture had removed and combined libraries that the
Apps required to relink. Even after those libraries had been added, the OE
and FNDFS listeners still wouldn't run properly. I could connect to the
database fine with the 8.0.5 listener, but reports and OE failed.
Did you upgrade from a previous version? Any performance improvements?
Steve Kirby
skirby@bco.com
Date: Tue, 06 Jul 1999 15:49:55 PDT
From: Pete Beer pbeer@hotmail.com
To: oraapps-dba@cpa.qc.ca
Our install was new. FNDFS and OEORPC presented their own problems.
Spending some quality time with Oracle resolved those issues. They were
related to configuring the listener, adn applications profiles properly.
Regards;
Pete
Upgrade to Rel 11 from 10.7 SC
Date: Mon, 19 Jul 1999 11:51:31 -0700
From: David Kao david.kao@nist.gov
Subject: AOL: R11 upgrade questions
We are running R10.7 SC16.1 on AIX 4.3.2. Recently we received a notice
from Oracle Supports saying that 10.7 will be desupported after Dec 31,
2000, and suggested us to upgrade to 10.7NCA or R11. These are the
questions I am hoping someone can help me with:
1) should I move to 10.7NCA or R11, R11 is my preference because then I
don't have to upgrade twice
2) One-Hour Install is not an option for upgrading from R10.7, true?
3) upgrading to R11, do I have to export my existing database and import to
a new created Oracle 8 database (it would take more than 24 hrs just to do imp)
4) while my database and concurrent servers still on AIX, can I install
Forms and Web servers on multiple NTs? so I need both the installation
media for AIX and NT?
5) Can I continue using SmartClient after upgrade? I heard it is not
supported, but what happens if I run forms on the NT (with Forms and Web
servers installed) directly?
6) We have several custom forms (Oracle Applications Coding Standards
compliant), is there something we have to do to make them work after upgrade?
7) How much time is required for the upgrade (for a 4GB database)?
8) Is there any problems that I may run into while upgrading
9) How stable is it? How about performance?
David Kao
Oracle DBA
National Institute of Standards and Technology
Date: Mon, 19 Jul 1999 11:27:03 CDT
From: "Darrell Willner" darrellwillner@hotmail.com
Subject: Re: AOL: R11 upgrade questions
David,
1. Recommend moving to R11.
You have many more options.
2. One-Hour is and is not an option.
You will need to upgrade the db,etc, manually.
If you upgrade to 'TEST' db, validate everything
then you could use the 1 hour for your production
then import.
3. If you upgrade and leave as is no exp/imp is required.
**** HIGHLY RECOMMEND A COLD DB EXPORT AND COLD OS BACKUP ***
4. Yes you can install the forms and web servers on NT's.
5. SmartClient no.
6. Yes!
a. Document everything
b. backup all customization
c. save source code in different base dir than $APPL_TOP
d. Complete Upgrade
e. Validate Source Code Registeration, ddl, and availability
7. Beg for two weeks, hope for 1 week, probably 3 days
8. Yes, lots of patches. Utilize 1102 or 1103
9. 1102 is stable, performance - requires
9b. Performance: double everything
Have A Great Day!
Darrell W. Willner
972.467.9430
RDBMS upgrade from 7.3.2.3.8 to 7.3.4
Date: Fri, 30 Jul 1999 07:39:27 PDT
From: "John Wolanski" wolanskijc@hotmail.com
Subject: Upgrade 7.3.2.3.8 to 7.3.4
Hi All:
I was wondering if someone could share their experiences/pointers/steps in
doing an upgrade from RDBMS 7.3.2.3.8 to 7.3.4 on a Windows NT Server.
My environment is 10.7SC Prod16.1 on the client side and on the database
server we have an Alpha Windows NT Server 4.0 SP3.
Appreciate your help.
TIA,
John Wolanski
E-mail: infotech@purdytransmissions.com
After upgrade from 8.03.2 to 8.0.5.1 Apps views take too long
Date: Thu, 19 Aug 1999 17:28:57 -0600
From: "Jones, Tracy" tkjones@sandia.gov
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: GEN: Experiencing Problems with Server 8.0.5.1 Upgrade.
We upgraded from Oracle Server 8.03.2 to 8.0.5.1. We use 10.7 SC
applications including projects. We now are experiencing major problems with
apps views that use to be sub second and now take 4 to 5 minutes. The views
are PA_ORGANIZATIONS_PROJECT_V, PA_ORGANIZATIONS_EXPEND_V,
PA_ORGANIZATIONS_V, and RCV_RECEIPTS_PRINT. The first two views were
somewhat fixed by Oracle(now take 5 seconds) but the other two are still
problems. We are also experiencing problems with the PAIGEN PRC: Generate
draft invoice for range of project. This program used to take 10 to 15
minutes now it does not even complete. We have looked at the views and they
have not changed. The indexes still appear and but the optimizer paths are
now different. Has anyone run into this problem and have a solution.
Oracle is fixing the views but is not addressing the root cause whatever it
is.
Date: Fri, 20 Aug 1999 09:29:43 -0400
From: "Ballen, Henry I" Henry.I.Ballen@ceridian.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Experiencing Problems with Server 8.0.5.1 Upgrade.
Have you tried to set init.ora parameter optimizer_features_enable=8.0.3 ?
Date: Fri, 20 Aug 1999 12:35:56 -0600
From: "Jones, Tracy" tkjones@sandia.gov
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: RE: GEN: Experiencing Problems with Server 8.0.5.1 Upgrade.
Our DBAs made a breakthrough. Our Apps Views were using the Cost Base Rule
for Optimization instead of Rule Base which they were written for.
According to our DBAs there is a new feature in Oracle Server 8.0.5.1 called
parallelism. The 8.0.5.1 installation manual says that if parallelism is
above 1 the Cost Based Optimizer will be used automatically. However in
reality, it is 1 or greater, forcing Cost Based Optimization. Sandia was
set to 1. The DBAs went to our 8.0.3 Server set an object to use Cost Based
and it ran poorly like 8.0.5 using the Cost Base Path. To correct the
problem Oracle Support said to force the indexes to not use parallelism
using an Alter command. We tried a couple and it worked using Rule Base
functioning as they used to. We are in the process of changing all the
indexes to all rule based. Hopefully Oracle will add this to their readme
file for loading 8.0.5.1. Three weeks of problems now resolved.
Upgrade from 7.3.2 to 7.3.4
Date: Thu, 22 Jul 1999 21:07:59 PDT
From: "shankar govindan" shankargovindan@hotmail.com
To: oraapps-dba@cpa.qc.ca
Subject: upgrade to 7.3.4
Time for us to to upgrade to 7.3.4. Any issues I should take care of , also
if somebody has documented the same would welcome. Well my problem is that I
have to upgrade 10 HP-UX servers and 41 NT databases spread across our 8
Factories and 41 Branches. I do not have DBA's at all these locations and we
have only one guy at east,west,north and 5 guys at south.We have Unicenter
TNG installed recently and I am hoping to do it with the RCO option.
We are on APPLICATION 10.7 PROD 16.1 SC
Oracle 7.3.2
HP-UX 10.2
WIN NT 4.0 SP3
Modules GL,AP,AR,PO,OE
TIA
shankar
Date: Tue, 27 Jul 1999 08:39:06 -0400
From: gfury@manu.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: upgrade 7.3.2 to 7.3.4
I just finished a couple of upgrades of 10.7 Prod 16.1 on HP-UX 10.20 from
7.3.3 to 7.3.4. The first question to ask is "Do you have the Apps 10.7
and RDBMS 7.3.4 inter-operability patch?".
This is key to performing the upgrade. The basic steps are as follows:
Install Oracle 7.3.4 in a new ORACLE_HOME
Install Developer 2000 in the new ORACLE_HOME
Patch Developer 2000 with patch that comes on the interoperability patch CD
Install SQL*Report in the new ORACLE_HOME from your original Apps CD
Install Forms 2.3 and CRT in the new ORACLE_HOME from your original Apps CD
Full, cold backup
Modify environment to point to new ORACLE_HOME
Upgrade database to 7.3.4
Patch database to 7.3.4.4
Re-compile invalid objects
Apply Apps patches from the interoperability patch CD
Re-link all Apps executables
Re-generate all Apps reports
If you use character mode forms, re-generate all forms
Test, Test, Test
Greg Fury
Manugistics, Inc
Rockville, MD
7.3.2.3 to 7.3.4.3
Date: Thu, 9 Sep 1999 20:22:54 -0400
From: fushan@gamma.aei.ca
To: oraapps-l@cpa.qc.ca
Subject: Upgrade database from V 7.3.2.3 to V7.3.4.3
Hi DBAs
I need to upgrade my Oracle RBDMS from V7323 to V7343. I
have two database attached to same ORACLE_HOME. One is
GEMMS the other is Oracle Financial. I will create a new
ORACLE_HOME for V7343 and move init files and other set up
from V7323 to V7343. Update the database objects for these two
database.
Did I miss any thing? Anyone who can give me some tips??
Fu-shan Louisa Leong
Oracle DBA, Oracle Financial Application
Andersen Consulting
Date: Fri, 10 Sep 1999 17:49:58 +0700
Date: Fri, 10 Sep 1999 13:49:34 +0200
Date: Fri, 10 Sep 1999 05:27:42 -0700 (PDT) 7.3.3 to 7.3.4 - system very slow after upgrade
From: Jay P. [SMTP:jpmrp@yahoo.com]
Date: Sat, 16 Oct 1999 09:44:10 -0500
Date: Mon, 18 Oct 1999 05:55:52 -0700 (PDT)
From: "Bambang Sugijono" bsugijon@sampoerna.co.id
To: oraapps-l@cpa.qc.ca
Subject: Re: Upgrade database from V 7.3.2.3 to V7.3.4.3
Hi Fushan,
Maybe this information can help you to upgrade your database :
1. Install Oracle RDBMS 7.3.4.0 in new oracle_home
2. Move init
3. Upgrade Oracle RBMS 7.3.4.3
4. Update Database object
Bambang Sugijono
Oracle DBA
PT. HM. SAMPOERNA
INDONESIA
From: sebastien.herpin@clf-dexia.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Upgrade database from V 7.3.2.3 to V7.3.4.3
Ask the support, there is an oracle applications interoperability patch
From: Kevin Gillins kgillins@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Upgrade database from V 7.3.2.3 to V7.3.4.3
I can't speak for your Gemms system but the Oracle Apps requires some
interoperability pathes. Also you will need to reinstall the forms,
crt, reports 2.5 and any other software besides the database for the
oracle financials. You will also want to relinke the oracle
applications with the new oracle home. I suspect Gemms would want a
relink also.
1) backup before you mess with it.
2) install software into new oracle home
-rdbms
-developer 2k report 2.5
-forms 2.4
-crt
-rpt (patch on IO cd)
-any other required software
3) apply dbms patch to 7.3.4.3
4) apply io patches
5) upgrade objects in both instances
6) run adprepdb
7) relink applications
8) ensure all objects are valid. recompile views, packages, etc...
9) backup your hard work
because you are using a new oracle home you need to install the
additional software to the new oracle home.
Kevin
Sent: Friday, October 15, 1999 4:17 PM
To: Multiple recipients of list
Subject: System Extremely Slow after upgrade from 7.3.3 to 7.3.4
All;
We upgraded our system from 7.3.3 to 7.3.4 last week and everything
is running 50% slower then before. We looked at the procees.dat,
reg.dat and made sure they were not running, we applied the latest
patch that takes our RDBMS to 7.3.4.4.1.
Any suggestions on what to look for to improve system performace
will
be greatly appreciated.
Thanks in advance...
Jay
From: "Magnuson, Todd" magnusont@FairbanksMorse.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: System Extremely Slow after upgrade from 7.3.3 to 7.3.4
Jay,
We had the same difficulty, and found that setting the database
compatibility to 7.3.4 caused the execution of SQL statements to run very
slow. We changed the setting back to 7.3.3 and the problem went away. I
apologize for the lack of technical detail in this response, if you need
more info contact me Monday 10/18/99 and we can get the detail from our DBA.
HTH
Todd Magnuson
From: Kevin Gillins kgillins@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: System Extremely Slow after upgrade from 7.3.3 to 7.3.4
Can you be more specific when you say everything. Do you mean reports,
online just what part?
Have you made sure to apply the IO patch for reports patch 6.
It comes on the Interoperability CD for 7.3.4 APPS
Kevin