Re: ssdbaed.o not found in Oracle9i

From: Vance Wu <vwu_at_anacomp.com>
Date: 10 Feb 2004 12:07:38 -0800
Message-ID: <c3d4638a.0402101207.1a1365ae@posting.google.com>

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0402100614.1abe410b_at_posting.google.com>...
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076393070.707414_at_yasure>...
> > Vance Wu wrote:
> >
> > > Hi all,
> > >
> > > I'm trying to recompile an Oracle application using Oracle9i library
> > > and failed, it complains missing file ssdbaed.o.
> > >
> > > The app is compiled ok under Oracle8i 8.1.7, the object is loacated in
> > > /$ORACLE_HOME/rdbms/lib/ssdbaed.o, but it is missing in Oracle9i.
> > >
> > > Can someone tell me the replacement of ssdbaed.o in 9i or any work
> > > around?
> > >
> > >
> > > Thanks,
> > >
> > > Vance
> >
> > Is the name of the application, and its version, a secret?
> >
> > In 9.2.0.4 there is no directory named /rdbms/lib. The same is true
> > for 10g.
> >
> > My suspicion is that you should talk to the vendor.
>
> On AIX 4.3.3 Oracle version 9.2.0.4 does have a $ORACLE_HOME/rdbms/lib
> directory but no module named ssdbaed.o exists in it.
>
> Is this a pro*c or OCI application? Normally Oracle object modules
> are not referenced by name in the source code but rather are pulled in
> by the compile/link process to support the included calls and
> referenced features. Since the identified module does not exist in
> our library and we upgraded over 300 pro*c programs from 8.1.7.4 to
> 9.2.0.4 successfully it is probably not a valid module. The question
> then is why your code/compile is trying to access it. Make sure you
> are using the 9.2 version of the compile proc and that you have
> correctly set the LD_LIBRARY_PATH environment variable along with
> $ORACLE_HOME etc....
>
> HTH -- Mark D Powell --

Hi Mark,

I'm 100% sure ssdbaed.o is a valid Oracle provided object module in 8.1.7 by default when I installed Oracle8i client with Programmer option (includes precompiler..), in my 8.1.7 installation it is located in:

/opt/oracle/product/8.1.7/rdbms/lib/ssdbaed.o

I searched all my 9i directories tree, it is not there:

/opt/oracle/product/9.2.0.1/..

When I switch to 9i compilation, all my environments are set properly to 9i including LD_LIBRARY_PATH.

I also searched for Oracle website all possible 9i release 2 and 8i documentations, and found nothing explain how to use *.o files in $ORACLE_HOME/rdbms/lib/*.o.

I'm looking for examples of how to use these object modules in the compiling and linking environment, can someone points me to the right direction.

My legacy app linking example is:

	case $TCOS in
	  ax)
		if [ "$TCDBVENDOR" = "o7" ]
		then
			# oracle 7.3
			export ORACLELINK=' -lgeneric -lcommon -lnlsrtl3 -lcore3 -lclient
-lepc -lncr -lsqlnet -lcv6 '
		else
			# oracle 8.1.7 - static
			export ORACLELINK='$(ORACLE_HOME)/rdbms/lib/ssdbaed.o
$(ORACLE_HOME)/rdbms/lib/kpudfo.o $(ORACLE_HOME)/lib/nautab.o

$(ORACLE_HOME)/lib/naeet.o $(ORACLE_HOME)/lib/naect.o $(ORACLE_HOME)/lib/naedhs.o -lnbeq8 -lnhost8 -lnus8 -lnldap8

-lldapclnt8 -lnsslb8 -lclntsh -lnoname8 -lntcp8 -lntcps8 -lnsslb8
-lntcp8 -lntns8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8
-lldapclnt8 -lnsslb8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8
-lntns8 -ln8 -lnl8 -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm
-lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lnldap8
-lldapclnt8 -lnsslb8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8
-lntns8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8
-lnsslb8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8
-lnl8 -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -ltrace8 -lnls8
-lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lcommon8 -lskgxp8
-lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lld -lm /lib/crt0_r.o
-lc_r -lpthreads -lodm -lm -lsvld -lbsd_r -lld -lm
-bI:$(ORACLE_HOME)/lib/pw-syscall.exp -bI:$(ORACLE_HOME)/lib/ksms.imp
-lpthreads '
		fi

Thanks. Received on Tue Feb 10 2004 - 14:07:38 CST