[Mono-dev] Oracle + clntsh

[Arnhoffer Károly]

Hi,

I try to run the first example at http://www.mono-project.com/Oracle and I get the following error:

Unhandled Exception: System.DllNotFoundException: clntsh
in (wrapper managed-to-native) OciNativeCalls:OCIEnvCreate (intptr&, System.Data.OracleClient.Oci.OciEnvironmentMode,intptr,intptr,intptr,
intptr,int,intptr)
in <0x0001f> System.Data.OracleClient.Oci.OciCalls:OCIEnvCreate 
(System.IntPtr envhpp, OciEnvironmentMode mode, IntPtr ctxp, IntPtr 
malocfp, IntPtr ralocfp, IntPtr mfreep, Int32 xtramem_sz, IntPtr 
usrmempp)
in <0x0003c> System.Data.OracleClient.Oci.OciEnvironmentHandle:.ctor 
(OciEnvironmentMode mode)
in <0x0006b> System.Data.OracleClient.Oci.OciGlue:CreateConnection 
(OracleConnectionInfo conInfo)
in <0x00042> System.Data.OracleClient.OracleConnectionPoolManager:
CreateConnection (OracleConnectionInfo info)
in <0x00038> System.Data.OracleClient.OracleConnectionPool:
CreateConnection ()
in <0x0010a> System.Data.OracleClient.OracleConnectionPool:
GetConnection ()
in <0x000ce> System.Data.OracleClient.OracleConnection:Open () in (wrapper remoting-invoke-with-check) System.Data.OracleClient. OracleConnection:Open () in <0x00061> Test:Main (System.String[] args)

I have examinded my linux (SuSE 9.2 with Oracle 9i, Mono 1.1.10) and found that there is a line in /etc/mono/config saying:
<dllmap dll="oci" target="clntsh" />.
What should this be? I tried /opt/oracle/920/lib/libclntsh.so.9.0 instead of clntsh here but I got errors again:

Unhandled Exception: System.Data.OracleClient.OracleException: Could 
not allocate the Oracle environment.
in <0x00291> System.Data.OracleClient.Oci.OciGlue:CreateConnection 
(OracleConnectionInfo conInfo)
in <0x00042> System.Data.OracleClient.OracleConnectionPoolManager:
CreateConnection (OracleConnectionInfo info)
in <0x00038> System.Data.OracleClient.OracleConnectionPool:
CreateConnection ()
in <0x0010a> System.Data.OracleClient.OracleConnectionPool:
GetConnection ()
in <0x000ce> System.Data.OracleClient.OracleConnection:Open () in (wrapper remoting-invoke-with-check) System.Data.OracleClient. OracleConnection:Open () in <0x00061> Test:Main (System.String[] args)


Thanks:

Károly