[Mono-dev] my web page cann't access oracle.

[Daniel Morgan]

What is the shared library name for OCI on your system?

It would something like libclntsh.so

Oracle 10g may have something like libclntsh.so.10.0 or something.

If you do have something like libclntsh.so.10.0, you can modify target
in the dllmap of the etc/mono/config file.

        <dllmap dll="oci" target="libclntsh.so.10.0" />

Or you could create a symbolic link to the file libclntsh.so.10.0 as
libclntsh.so

zhulijun wrote:

>My env, /home/oracle/.bash_profile and  /usr/local/etc/mono/config as follows:
>my oracle was installed under /home/oracle/OraHome_1
>i had add user apache into group root, oinstall, dba and apache
>but I still got the same error information
>
>
>
>[root at zlj apache2]# env
>SSH_AGENT_PID=3924
>HOSTNAME=zlj.zlj.com
>DESKTOP_STARTUP_ID=
>SHELL=/bin/bash
>TERM=xterm
>HISTSIZE=1000
>GTK_RC_FILES=/etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
>WINDOWID=54534970
>USER=root
>LD_LIBRARY_PATH=:/home/oracle/OraHome_1/lib:/usr/lib:/usr/local/lib
>LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0 1:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31: *.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:* .bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3 5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
>ORACLE_SID=sv66
>GNOME_KEYRING_SOCKET=/tmp/keyring-ay9NIf/socket
>SSH_AUTH_SOCK=/tmp/ssh-ffciqc3923/agent.3923
>KDEDIR=/usr
>SESSION_MANAGER=local/zlj.zlj.com:/tmp/.ICE-unix/3892
>MAIL=/var/spool/mail/root
>DESKTOP_SESSION=default
>PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/ bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/home/oracle/OraHome_1/bin:/root/bin:/home /oracle/OraHome_1/lib
>INPUTRC=/etc/inputrc
>PWD=/usr/local/apache2
>XMODIFIERS=@im=htt
>LANG=zh_CN.UTF-8
>GDMSESSION=default
>SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
>HOME=/root
>SHLVL=2
>GNOME_DESKTOP_SESSION_ID=Default
>LOGNAME=root
>DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-vVgsRMwUwG
>PKG_CONFIG_PATH=/usr/local/lib/pkgconfig
>LESSOPEN=|/usr/bin/lesspipe.sh %s
>DISPLAY=:0.0
>ORACLE_HOME=/home/oracle/OraHome_1
>GTK_IM_MODULE=iiim
>G_BROKEN_FILENAMES=1
>COLORTERM=gnome-terminal
>XAUTHORITY=/root/.Xauthority
>_=/bin/env
>OLDPWD=/usr/local/apache2/htdocs
>
>
>
>[root at zlj apache2]# cat /home/oracle/.bash_profile
># .bash_profile
>
># Get the aliases and functions
>if [ -f ~/.bashrc ]; then
>        . ~/.bashrc
>fi
>
># User specific environment and startup programs
>
>PATH=$PATH:$HOME/bin
>#export ORACLE_BASE=/opt/ora10/product
>export ORACLE_HOME=/home/oracle/OraHome_1/
>export ORACLE_SID=sv66
>export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
>export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
>export NLS_LANG="Simplified Chinese_china".ZHS16GBK
>#export NLS_LANG=Japanese_Japan.JA16EUC
>#export NLS_LANG=Japanese_Japan.UTF-8
>
>
>
>export PATH
>unset USERNAME
>
>
>
>[root at zlj apache2]# cat /usr/local/etc/mono/config
><configuration>
>        <dllmap dll="cygwin1.dll" target="libc.so.6" />
>        <dllmap dll="libc" target="libc.so.6" />
>        <dllmap dll="intl" target="libc.so.6" />
>        <dllmap dll="libxslt.dll" target="libxslt.so" />
>        <dllmap dll="libmySQL.dll" target="libmysqlclient.so" />
>        <dllmap dll="odbc32.dll" target="libodbc.so" />
>        <dllmap dll="oci" target="clntsh" />
>        <dllmap dll="db2cli" target="libdb2_36.so"/>
>        <dllmap dll="msvcrt" target="libc.so.6"/>
>        <dllmap dll="MonoPosixHelper" target="libMonoPosixHelper.so"/>
>        <dllmap dll="sqlite" target="libsqlite.so.0"/>
>        <dllmap dll="sqlite3" target="libsqlite3.so.0"/>
>        <dllmap dll="libX11" target="libX11.so.6"/>
>        <dllmap dll="libcairo-2.dll" target="libcairo.so.2"/>
></configuration>
>
>
>
>
>
>
>
>==========================
>263µç×ÓÓʼþ£­ÐÅÀµÓÊ×Ôרҵ
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Mono-devel-list mailing list
>Mono-devel-list at lists.ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-devel-list
>  
>