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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 - [email protected] > >> http://lists.ximian.com/mailman/listinfo/mono-list > >> > > > > > _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
