12-11-2003 03:38 AM
What are the Pros and Cons of 11.0 and 11i?
What is involved in upgrading to 11i?
We will be using Cognos's Powerhouse along with Oracle 8i.
Solved! Go to Solution.
12-11-2003 03:49 AM
You need to start with make_tape_recovery backup, because of reliability issues with update-ux.
11i is industrial strength, more secure, more reliable and feature rich than 11.00. It is a good upgrade to do.
A better course of action in my place is to get a clean 11i box going, reinstall your applications and then migrate your data. Thats old school, but its worked for us. Its worth buying or leasing short term hardware to do.
Note that Oracle 8i support expires this month and in two years will be completely unotainable.
Plan a database upgrae when your apps support it.
Owner of ISN Corporation
12-11-2003 03:51 AM
Ot if you really want to go for straight Then upgrade from 11 to 11i is not so troublesome as it was from 10.20 to 11i.
Take backup of your VG other then vg00
(vgexport -p -v -m...)
32bit and 64bit applications will be taken care well in 11 and 11i.
Here is the doc whigh wil be handy
12-11-2003 03:51 AM
The differences are subtle. 11i is more robust, more flexible, offers dyanmically tuned kernel parameters, but overall it feels very familiar. The main reason I can see to upgrade is stability. The OS itself is quite solid and will be around for quite some time to come, thus minimizing your future upgrade efforts.
As to the upgrade process itself, many will advise you to cold install, import your non-root volume groups and carry on. This is the path I've always followed, however, I have heard from reliable sources that the actual upgrade process is quite smooth, unlike the 10.20 to 11.o process, particulary if your root file systems are adequately sized to start with. I would say it's a toss-up and you should go with whichever makes you feel most comfortable.
You'll need to check whether Oracle or Powerhouse will need to be upgraded at the same time or whether the current versions will work with 11i.
Other than that, good luck!
12-11-2003 03:56 AM
I didn't check oracle 8i we are on Oracle 8 now and I think it has been out of support since June. I better check with the Apps people and see why we can not use 9i.
We do have 2 servers "A" and "N" so we will make ate "A" work then the production box "N".
12-11-2003 04:03 AM
It is the Oracle 8i and Powerhouse I beter check on. I can't always be sure on the VAR for the Apps.
12-11-2003 05:35 AM
HPUX 11i Upgrade Plan server1
1. Split vg00 mirror
a. lvreduce -m 0 /dev/vg00/lvol1 /dev/dsk/c2t6d0
b. lvreduce -m 0 /dev/vg00/lvol2 /dev/dsk/c2t6d0
c. lvreduce -m 0 /dev/vg00/lvol3 /dev/dsk/c2t6d0
d. lvreduce -m 0 /dev/vg00/lvol4 /dev/dsk/c2t6d0
e. lvreduce -m 0 /dev/vg00/lvol5 /dev/dsk/c2t6d0
f. lvreduce -m 0 /dev/vg00/lvol6 /dev/dsk/c2t6d0
g. lvreduce -m 0 /dev/vg00/lvol7 /dev/dsk/c2t6d0
h. lvreduce -m 0 /dev/vg00/lvol8 /dev/dsk/c2t6d0
i. vgreduce /dev/vg00 /dev/ dsk/c2t6d0
2. Stop application
4. Stop NFS client
a. /sbin/init.d/nfs.client stop
5. Mount HPUX 11i Disc 1
6. Start install procedure
a. script /tmp/OSupgrade
b. mount /dev/cdrom /SD_CDROM
c. swinstall -r -s /SD_CDROM Update-UX \@ /var/adm/sw/Update-UX.root 2>/dev/null
d. edit /usr/lib/sw/update-ux.cfg file and comment out all lines that contain JAVAOOB
e. update-ux -s /SD_CDROM HPUX11i-OE
7. Follow Instructions
9. Install Mirror Disk using swinstall
10. Install Online JFS using swinstall
11. Install Glance using swinstall
13. Verify LAN interfaces are set to 100FD using lanadmin
14. If interfaces are set to HD, run the following to set them to FD
15. lanadmin -X FD (PPA #)
16. mirror vg00
a. pvcreate -B /dev/rdsk/c2t6d0
b. vgextend /dev/vg00 /dev/dsk/c2t6d0
c. mkboot -l /dev/rdsk/c2t6d0
d. mkboot -a "hpux -l q (;0)/vmunix" /dev/rdsk/c2t6d0
e. lvextend -m 1 /dev/vg00/lvol1 /dev/dsk/c2t6d0
f. lvextend -m 1 /dev/vg00/lvol2 /dev/dsk/c2t6d0
g. lvextend -m 1 /dev/vg00/lvol3 /dev/dsk/c2t6d0
h. lvextend -m 1 /dev/vg00/lvol4 /dev/dsk/c2t6d0
i. lvextend -m 1 /dev/vg00/lvol5 /dev/dsk/c2t6d0
j. lvextend -m 1 /dev/vg00/lvol6 /dev/dsk/c2t6d0
k. lvextend -m 1 /dev/vg00/lvol7 /dev/dsk/c2t6d0
l. lvextend -m 1 /dev/vg00/lvol8 /dev/dsk/c2t6d0
m. lvlnboot -b /dev/vg00/lvol1
n. lvlnboot -s /dev/vg00/lvol2
o. lvlnboot -r /dev/vg00/lvol3
p. lvlnboot -R /dev/vg00
q. lvlnboot â v
12-11-2003 06:11 AM
We have the problem here and are mainting an obsolete D380 with a Service conract to keep Cognos Datamart running with 8i right now. It is most frustrating.
Owner of ISN Corporation
12-11-2003 06:18 AM
Our ERP system is Visibility and it uses Powerhouse 813d3 and it has a leak so we use 733D3 for the batch jobs. The batch jobs run 50-70% slower with PH8. The new version is going to fix that. We so they say. It looks like I will be on Oracle 8i for now too.
Every little bit helps.
12-11-2003 06:28 AM
1. on server A, make_tape_recovery for OS, in case you need to roll back
2. full backup for data on server A
3. cold install 11i OE on server B, for the file system, you may need larger /usr and /opt
4. install HP applications, i.e. Mirror/UX, MC/SG, etc.
5. vgexport on server A, copy over the map files, then vgimport on server B.
6. create mount point, mount file system and modify /etc/fstab, be careful in terms of the vg00 layout, 11i is different comparing with 11.
7. restore all the data from backup
It is only some highlight steps trying to give you a big picture, for Oracle, you need to do some relink and modify related configuration files, just my two cents.
12-12-2003 05:25 AM
If you are planning to move to Oracle 8i, then don't forget to apply the latest patch (188.8.131.52)
However, if you applications can run on Oracle 9i DB (release 2), that would be a much better move.
01-19-2004 02:08 AM
We are going to proceed to the HP-UX upgrade by simply mount the shared space to the server that has already installed the HP-UX 11i. Do you thing that we have to do something further?
How do I have to proceed in order to relink the Oracle?
Thanks a lot