Upgrade from 8.1.7.4 to 9.2

[Michael I. Odesanya]

Are there any pre-requisite HP-UX 11i patches to apply before upgrade of Oracle database 8.1.7.4 to 9.2

[Steven E. Protter]

Yes.
metalink doc 43507.1
These patches should have already been installed but you should check. All of these should be checked for revision at itrc.

6. C++ runtime libs

Current Revision of Patch:

PHSS_26946 - s700_800 11.11 HP aC++ -AA runtime libraries (aCC A.03.37)

Patch in latest Support Plus Patch Bundle? Yes, as PHSS_22898.

5. asyncio driver patch

- slow database startup with large SGAs

Current Revision of Patch:

PHKL_25506 - s700_800 11.11 asyncio driver patch

Patch in latest Support Plus Patch Bundle? Yes, as PHKL_25506.

4. ONC/NFS General Release/Performance Patch

Current Revision of Patch:

PHNE_26388 - s700_800 11.11 ONC/NFS General Release/Performance Patch

Patch in latest Support Plus Patch Bundle? Yes, as PHNE_26388.

3. ld and linker tools cumulative patch

Current Revision of Patch:

PHSS_26560 - s700_800 11.11 ld(1) and linker tools cumulative patch

Patch in latest Support Plus Patch Bundle? No.

2. libc cumulative patch

Current Revision of Patch:

PHCO_27740 :s700_800 11.11 libc cumulative patch

Patch in latest Support Plus Patch Bundle? Yes, as PHCO_25452.

1. libc cumulative header file patch

Current Revision of Patch:

PHCO_24402 :s700_800 11.11 libc cumulative header file patch

Patch in latest Support Plus Patch Bundle? Yes, as PHCO_24402.


SEP

[Judy Traynor]

You can get this info at metalink.oracle.com, but in short, I do not have the specific patch list. What I can tell you though, is that if you patch your system after the upgrade of oracle, you may need to relink your oracle installation (which is fairly benign)

Good luck

[Steven E. Protter]

Found another document.

Different patch list too.

HP-UX 11i (64 Bit) Operating System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later
JDK 1.3.1.02
PHNE_27745
PHNE_28568
PHKL_25506
PHSS_26560
PHSS_26946
PHSS_28849
PHSS_26946
PHSS_26560
PHCO_28427
PHCO_24402

Bonus. Kernel stuff.

KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

Yes, I'm doing pre upgrade planning right now and might be starting the upgrade shortly.

SEP

[Yogeeraj_1]

hi,
You can also run the installprep.sh script that is provided by Oracle.
-
PURPOSE
Script to verify that the system is configured correctly according to the Installation Guide. The output of the script will report tasks that need to be performed before successfully installing Oracle 9.x DataServer (RDBMS).
-
SCOPE & APPLICATION
Anyone planning to install the Oracle DataServer (RDBMS) on an HP those that are not familiar with operating system configuration.
-
hope this helps too!
regards
Yogeeraj

[Yogeeraj_1]

InstallPrep.sh

[Michael I. Odesanya]

Steve,
I need the document you stated in your response and any other document for 9i upgrade, so I could review same.
Thanks,