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