Pro*C compilation uder IBM AIX OS

Hi woolmilkporc,

I can find libclntsh.a file in lib and lib32 folder in the $ORACLE_HOME.

Previously makefile was designed for HP UX and   CXXFLAGS was following:
CXXFLAGS = -L$(ORACLE_HOME)/lib32 -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/rdbms/lib/ -L/usr/lib/ -L./ -L$(ORACLE_HOME)/sqlplus/lib/ -L$(ORACLE_HOME)/ctx/lib -L$(ORACLE_HOME)/network/lib -lclntsh

with this settings there is possible to compile program, but when I try to execute it I have received message:
Could not load program gnvprgrun:
        Dependent module /oracle/product/home0/lib/libclntsh.a(shr.o) could not be loaded.
        The module has an invalid magic number.

LIBPATH=/oracle/product/home0/lib:/oracle/product/home0/lib32:/lib:/usr/lib:/usr/local/lib
settings is required by another application provided by vendor.

As I understand invalid magic number is connected with usage 64bit library placed in bin.

so I have changed
CXXFLAGS  from -L$(ORACLE_HOME)/lib32 to -L$(ORACLE_HOME)/lib and
ld: 0711-317 ERROR: Undefined symbol: .sqlcxt
ld: 0711-317 ERROR: Undefined symbol: .sqlglm
has occured during compilation

Well,

you need to be consistent!

If you have to link your Pro*C application against the 32bit libs, which obviously is the case, you also need the 32bit libs in LIBPATH when running it later.

That's to say, use -L$(ORACLE_HOME)/lib32 at the first place in the -L paths, and use /oracle/product/home0/lib32 at the first place in LIBPATH.

