Oracle 11.2.0.2 on HP_UX ( unsatisfied symbol error )

[burhaneser]

Hi,

We are facing a problem in the company while installing Oracle on our Itanium based 64 bit HP_UX 11i v3 installed machine. 

The problem is when linking netclient executables.  The error is posted below.

The weird thing is when i look at the log for error i see  :  "Unsatisfied symbol "ntcontab" in file /u01/app/oracle/product/11.0.2/lib//libclntsh.so"

as you see there is double-slash ( // ) after the directory name "lib" . I dont know why it produces a path like that. The library file aimed to be find by oracle is under /u01/app/oracle/product/11.0.2/lib. But the double-slash causes the installation miss the file and throw an error. 

I set the LD_LIBRARY_PATH environment variable to $ORACLE_HOME/lib where ORACLE_HOME is set to  /u01/app/oracle/product/11.0.2 and i am not putting any extra slashes after environment vairables. 

I also attached the error windows to this post.

I have no idea what causes this erorr arise but i am in need of urgent help to figure out how to solve this  problem.

I hope to hear back from you.

Detail of hardware and software platfroms:

$ uname -a

HP-UX bordo B.11.31 U ia64 0775201059 unlimited-user license

$machinfo

CPU info:  2 Intel(R)  Itanium(R)  Processor 9340s (1.6 GHz, 20 MB)          4.79 GT/s QPI,

CPU version E0          8 logical processors (4 per socket)
Memory: 65434 MB (63.9 GB)
Firmware info:   Firmware revision:  01.09   

FP SWA driver revision: 1.18   IPMI is supported on this system.   

BMC firmware revision: 1.30
Platform info:   Model:                  "ia64 hp Integrity rx2800 i2"   
OS info:   Nodename:  bordo   Release:   HP-UX B.11.31   Version:   U (unlimited-user license)   Machine:   ia64   ID Number: 0775201059   vmunix _release_version:            

  @(#) $Revision: vmunix:    B.11.31_LR FLAVOR=perf 

The piece of log containing error.

INFO: Calling Action unixActions10.2.0.3.0  make
	registerOnly = false
	installMakePath = /usr/ccs/bin/make
	installMakeFileName = /u01/app/oracle/product/11.0.2/network/lib/ins_net_server.mk
	installTarget = install
	undoMakeFileName = 
	installArguments = ORACLE_HOME=/u01/app/oracle/product/11.0.2
	logFile = /u01/app/oracle/product/11.0.2/install/make.log
	undoTarget = 
	progMsg = Linking netclient Install Executables

INFO: Linking netclient Install Executables
INFO: Linking netclient Install Executables
INFO: The output of this make operation is also available at: '/u01/app/oracle/product/11.0.2/install/make.log'
INFO: 

INFO: Start output from spawned process:
INFO: ----------------------------------
INFO: 

INFO: 	/bin/chmod 755 /u01/app/oracle/product/11.0.2/bin/

INFO:  - Linking tnslsnr

INFO: 	rm -f tnslsnr

INFO: 	    cc -Wl,+k -Wl,+s -Wl,+n +DD64 -o tnslsnr -L/u01/app/oracle/product/11.0.2/network/lib/ -L/u01/app/oracle/product/11.0.2/lib/  /u01/app/oracle/product/11.0.2/network/lib/s0nsgl.o /u01/app/oracle/product/11.0.2/network/lib/snsglp.o -lclntsh  `cat /u01/app/oracle/product/11.0.2/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.0.2/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11  -lvsn11  -lcommo
INFO: n11 -lgeneric11 -lmm -lsnls11 -lnls11  -lcore11 -lsnls11  -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11  -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.0.2/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.0.2/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11  -lvsn11  -lcommon11 -lgeneric11   -lsnls11 -lnls11  -lcore11 -lsnls11  -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11  -lcore11 -lunls11 -lsnls11 
INFO: -lnls11 -lcore11 -lnls11  -lclient11 -lnnetd11  -lvsn11  -lcommon11 -lgeneric11 -lsnls11 -lnls11  -lcore11 -lsnls11  -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11  -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11   `cat /u01/app/oracle/product/11.0.2/lib/sysliblist`  -lm    `cat /u01/app/oracle/product/11.0.2/lib/sysliblist`  -lm  -lpthread -lrt  -lpthread -lons  -lnl11     -ln11  -lnlsnr11 -lnlsnrc11 -lnsgr11  -lnms  -lncm11 -lnmsp -lpeer  -lnro11 -ln11    -lnl11  -lnlsnr11 -lnlsnrc11  -lnms  -lncm11 -lnmsp
INFO:   -ln11      -lm 

INFO: ld: (Warning) Unsatisfied symbol "nnfgtable" in file /u01/app/oracle/product/11.0.2/lib//libclntsh.so

INFO: ld: Unsatisfied symbol "ntconent" in file /u01/app/oracle/product/11.0.2/lib//libclntsh.so
ld: (Warning) Unsatisfied symbol "ntcontab" in file /u01/app/oracle/product/11.0.2/lib//libclntsh.so

INFO: ld: (Warning) Unsatisfied symbol "nnfgtent" in file /u01/app/oracle/product/11.0.2/lib//libclntsh.so

INFO: 3 warnings.
1 errors.

INFO: *** Error exit code 1

INFO: 
Stop.

INFO: End output from spawned process.

[burhaneser]

Oh and one more thing.

When installing it ,  Oracle says the patch PHSS_37042 is missing. I dont know if this OS patch has  antyhing to do with this path problem. I couldn't find the patch anywhere on the net or on the server.

[Stephan.]

Hi,

you need an active support contract to get the Patch, find below the first part of the readme:

Patch Name: PHSS_37042

Patch Description: 11.31 hppac

Creation Date: 07/08/30

Post Date: 07/08/31

Hardware Platforms - OS Releases: 
	11.31

Products: N/A

Filesets: 
	OS-Core.CORE2-SHLIBS,fr=B.11.31,fa=HP-UX_B.11.31_IA,v=HP
	OS-Core.CORE2-64SLIB,fr=B.11.31,fa=HP-UX_B.11.31_IA,v=HP
	ProgSupport.C2-INC,fr=B.11.31,fa=HP-UX_B.11.31_IA,v=HP

Automatic Reboot?: No

Status: General Release

Critical: No

Category Tags: 
	defect_repair enhancement general_release

Path Name: /hp-ux_patches/11.X/PHSS_37042

Symptoms: 
	PHSS_37042:
	JAGag39125: This is an enhancement request for
		    Itanium-based HP-UX 11.23 (and later versions)
		    to support HPPAC(3000-mode packed-decimal
		    library). The library file
		    "/usr/lib/hpux64/libcl.so" exists on
		    Itanium-based HP-UX 11.23 system but there are
		    no HPPAC symbols. The HPPAC library functions
		    were used to port HP3000 business applications
		    to PA-RISC HP-UX systems. These same functions
	            are needed on Itanium-based systems to allow
	            migration to Itanium-based HP-UX 11.23.

Defect Description: 
	PHSS_37042:
	JAGag39125: ER: provide HPPAC(3000-mode packed-decimal
		    library) for Itanium HP-UX

Enhancement: 
	Yes
	PHSS_37042:
	    This patch delivers the HPPAC(3000-mode packed-decimal
	    library) for Itanium HP-UX.

SR: 
	8606486228

 hth,

Stephan

[burhaneser]

Thanks for the reply. I guess we do have the contract ( i am actually new here :) ) I will look into it.

So it is about the patch or ?

I acutally have another server machine which has Oracle installed on and it doesn't seem to have the patch either.

I have no clue here.

[burhaneser · Accepted solution]

Ok iam shocked.

I only increase the size of temp directory and all of a sudden it worked. I never thought it would be about temp size increasing. 

Or it was something else and i couldnt get what :S 

Well i am glad it is solved but i would be happier if i knew how it was solved.

It cant be about increasing temp size, can it ? 

[Dennis Handly]

I doubt that PHSS_37042 is your problem:

PHSS_37042 11.31 hppac (packed decimal)

I'm not sure why you can't find that patch?

>as you see there is double-slash (//) after the directory name "lib"

These are not the droids you are looking for.

That's due to sloppiness in the makefile.  There is a "/" at the end of several -L paths.

You should be talking to Oracle about your unsat.

>It can't be about increasing temp size, can it ?

It's possible.  There could be some unchecked errors that cause files to be truncated.

If you want to be a detective, put things back and use tusc to see where the failures are.

[burhaneser]

I will definetly look into it to find out what exactly the problem was.

But since i didnt do anything except increasing the temp size it must be about it.

Well i should have thought increasing it earlier :) But it is working now anyway and i am happy about it :)

Thanks for the replies. 

[Steven E. Protter]

Shalom,

Oracle installation checks the OS for patches it needs.

It checks kernel paramters and other factors ir requires for normal operations.

What is supposed to happen is if any of these factors are missing, the install stops cold and tells the installer what the issue is.

Due to the nature of a complex operating system sometimes patches get superseded with new patches and the oracle instaleller is not updated to know this. Therefore there are ways to bypass requirements of the oracle installer. Sometimes the installer does this itself.

What has probably happened here is the is the installer bypassed a requirement and continued and later in the process missing software caused the install to fail.

I recommend going back to the oracle install guide, following the pre-requisites carefully and trying again.

Also note for HP-UX SHLIB_PATH is used for most installations like this, not LD_LIBRARY_PATH. This may have changed though since I last worked one of these installations.

It is important also to have an application user for the install. Only steps specifically requiring root should use root user.

SEP

[Dennis Handly]

>SHLIB_PATH is used for most installations like this, not LD_LIBRARY_PATH.

LD_LIBRARY_PATH is the correct variable to use for Integrity.  Unless dealing with PA32 under Aries.

[Steven E. Protter]

Shalom again,

Oracle allowes you to set a variable and redirect its temporary directory from /tmp to another file system with sufficient space for the install.

SEP