Re: Oracle V6.0.36.7.1, HPUX 8.02, unsat sym $$sh_func_adrs

In article <1qer58$htj_at_spock.dis.cccd.edu> markb_at_cccd.edu writes:
:^() We just upgraded Oracle to V6.0.36.7.1, and now when we try to compile our
:^() Pro*C and Pro*COBOL applications with embedded SQL, /bin/ld barfs with an
:^() unsatisfied symbol of $$sh_func_adrs.
:^()
:^() We called Oracle, and they are currently clueless. It's probably something
:^() stupid like a missing library in a makefile.
:^()
:^() We'd greatly appreciate a solution from anybody that's seen this problem. The
:^() issue is hot here, with multiple people sitting around twiddling their thumbs
:^() waiting for a resolution. Please send e-mail, and I'll summarize later.
:^()
:^() Thanks!

Taking a stab at it since I have seen this before, but under different circumstances (or maybe similar). We found this problem when we moved another RDBMS other than Oracle from a machine that was based on the PA-RISC 1.0 to a machine running the PA-RISC 1.1. The archive library that was build on a 835 well linked into another executable on a 817 gave this link error. It seems to be a known problem with the C compiler on the 8X7 series running 8.02. The library in question looks to be /lib/milli.a. You can check this by something like:

% nm /lib/milli.a | grep sh_func_adrs
$$sh_func_adrs | 0|extern|milli |$MILLICODE$

The HP Response Center has a fix available, reference patch id PHSS_0960.

Here is some more info from the patch text:

Patch name: PHSS_0960

Patch Description: All C compiler fixes through 3/26/92.

Path Name: /hp-ux_patches/s800/8.X/PHSS_0960

Effective Date: 920326

Patch Files:

    bin/cc
    lib/ccom
    lib/milli.a
    usr/lib/nls/C/cc.cat

SR#:

    5003-046888
    5003-046896

"what" string:

bin/cc:

        HP92453-01 A.08.79 HP C Compiler lib/ccom:

        HP92453-01 A.08.79 HP C Compiler
         HP-UX SLLIC/OPTIMIZER UX.08.07.08 (IF2 Patch) 11/27/91
lib/milli.a:
        Millicode 12.34 for libc
usr/lib/nls/C/cc.cat:
        HP92453-01 A.08.79 HP C Compiler Copyright 1985, Hewlett-Packard Co.

"sum" output:
     65474 228 bin/cc
     36817 2608 lib/ccom
     39961 437 lib/milli.a
     4777 99 usr/lib/nls/C/cc.cat

Dependencies: NONE

Supersedes: PHSS_0466 and PHSS_0933

Patch Package Size: 1760 Kbytes

Hope this helps!

-- 
Max Maklin                                                P.O. Box 9707 
Technical Analyst	                           3755 Riverside Drive
Cognos Incorporated                              Ottawa, Ontario CANADA
Internet: maklinm_at_cognos.COM                 UUNet: maklinm_at_cognos.UUCP