I fear you will have to use different LIBPATH settings for this application and for the other (vendor's) application.

To avoid those LIBPATH troubles you could try to link your Pro*C application statically against libclntsh.a (32bit).  Basically, you would have to set LDFLAGS=-static, but I really don't know if this would work.

Another possibility, of course, would be making the Pro*C app 64bit compatible.

I have to leave now, will be back tomorrow!

wmp

Note to 64 bit mode -

maybe you can try setting CFLAGS, FFLAGS, and CXXFLAGS to -q64 and/or OBJECT_MODE=64!

Hi,

I have tryied -static parameter in CXXFLAGS  
CXXFLAGS = -L${GENEVA_HOME}/dev/archive -L$(ORACLE_HOME)/rdbms/lib -L/usr/lib -L./ -L$(ORACLE_HOME)/sqlplus/lib -L$(ORACLE_HOME)/ctx/lib -L$(ORACLE_HOME)/network/lib -static -L$(ORACLE_HOME)/lib32 -lclntsh -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE

but without success.
        gcc -L/geneva_prog/DV1/dev/archive -L/oracle/product/home0/rdbms/lib -L/usr/lib -L./ -L/oracle/product/home0/sqlplus/lib -L/oracle/product/home0/ctx/lib -L/oracle/product/home0/network/lib -static -L/oracle/product/home0/lib32 -lclntsh -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE gnvprgrun.o  /geneva_prog/DV1/dev/archive/gnvlogin.a /geneva_prog/DV1/dev/archive/logs.a -o gnvprgrun
ld: 0711-317 ERROR: Undefined symbol: encrypted_pw_passlen
ld: 0711-317 ERROR: Undefined symbol: max_history_size
ld: 0711-317 ERROR: Undefined symbol: crypt_r
ld: 0711-317 ERROR: Undefined symbol: getpass_auto
ld: 0711-317 ERROR: Undefined symbol: max_pw_passlen
ld: 0711-317 ERROR: Undefined symbol: pthread_mutex_lock
ld: 0711-317 ERROR: Undefined symbol: pthread_mutex_destroy
...
any many others.

Using -q64
CC = gcc
CCFLAGS = -q64 -I$(GENEVA_HOME)/dev/include -I/usr/include -I$(ORACLE_HOME)/rdbms/demo -I$(ORACLE_HOME)/rdbms/public -I$(ORACLE_HOME)/precomp/public/ -I$(ORACLE_HOME)/network/public -g -DUSE_HEAP_STATS

CXX = gcc
CXXFLAGS = -q64 -L${GENEVA_HOME}/dev/archive -L$(ORACLE_HOME)/rdbms/lib -L/usr/lib -L./ -L$(ORACLE_HOME)/sqlplus/lib -L$(ORACLE_HOME)/ctx/lib -L$(ORACLE_HOME)/network/lib -L$(ORACLE_HOME)/lib -lclntsh -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE
following error occured:
        gcc  -q64 -L/geneva_prog/DV1/dev/archive -L/oracle/product/home0/rdbms/lib -L/usr/lib -L./ -L/oracle/product/home0/sqlplus/lib -L/oracle/product/home0/ctx/lib -L/oracle/product/home0/network/lib -L/oracle/product/home0/lib -lclntsh -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE gnvprgrun.o  /geneva_prog/DV1/dev/archive/gnvlogin.a /geneva_prog/DV1/dev/archive/logs.a -o gnvprgrun
gcc: unrecognized option '-q64'
ld: 0711-317 ERROR: Undefined symbol: .sqlcxt
ld: 0711-317 ERROR: Undefined symbol: .sqlglm
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
make: The error code from the last command is 1.

Could you give me example how to use 64bit mode for compilation?

OK, right,

it's gcc, not xlC, gcc doesn't understand "-q64". This doesn't make things easier.

In CCFLAGS, CXXFLAGS try

-maix64

I always get "type mismatch" warnings when using gcc + aix64bit. Compilation usually succeeds nonetheless.


Good luck!

wmp

Hi

it seems that -maix64 parameter in CCFLAGS, CXXFLAGS helped.
But another problem I have discovered
        gcc  -maix64 -L/geneva_prog/DV1/dev/archive -L/oracle/product/home0/rdbms/lib -L/usr/lib -L./ -L/oracle/product/home0/sqlplus/lib -L/oracle/product/home0/ctx/lib -L/oracle/product/home0/network/lib -L/oracle/product/home0/lib -lclntsh -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE gnvprgrun.o  /geneva_prog/DV1/dev/archive/gnvlogin.a /geneva_prog/DV1/dev/archive/logs.a -o gnvprgrun
ld: 0711-317 ERROR: Undefined symbol: .Log
ld: 0711-317 ERROR: Undefined symbol: .gnvConnect
ld: 0711-317 ERROR: Undefined symbol: .gnvDisconnect
ld: 0711-317 ERROR: Undefined symbol: .getConnData
ld: 0711-317 ERROR: Undefined symbol: .LogClose
ld: 0711-317 ERROR: Undefined symbol: .LogOpen
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
make: The error code from the last command is 1.


Stop.

In my opinion errors are connected with
LIB = $(GENEVA_HOME)/dev/archive/gnvlogin.a $(GENEVA_HOME)/dev/archive/logs.a

Libraries gnvlogin.a, and logs.a are compiled in 32bit mode.

I have tried to recompile them using following make file:
CXX=gcc
CXXFLAGS= -maix64 -Wall -c
LD=gcc
LDFLAGS=-D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE

ARX = logs.a
OBJ = logs.o
SRC = logs.c
HDR = logs.h

all: ${ARX}

${ARX}: ${OBJ}
      ar rvs -X64 ${ARX} ${OBJ}

${OBJ}: ${SRC} ${HDR}
      ${CXX} ${CXXFLAGS} ${SRC}

clean:
      rm -f ${OBJ} ${ARX}

release:
      cp ${HDR} ${GENEVA_HOME}/dev/include
      cp ${ARX} ${GENEVA_HOME}/dev/archive

but following error occured:
bash-3.00$ make
        gcc -maix64 -Wall -c logs.c
        ar rvs -X64 logs.a logs.o
ar: creating an archive file -X64
a - logs.a
ar: No such file or directory
ar: 0707-117 The fopen system call failed on file logs.a.
a - logs.o
ar: 0707-126 logs.o is not valid with the current object file mode.
        Use the -X option to specify the desired object mode.
make: The error code from the last command is 2.


Stop.

Could you be so kind and help me with this?

First, the sequence of the "ar" flags is wrong.

Specify

ar -X64 -rvs ${ARX} ${OBJ}

But I think this will not change much.

Msg 0707-126 clearly states that logs.o hasn't been created in 64bit mode.

Didn't the "gcc" above throw any errors?

wmp

Hi,

log.a library was successfully compiled. Great. Could you be so kind and help me with compilation
another one library, which is using Pro*C?
It's second library gnvlogin.a.

Source for compilation are two files:
gnvlogin.pc and gnvlogin.h

using following makefile:
PROC = proc
PROCFLAGS = select_error=yes ltype=none def_sqlcode=yes mode=ansi code=ansi_c parse=partial lines=no sqlcheck=semantics select_error=no userid=geneva_admin/geneva_admin code=ansi_c

CC = gcc
CCFLAGS = -maix64 -I$(GENEVA_HOME)/dev/include -I/usr/include/ -I$(ORACLE_HOME)/rdbms/demo -I$(ORACLE_HOME)/rdbms/public -I$(ORACLE_HOME)/precomp/public/ -I$(ORACLE_HOME)/network/public -g -DUSE_HEAP_STATS

ARCHIVE = ar -X64 -rvs
ARFLAGS = /usr/ccs/lib/crt0.o

LIBPCSRC = gnvlogin.pc
LIBSRC = $(LIBPCSRC:.pc=.c)
LIBOBJ = $(LIBSRC:%.c=%.o)
LIB = $(LIBOBJ:%.o=%.a)
LIBS = $(GENEVA_HOME)/dev/archive/logs.a

SRC = $(PCSRC:.pc=.c)
OBJ = $(SRC:%.c=%.o)

all: $(LIB)

clean:
      rm -f $(SRC) $(OBJ) $(EXE) $(LIBSRC) $(LIBOBJ) $(LIB)

$(LIBSRC) : $(LIBPCSRC)
      $(PROC) $(PROCFLAGS) iname=$(LIBPCSRC)

$(LIBOBJ) : $(LIBSRC)
      $(CC) $(CCFLAGS) $(LIBSRC) -c

$(LIB) : $(LIBOBJ)
      $(ARCHIVE) $(LIB) $(LIBOBJ) $(ARFLAGS)
      
I am receiving following:      
bash-3.00$ make
        proc select_error=yes ltype=none def_sqlcode=yes mode=ansi code=ansi_c parse=partial lines=no sqlcheck=semantics select_error=no userid=geneva_admin/geneva_admin code=ansi_c iname=gnvlogin.pc

Pro*C/C++: Release 9.2.0.1.0 - Production on Sun Nov 8 00:15:35 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
System default option values taken from: /oracle/product/home0/precomp/admin/pcscfg.cfg

Syntax error at line 135, column 2, file /usr/include/standards.h:
Error at line 135, column 2 in file /usr/include/standards.h
#warning  The -qdfp option is required to process DFP code in headers.
.1
PCC-S-02014, Encountered the symbol "warning" when expecting one of the followin
g:

   a numeric constant, newline, define, elif, else, endif,
   error, if, ifdef, ifndef, include, line, pragma, undef,
   an immediate preprocessor command, a C token,
The symbol "newline," was substituted for "warning" to continue.

        gcc -maix64 -I/geneva_prog/DV1/dev/include -I/usr/include/ -I/oracle/product/home0/rdbms/demo -I/oracle/product/home0/rdbms/public -I/oracle/product/home0/precomp/public/ -I/oracle/product/home0/network/public -g -DUSE_HEAP_STATS gnvlogin.c -c
gnvlogin.c: In function 'getConnData':
gnvlogin.c:196: warning: assignment makes pointer from integer without a cast
gnvlogin.c:198: warning: assignment makes pointer from integer without a cast
gnvlogin.c:200: warning: incompatible implicit declaration of built-in function 'strcpy'
gnvlogin.c:201: warning: assignment makes pointer from integer without a cast
gnvlogin.c:204: warning: assignment makes pointer from integer without a cast
        ar -X64 -rvs gnvlogin.a  gnvlogin.o  /usr/ccs/lib/crt0.o
ar: creating an archive file gnvlogin.a
a - gnvlogin.o
a - /usr/ccs/lib/crt0.o
ar: 0707-126 /usr/ccs/lib/crt0.o is not valid with the current object file mode.
        Use the -X option to specify the desired object mode.
make: The error code from the last command is 1.


Stop.

Could you help me with this?

Yes,

this is a well known problem with standards.h under AIX at a level higher than 5300-05, including AIX 6.1.

standards.h uses "#warning ..." which isn't wrong at all, but is considered an error by gcc nonetheless.

There is a workaround, but it involves modifying the header file.

Change IBM's /usr/include/standards.h

from:

#if defined(__IBM_PP_WARNING)
#warning  The -qdfp option is required to process DFP code in headers.
#else
#error  The -qdfp option is required to process DFP code in headers.
#endif

to:

#if !defined(__IBM_PP_WARNING)
#error  The -qdfp option is required to process DFP code in headers.
#endif

Either change standards.h in place or save it as a local version and put it into a "CCFLAGS -I ..." path (before /usr/include!)

wmp

Great,

there one error remains:
Pro*C/C++: Release 9.2.0.1.0 - Production on Sun Nov 8 01:35:33 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

System default option values taken from: /oracle/product/home0/precomp/admin/pcscfg.cfg

        gcc -maix64 -I/geneva_prog/DV1/dev/include -I/usr/include/ -I/oracle/product/home0/rdbms/demo -I/oracle/product/home0/rdbms/public -I/oracle/product/home0/precomp/public/ -I/oracle/product/home0/network/public -g -DUSE_HEAP_STATS gnvlogin.c -c
gnvlogin.c: In function 'getConnData':
gnvlogin.c:196: warning: assignment makes pointer from integer without a cast
gnvlogin.c:198: warning: assignment makes pointer from integer without a cast
gnvlogin.c:200: warning: incompatible implicit declaration of built-in function 'strcpy'
gnvlogin.c:201: warning: assignment makes pointer from integer without a cast
gnvlogin.c:204: warning: assignment makes pointer from integer without a cast
        ar -X64 -rvs gnvlogin.a  gnvlogin.o  /usr/ccs/lib/crt0.o
ar: creating an archive file gnvlogin.a
a - gnvlogin.o
a - /usr/ccs/lib/crt0.o
ar: 0707-126 /usr/ccs/lib/crt0.o is not valid with the current object file mode.
        Use the -X option to specify the desired object mode.
make: The error code from the last command is 1.


Stop.

Error regarding using standards.h was solved. Many thanks.
Could you please help me with error regarding use library /usr/ccs/lib/crt0.o?

Many thanks

Great,

successfully compiled program and all libraries.
Many many thanks woolmilkporc.

Regarding my communication with modus_operandi, I have requested attention on this question.
He has revised this question and inform me that he add this question to Unix Operating Systems area.

May I point next question in the future to you?

As the solution needs to be considered whole communication as final solution was reached step by step.