[Mono-list] Oracle Connection

[Amc Gmail]

sorry, i forgot small things. most likely your $ORACLE_HOME/lib has
libclntsh.so.10.1 but mono looking for libclntsh.so and cann't handle
version number.
so, in my case i simply using ln -s like this:

ln -s /home/my_home/oracle_client/libclntsh.so
/home/my_home/oracle_client/libclntsh.so.10.1

or you can use mono dll.config files, which also works for me, but
little bit more tricky.
regards,
--amc


On 7/6/07, Gustavo Ribeiro De Bonis <gustabass at gmail.com> wrote:
> Hi Amc,
>
> thks for helping me, but it didnt work.
>
> My oracle client path:
> $ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/
>
> /server/bin/oracle_env.sh:
>
>     ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
>     export ORACLE_HOME
>     ORACLE_SID=XE
>     export ORACLE_SID
>     NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
>     export NLS_LANG
>     PATH=$ORACLE_HOME/bin:$PATH
>     export PATH
>     if [ $?LD_LIBRARY_PATH ]
>     then
>         LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
>     else
>         LD_LIBRARY_PATH=$ORACLE_HOME/lib
>     fi
>     export LD_LIBRARY_PATH
>
> /client/bin/oracle_env.sh:
>
>     ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
>     export ORACLE_HOME
>     NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
>     export NLS_LANG
>     SQLPATH=$ORACLE_HOME/sqlplus
>     export SQLPATH
>     PATH=$ORACLE_HOME/bin:$PATH
>     export PATH
>     if [ $?LD_LIBRARY_PATH ]
>     then
>         LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
>     else
>         LD_LIBRARY_PATH=$ORACLE_HOME/lib
>     fi
>     export LD_LIBRARY_PATH
>
> I do not know what to do, i checked the libs, but they are all right in
> the right place.
>
> I can't find why my mono-data-oracle doesnt find the dll
>
> My installation is default.
>
> I copied the contents of your script but it didn't work out.
>
> sqlplus works fine, but mono doesnt.
>
> Sorry by bother you, and thanks anyway.
>
> Ribeiro Gustavo.
>
> Amc Gmail escreveu:
> > It seems to be
> >    export LD_LIBRARY_PATH=$ORACLE_HOME PATH:$LD_LIBRARY_PATH
> > can help.
> >
> > in my case i just download instant client from Oracle site, unpack it
> > into /home/my_home/oracle_instant_client/, create tnsnames.ora and to
> > setup environment doing:
> >    source set_my_oracle.sh
> > where set_my_oracle.sh contains:
> >
> > #!/bin/sh
> > ORACLE_CLIENT_HOME=/home/my_home/oracle_instant_client
> > export LD_LIBRARY_PATH=$ORACLE_CLIENT_HOME:$LD_LIBRARY_PATH
> > export PATH=$ORACLE_CLIENT_HOME:$PATH
> > export TNS_ADMIN=$ORACLE_CLIENT_HOME
> >
> > after that sqlplus and mono xsp works fine.
> > good luck,
> > --amc
> >
> > On 7/6/07, Gustavo Ribeiro De Bonis <ribeirogustavoti at gmail.com> wrote:
> >> Hi, i'm new to linux and mono,  i'm trying to do my home work on linux
> >> and mono.
> >>
> >> I need to develop a simple software that just connects to a database
> >> made in oracle (10g), but it can't connects to oracle server (running on
> >> local machine), and everytime i receive this error:
> >>
> >> Unhandled Exception: System.DllNotFoundException: libclntsh.so
> >> ...
> >> .
> >> .
> >> .
> >>
> >> Can somebody help me?
> >>
> >> i need to do this because i'm learning this stuff in my college and i
> >> don't want to move to Microsoft plataform and work with Visual Studio.
> >>
> >> i've already runed the oracle_env script and set my variables up.
> >>
> >> Oracle Client is instaled, the server is running too. I can connect with
> >> the Application Express (my browser) and with sqlplus* but not with
> >> Mono.
> >>
> >> Distro: Fedora 7
> >> My Kernel is 2.6.21
> >> Mono version: 1.2.4
> >> Mono Data Oracle:  1.2.4.novell
> >> Oracle: 10g (10)
> >> $ORACLE_HOME PATH = /usr/lib/oracle/xe/app/oracle/product/10.2.0/client
> >> $LD_LIBRARY_PATH = ...
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Mono-list maillist  -  Mono-list at lists.ximian.com
> >> http://lists.ximian.com/mailman/listinfo/mono-list
> >>
> >
>
>
>