Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AIX Oracle Question

Status
Not open for further replies.

Mag0007

MIS
Feb 15, 2005
829
US
If I were to do a AIX upgrade (4.3.3 to 5.2), would i need to deinstall Oracle 8i?

Asking because: I am sure I have to deinstall my EMC and TSM client because they were installed via installp.

 
I've done this numerous times and never had to uninstall. Make sure you mksysb & savevg before hand.

Mike

"A foolproof method for sculpting an elephant: first, get a huge block of marble, then you chip away everything that doesn't look like an elephant.
 
Thanks for the confidence! I appreciate that!

 
If I recall correctly, 8.1.7 is the minimum version required for AIX5.2 for 32 bit and 9.2.0 for 64 bit

greetz

R.
 
I recently did a migration from Aix 4.3 to 5.3 and didn't have to do anything with Oracle (8.1.5). I did find a few things worth knowing about. After the migration install any vmtune changes i made in 4.3 were lost and my ulimits for the oracle user went back to default.

Hope this helps
 
You should relink oracle after finishing os-migration (using relink all in $ORACLE_HOME/bin as oracleowner).

Stefan
 
oracle 8.1.5 has been 'out of service' for some time, but as it is 32bit, it should still work on AIX5.2 as the AIX 32bit runtime environment hasn't changed since AIX4.3.3.

oracle relink all still is a good idea anyway.

I run 8.1.7 databases on AIX5.2 for an SAP system that has been stagnant at SAP4.6/ORA817-32 for some time. Will probably go to 9i-64 in the near future...

Make sure you keep the AIX kernel at 32bit, because you need to install kernel extensions for your oracle software that won't fit in a 64bit AIX kernel.

if you set vmtune attribute of sys0 to pre-5.2 then you can keep on using your /etc/rc.vmtune script or the like, but you will have to modify it

The vmtune sample program has been replaced by vmo and ioo commands. If you have an output of vmtune on 4.3.3 and run vmo -L and ioo -L on 5.2 you'll get the idea which tunable needs to be set. vmo and ioo are a bit picky on which tunable you set first, because there are some dependencies.


HTH,

p5wizard
 
p5wizard:

good post!

How can I make sure I still have my 32bit stuff there?

Our oracle 8.1.7 is not relinking because of a 32bit stuff.

 
what do you mean - still have 32bit stuff?

show (partial) output of relink please, that might give us some idea of what you are missing.

HTH,

p5wizard
 
p5wizard:

problem has been FIXED! I had to download a patch from Oracle. I think the patch will change your kernel extensions, and kaboom! it works

AGAIN! thanks for ALL of your help!

:)


 
Yes,

oracle has created a 64-bit version of the post-wait kernel extension...

Another solution would have been (as mentioned earlier) to revert to AIX 32-bit kernel, then your AIX43 post-wait kernel extension (32bit) version would have loaded and oracle would have started.

there is info on how to change between aix 32bit and 64bit kernel in this forum.



HTH,

p5wizard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top