Tag Archives: 11.2.0.3

Oracle RAC 11g R2 on AIX 7.1 installation issue on irman relink

If you are installing Oracle RAC 11g R2 on AIX 7.1, you may have the following error:

You press retry and the installation finish without any more errors. This error will occour on both CRS installation and Database installation.

After that I had a ORA-03113: end-of-file on communication channel on dbca database creation.

Checking installation log I found the following error:

0711-780 SEVERE ERROR: Symbol .ksmpfpva

It can happen during installation, re-linking or patching

If the relink error is ignored, the following error is reported when shutting down database:

ORA-03113: end-of-file on communication channel

In instance alert.log:

ORA-07445 [ksmpclrpga()+23248]

Call stack from trace file:

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ssexhd 47dc opidcl opidrv sou2o opimai_real ssthrdmain main start

This problem is also known to generate large core files at the time of hitting ORA-7445 [ksmpclrpga]:
A core file is likely generated in $ORACLE_HOME/dbs

Cause

AIX OS issue.

Solution

The following AIX fix needs to be applied:

For AIX 7.1 apply IFIX IV09541: https://www-304.ibm.com/support/docview.wss?uid=isg1IV09541

At the time of this writing, IBM has pre-built the iFixes and uploaded to:

ftp://public.dhe.ibm.com/aix/efixes/

where the APAR numbers are:

5.3 TL11 – iv10538
5.3 TL12 – iv11158
6.1 TL4 – iv11167
6.1 TL5 – iv10576
6.1 TL6 – iv10539
6.1 TL7 – iv09580
7.1 TL0 – unaffected
7.1 TL1 – iv09541

Once the OS patch is applied, relink oracle binary so it will be effective.

in Oracle Support

This worked for me…

I hope it was useful!!!
Cheers

Optimization WordPress Plugins & Solutions by W3 EDGE