ORA-12547: TNS:lost contact

[tyagi.ankur07]

Hi Erman,

I did the cleanup and freshly installed OH for 11.2.0.4 software ONLY but it is still failing with the same issue.
INFO: ld: 0711-415 WARNING: Symbol ldxdts is already exported.
ld: 0711-415 WARNING: Symbol ldxsto is already exported.
ld: 0711-415 WARNING: Symbol lnxadd is already exported.
ld: 0711-415 WARNING: Symbol lnxcopy is already exported.
ld: 0711-415 WARNING: Symbol lnxmin is already exported.
ld: 0711-415 WARNING: Symbol lnxmul is already exported.
ld: 0711-415 WARNING: Symbol lnxnur is already exported.
ld: 0711-415 WARNING: Symbol lnxren is already exported.
ld: 0711-415 WARNING: Symbol lnxsca is already exported
INFO: .
ld: 0711-415 WARNING: Symbol lnxshift is already exported.
ld: 0711-415 WARNING: Symbol lnxsni is already exported.
ld: 0711-415 WARNING: Symbol lxgu2t is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.

INFO: ld: 0711-224 WARNING: Duplicate symbol: fc_softc

INFO: ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env

INFO: ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.

INFO: ld: 0711-317 ERROR: Undefined symbol: .decimal128ToNumber

INFO: ld: 0711-317 ERROR: Undefined symbol: .decContextDefault
ld: 0711-317 ERROR: Undefined symbol: .decNumberExtractBiasedExponent
ld: 0711-317 ERROR: Undefined symbol: .decNumberZero
ld: 0711-317 ERROR: Undefined symbol: .decNumberInsertBiasedExponent
ld: 0711-317 ERROR: Undefined symbol: .decNumberAdd
ld: 0711-317 ERROR: Undefined symbol: .decimal64FromNumber

INFO: ld: 0711-317 ERROR: Undefined symbol: .decimal64ToNumber
ld: 0711-317 ERROR: Undefined symbol: .decNumberMultiply
ld: 0711-317 ERROR: Undefined symbol: .decNumberToIntegralValue
ld: 0711-317 ERROR: Undefined symbol: .decimal128FromNumber
ld: 0711-317 ERROR: Undefined symbol: .decNumberToLongLong
ld: 0711-317 ERROR: Undefined symbol: .decNumberSubtract
ld: 0711-317 ERROR: Undefined symbol: .decNumberCompare

INFO: ld: 0711-317 ERROR: Undefined symbol: .decimal32ToNumber
ld: 0711-317 ERROR: Undefined symbol: .decimal32FromNumber

INFO: make: 1254-004 The error code from the last command is 8.


Stop.

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'irman ioracle' of makefile '/u01/oracle/VIS/db/tech_st/11.2.0/rdbms/lib/ins_rdbms.mk'. See '/u01/oracle/oraInventory/logs/installActions2017-08-21_09-28-42PM.log' for details.
Exception Severity: 1

Thanks,
Ankur

[ErmanArslansOracleBlog]

We need to make a remote session then...

Tomorrow, I will be available.

Tomorrow, at 9:00 AM ETC+3

okay?

[tyagi.ankur07]

ok, sounds good.
6 AM ETC i.e. 6:30 PM IST

[ErmanArslansOracleBlog]

Tomorrow 9 AM istanbul time? ok?

[tyagi.ankur07]

ERM.out

uploaded requested file.

Thanks,
Ankur

[ErmanArslansOracleBlog]

Okay. irman is relinked successfully, but relink for ioracle (oracle binary) fails.
So, we copied the relink command generated by "make -f ins_rdbms.mk ioracle"
we copied it into a script and included the -bnoquiet argument in it.
Then, we executed it again to produce a detailed log file.
this ERM.out is that logfile, and I will analyze it.

I will get back to you.

[ErmanArslansOracleBlog]

There is some problem with libm.a . It is IEEE Math Library.

Do you have this directory ? "/src/bos/usr/ccs/lib/libm/"

Or any diretory similar to it?

send me the output of find / -name libm      (execute it with root)
send me the output of find / -name src/bos   (execute it with root)
send me the output of find / -name expd.c (execute it with root)

Send me the outpuf of the following commands as well;

getconf HARDWARE_BITMODE
getconf KERNEL_BITMODE

[tyagi.ankur07]

root@aixxpp1:/-> ls -l /src/bos/usr/ccs/lib/libm/
ls: 0653-341 The file /src/bos/usr/ccs/lib/libm/ does not exist.

-bash-4.2$ getconf HARDWARE_BITMODE
64
-bash-4.2$ getconf KERNEL_BITMODE
64

Unable to find below files
send me the output of find / -name libm      (execute it with root)
send me the output of find / -name src/bos   (execute it with root)
send me the output of find / -name expd.c (execute it with root)

[ErmanArslansOracleBlog]

Hi,

This seems to be a pure AIX issue.

Some of the symbols that are specified in the out file that we produced, seem to be missing.
We need to find the source o this symbols.

We can do it by using the tool named symfind

Do you have any other AIX 7.1 environment? We need to compare it with this problematic one.

Run the following command on a proper AIX Oracle environment and send me the output.

symfind .decimal128ToNumber

Run the following command on the problematic AIX Oracle environment and send me the output.

symfind .decimal128ToNumber

Note: I hope smyfind is installed on your AIX machines.
Get the AIX admin's help if needed.

[ErmanArslansOracleBlog]

Also ensure the following in place.(nothing more , nothing less)

AIX 7.1 required packages:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
xlC.rte.11.1.0.2 or later
gpfs.base 3.3.0.11 or later (Only for RAC systems that will use GPFS cluster filesystems)


APARs for AIX 7.1:
IZ87216
IZ87564
IZ89165
IZ97035
See Note:1264074.1 and Note:1379908.1 for other AIX 7.1 patches that may be required

Refer to the 11.2 AIX Install Guide. Part Number E24332-01
Important: Please see Note 282036.1 for the latest patching requirements