Phase Install Oracle 10g error " linking precompiler common file 10.2.0.1.0"

[Former Member]

Dear Master,

I need your help about my problem.

I install EHP4 and use Oracle 10g, and now error phase install oracle 10g.

linking precompiler common file 10.2.0.1.0

Attach :

installActions2014-01-09_03-12-53PM.log

Please resolution this problem..

regards,

-RhA

[Former Member · Accepted solution]

darryl and Roman N.

Thank your your support.

My problem has been solved with you.

this step by step solved "Phase Install Oracle 10g error " linking precompiler common file 10.2.0.1.0"

1. Step Form Roman (rocomended).

You need to remove cio option for /oracle and /oracle/SBX file systems. You have two options:

1) In ssh session:

smit chfs

select "Change / Show Characteristics of an Enhanced Journaled File System"

select required file system

in Mount OPTIONS delete cio and press enter.

Do the following for /oracle and /oracle/SBX file systems.

2) In ssh session edit /etc/filesytems file (delete option cio for /oracle and /oracle/SBX file systems).

After that remount these file systems and try again.

2. Step From Darryl Griffiths (rocomended)

To implement the solution, execute the following steps:

1. Install bos.adt.libm OS package

2. Relink all of the Oracle executables:

  $ORACLE_HOME/bin/relink all > relink.txt 2>&1

3. Check relink.txt for errors.  For a list of link errors/warnings that can be ignored review:

Note 402945.1 While installing one-off Patch on AIX systems, getting several WARNING messages: OUI-67215 - TOC overflow and/or xlC: not found / xlC: Execute permission denied"

This from oracle standard for AIX 6.1

Oracle Database Preinstallation Tasks

The following operating system filesets are required for AIX 6.1:

• bos.adt.base
• bos.adt.lib
• bos.adt.libm
• bos.perf.libperfstat 6.1.2.1 or later
• bos.perf.perfstat
• bos.perf.proctools
• xlC.aix61.rte:10.1.0.0 or later
• xlC.rte.10.1.0.0 or later
• gpfs.base 3.2.1.8 or later

Thank your Very Much Master Darryl Griffiths and Roman N

regards,

RhA.

[former_member193518]

You can ignore this error.

You don't need that library for Pro*C compiler for SAP.

If you really want to fit it, Oracle Metalink doc "Installing Oracle On Aix:'Error In Invoking Target 'Relink' Of Makefile ...' ld: 0706-006 Cannot find or open library file: -l m (Doc ID 309668.1)"

says:

"One of the required operating system packages (bos.adt.libm) have not been not installed per the installation guide and:

Note:169706.1 Oracle RDBMS on AIX, HP-UX, Solaris, Tru64, Linux: Versions, Sizes, Requirements Quick Reference

SOLUTION

To implement the solution, execute the following steps:

1. Install bos.adt.libm OS package

2. Relink all of the Oracle executables:

$ORACLE_HOME/bin/relink all > relink.txt 2>&1

3. Check relink.txt for errors.  For a list of link errors/warnings that can be ignored review:

Note 402945.1 While installing one-off Patch on AIX systems, getting several WARNING messages: OUI-67215 - TOC overflow and/or xlC: not found / xlC: Execute permission denied"

Regards.

Darryl

[Former Member]

HI,

Oracle requires certain operating system libraries, especially for network activities. Relinking software ensures that these libraries exist and are available in the correct version,,

So there is a problem with Os linking to oracle due to OS support of AIX 6.1 to 10.2.0.1

RK

[Former Member]

your recomended is first before install oracle 10.2.0.0 path first ?

or what your solution..

regards

RhA

[stefan_koehler]

Hi RhA,

we need the mentioned log file to see the linking error.

Linking errors are mostly caused by missing OS packages, bugs or incompatibilities. Linking errors for Oracle 10.2.0.1.0 can also be caused by an unsupported OS / DB version combination which is automatically resolved by applying the corresponding required patchset.

What kind of OS do you use and what is the exact level of it?

Regards

Stefan

[Former Member]

Dear Stefan,

this error log for install oracle :

https://drive.google.com/file/d/0Bx1F0jPrlV1AZ3Q3YVNrZGhzR0U/edit?usp=sharing

This my OS level

# oslevel -r

6100-06

regards,

RhA

[Former Member]

Hi,

Oracle version that you are using is not supported and it is already out of support.

Use latest version of Oracle to avoid such issues.

Regards,

Nick Loy

[Reagan]

Hello

I install EHP4 and use Oracle 10g, and now error phase install oracle 10g.
linking precompiler common file 10.2.0.1.0

As far as I know Oracle 10.2.0.1.0 is not supported with AIX 6.1

You need at least  10.2.0.3

Regards

RB

[stefan_koehler]

Hi,

> You need at least  10.2.0.3

That's alright. The procedure would be to install 10.2.0.1 (ignore the corresponding errors) and patch it to at least 10.2.0.3.

However the provided log file includes the following main errors in addition - for example:

