General
cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

Martin MABIKA
Occasional Contributor

Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

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
mmabika
6 REPLIES
Steven E. Protter
Exalted Contributor

Re: Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
James A. Donovan
Honored Contributor

Re: Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

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
Remember, wherever you go, there you are...
T G Manikandan
Honored Contributor

Re: Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

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
Honored Contributor

Re: Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Alexander M. Ermes
Honored Contributor

Re: Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Martin MABIKA
Occasional Contributor

Re: Upgrating oracle 8.1.5 to 8.1.7 under hpux 11.0

Hi all,

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

Martin
mmabika