Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

[Martin MABIKA]

Our system is a 64 bits and we want to upgrade oracle 64 bit 8.1.5 to 8.1.7 64 bits
But when I do file /usr/bin/cc, I have got
/usr/bin/cc: PA-RISC1.1 shared executable
All binaries make, ar, ld, nm,cc are on 32-bits.
I am afraid to get oracle 32-bits after installation. Any suggestions.
Thanks in advance

Martin

[Steven E. Protter]

Your path is correct.

32 bit binaries are really not a problem. You will have to do a 32 bit to 64 bit word size conversion of the data.

I'm attaching a document that tells how to do this. Its important to follow this document precisely or whatever document superseded it at metalink or the database my function after confersion, but not properly.

SEP

[James A. Donovan]

This should be a pretty straightforward upgrade.

Use chatr to check the current size of your Oracle binaries.

It should say that it is a 64-bit ELF executable. If so, then just apply the appropriate patches to upgrade. If not, then you'll need to go through the 32-to-64 bit word size change process.

$ chatr $ORACLE_HOME/bin/oracle
chatr $ORACLE_HOME/bin/oracle
/oracle/8.1.7/bin/oracle:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third /oracle/8.1.7/rdbms/lib64:/oracle/8.1.7/lib64:/usr/lib/pa20_64:/opt/langtools/lib/pa20_64:
shared library list:
libjox8.sl
libobk.sl
librt.2
libpthread.1
libnss_dns.1
libdl.1
libm.2
libc.2
shared library binding:
deferred
global hash table disabled
shared library mapped private disabled
shared library segment merging disabled
shared vtable support disabled
segments:
index type address flags size
6 text 4000000000000000 z-r-c 16M
7 data 8000000100000000 ---m- 64M
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation for dynamic segments disabled

[T G Manikandan]

I do not find any problem with the upgrade.do not bother on those executables.THis should work.

make sure you are installing the 64 bit version of 8.1.7.

Backup you current state before proceeding forward.

[Yogeeraj_1]

hi martin,

as long as you are installing the right 64-bit version of 8.1.7, there should not be any problem.

Most important of all. PROPER BACKUP!

Also, consider installing the latest patchset. i.e. 8.1.7.4.

all the best
Yogeeraj

[Alexander M. Ermes]

Hi there.
Another strategy :

export data from 8.1.5 database
parameters :

buffer=1000000 ??
compress=y
grants=y
indexes=y
rows=y
constraints=y
full=yes


shutdown database

create database under 8.1.7

import data
.
That would mean you have a proper 8.1.7 installation AND you get rid of all fragmentation in your database.

Just my 2 ct.
Rgds
Alexander M. Ermes

[Martin MABIKA]

Hi all,

I do not have problem during oracle upgrade, despite 32-bits binaries (cc, make, ar, ld, etc.).
Thanks a lot.

Martin