Thanks for the help!

Here is a new problem I hope someone can help!

---
mail_Listserv>make listserv
        if [ `uname` = 'SunOS' -a  `uname -r | awk '{ if(\$1<5) printf("0"); else printf("1") }'` = 1  ]; then  make lsv_prog UNAME=Solaris;  else  make lsv_prog UNAME=`uname`;  fi
        if [ "-q arch=ppc /home/OraHome1/rdbms/lib/genoci.o" = ")" ]; then  /home/OraHome1/bin/oraxlc -o lsv lsv.o;  else  /home/OraHome1/bin/oraxlc -O -o lsv lsv.o -q arch=ppc /home/OraHome1/rdbms/lib/genoci.o;  fi
ld: 0711-224 WARNING: Duplicate symbol: .main
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
ld: 0711-317 ERROR: Undefined symbol: .OCIInitialize
ld: 0711-317 ERROR: Undefined symbol: .OCIEnvInit
ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
ld: 0711-317 ERROR: Undefined symbol: .__main
make: 1254-004 The error code from the last command is 8

-----Original Message-----
From: Damon Green [mailto:[log in to unmask]]
Sent: Thursday, September 21, 2000 4:51 PM
To: [log in to unmask]
Subject: Re: DBMS


You need to set the listserv user profile to include :

. /usr/local/bin/profile.oracle
PATH=$PATH:/usr/ccs/bin:/usr/ucb/
export PATH
LD_LIBRARY_PATH=/export/home/oracle/app/oracle/product/8.0.4/lib
export LD_LIBRARY_PATH


The critical section from my makefile looks like the following, I initially
used every library going, then whittled it down to the minimum, took me a
while to figure out the LD_LIB thing....

Damon.


LSVAMIN_TYPE=flags
#
#WHOAMI=whoami
WHOAMI=/usr/ucb/whoami          # Uncomment for Solaris
###########################################################################
# End of user customization area. Do not edit the remainder of            #
# this file.                                                              #
###########################################################################
# -- Directories used by LISTSERV.
LSVDIRS=$(LSVROOT) $(LSVROOT)/home $(LSVROOT)/tmp
#
SHELL=/bin/sh
#
WHICH=$(NAME)$(name)
#
#CFLAGS_Solaris=-lsocket -lnsl
#CFLAGS_Solaris=-lsocket -lnsl -lclntsh -lgen -ldl -lcommon -lcore4 -lnlsrtl
3 -L /oracle8/app/oracle/product/8.0.4/lib
CFLAGS_Solaris=-lsocket -lnsl -lclntsh -lgen -ldl -lcommon

CFLAGS_INTERACTIVE=-linet -lcposix
CFLAGS_OSF1=-taso -lots
CFLAGS_AIX=
CFLAGS_SunOS=
CFLAGS_SCO_SV=-lsocket
#
IS_SOLARIS=`uname` = 'SunOS' -a \
        `uname -r | awk '{ if(\$$1<5) printf("0"); else printf("1") }'` = 1




-----Original Message-----
From: LISTSERV give-and-take forum
[mailto:[log in to unmask]]On Behalf Of Anthony Del Rosso
Sent: Thursday, September 21, 2000 9:43 PM
To: [log in to unmask]
Subject: Re: DBMS


Would you have your old makefile? it would be a big help!

Thanks

Anthony

-----Original Message-----
From: Damon Green [mailto:[log in to unmask]]
Sent: Thursday, September 21, 2000 3:29 PM
To: [log in to unmask]
Subject: Re: DBMS


You're in for some fun...

Search the archives of this list for my experiences.
Should help, I got it working in the end.

Damon.

-----Original Message-----
From: LISTSERV give-and-take forum
[mailto:[log in to unmask]]On Behalf Of Anthony Del Rosso
Sent: Thursday, September 21, 2000 8:01 PM
To: [log in to unmask]
Subject: DBMS


I'm trying to implement Listserv's DBMS on an RS/6000 AIX 4.3.2 box running
Listserv 1.8d. and Oracle 8.1.5
I installed the Oracle Client only on this machine. The Oracle home is
/home/OraHome1

Can anyone help with the Listserv Makefile in particular the CFLAGS= ? and
the Oracle Connection Libraries?

Any help would be greatly appreciated.

Thanks in advanced!

Anthony Del Rosso