ld: 0711-593 SEVERE ERROR
INFO: : Symbol C_BSTAT (entry 20) in object /oracle/SBX/102_64/lib//libnnz10.a[xpolcnst.o]:
    The symbol refers to a csect with symbol number 0, which was not
    found. The new symbol cannot be associated with a csect and
    is being ignored.

These linking errors are caused by wrong (JFS2) mount options. It seems like the $ORACLE_HOME, staging area or tmp filesystem is mounted with the cio option.

@RhA: Please make sure that you have used the correct mount options (e.g. SAPnote #948294 - AIX JFS2: mount options to use with Oracle 10g / 11g) and restart the installation. It will still raise an error (but the log file should contain a different one then), but you can ignore it. Apply the needed patchset (at least 10.2.0.3) afterwards and the linking will work.

Regards

Stefan

[Former Member]

Check mount options (cio) for file system containing $ORACLE_HOME or upload output of mount command.

[Former Member]

Dear,

his solution..

AIX 6.1 with Oracle >= 11.2.0.2:

AIX 6.1 introduced a new open flag O_CIOR which is same as O_CIO, but this allows subsequent open calls without CIO. The advantage of this enhancement is that other applications like cp, dd, cpio, dbv can access database files in read only mode without having to open them with CIO.

Starting with Oracle 11.2.0.2 when AIX 6.1 is detected, Oracle will
use O_CIOR option to open a file on JFS2.
Therefore you should no longer mount the filesystems with mount option -o cio
Please remove the mount option "-o cio" if you are running Oracle 11.2.0.2 on AIX 6.1 to avoid the following error messages:
cp: A system call received a parameter that is not valid.
0653-902 Cannot open the specified file for reading.
DBV-00100: Specified FILE not accessible
errno(22) A system call received a parameter that is not valid.

I Need step by step, because I newbie..

regards

[Former Member]

@roman N

how to step to check "Check mount options (cio) for file system containing $ORACLE_HOME or upload output of mount command."

[Former Member]

Open ssh session, execute command

# mount

and upload output here.

[Former Member]

Dear Roman.

this Mount my server.

# mount

  node       mounted        mounted over    vfs       date        options

-------- ---------------  ---------------  ------ ------------ ---------------

         /dev/hd4         /                jfs2   Jan 10 10:34 rw,log=/dev/hd8

         /dev/hd2         /usr             jfs2   Jan 10 10:34 rw,log=/dev/hd8

         /dev/hd9var      /var             jfs2   Jan 10 10:34 rw,log=/dev/hd8

         /dev/hd3         /tmp             jfs2   Jan 10 10:34 rw,log=/dev/hd8

         /dev/fwdump      /var/adm/ras/platform jfs2   Jan 10 10:36 rw,log=/dev/hd8

         /dev/hd1         /home            jfs2   Jan 10 10:36 rw,log=/dev/hd8

         /dev/hd11admin   /admin           jfs2   Jan 10 10:36 rw,log=/dev/hd8

         /proc            /proc            procfs Jan 10 10:36 rw

         /dev/hd10opt     /opt             jfs2   Jan 10 10:36 rw,log=/dev/hd8

         /dev/livedump    /var/adm/ras/livedump jfs2   Jan 10 10:36 rw,log=/dev/hd8

         /dev/lv00        /var/adm/csd     jfs    Jan 10 10:36 rw,log=/dev/loglv00

         /dev/oracle      /oracle          jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXoraSBX   /oracle/SBX      jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXoraarch  /oracle/SBX/oraarch jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapbackup /oracle/SBX/sapbackup jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXmirrloga /oracle/SBX/mirrlogA jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXmirrlogb /oracle/SBX/mirrlogB jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapdata1 /oracle/SBX/sapdata1 jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapdata2 /oracle/SBX/sapdata2 jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapdata3 /oracle/SBX/sapdata3 jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapdata4 /oracle/SBX/sapdata4 jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapdata5 /oracle/SBX/sapdata5 jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXsapmnt   /sapmnt          jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXusrsap   /usr/sap         jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/SBXtrans    /usr/trans       jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/origlogA    /oracle/SBX/origlogA jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

         /dev/origlogB    /oracle/SBX/origlogB jfs2   Jan 10 10:36 rw,cio,log=/dev/loglv01

#

[Former Member]

You need to remove cio option for /oracle and /oracle/SBX file systems. You have two options:

1) In ssh session:

smit chfs

select "Change / Show Characteristics of an Enhanced Journaled File System"

select required file system

in Mount OPTIONS delete cio and press enter.

Do the following for /oracle and /oracle/SBX file systems.

2) In ssh session edit /etc/filesytems file (delete option cio for /oracle and /oracle/SBX file systems).

After that remount these file systems and try again.

[Former Member]

Looks like some missing libraries .. can you please check this thread

And paste the output of the make.log file

Thanks

Rishi

[Former Member]

Dear Rishi Das,

this log form error oracle.

installActions2014-01-09_03-12-53PM.log - Google Drive

I can't paste here because the size big.

maybe your can solved my issue..

regards,

RhA.