[Mono-list] Problems with System.Data.OracleClient

[Alois Bělaška]

Oetjen, Michael wrote:
> Hello,
> please could you tell me how System.Data.OracleClient works on Linux 
> Here my environment : 
> 
> OS : SuSE 9.0 with Mono 1.04 and Oracle Client 9.2.0.1 
> 
> For testing I used the testprogram down on /www.go-mono.com/oracle.html 
> with modification for connecting my oracle database 
> Compilation was succesfull 
> 
> When I run -mono test.exe- I' ve got this message 
> 
> Unhandled Exception: System.DllNotFoundException: oci 
> in <0x00053> (wrapper managed-to-native) OciNativeCalls:OCIEnvCreate
> (intptr&,System.Data.OracleClient.Oci.OciEnvironmentMode,intptr,intptr,i
> ntptr,intptr,int,intptr)
> in <0x00020> System.Data.OracleClient.Oci.OciCalls:OCIEnvCreate
> (intptr&,System.Data.OracleClient.Oci.OciEnvironmentMode,intptr,intptr,i
> ntptr,intptr,int,intptr)
> in <0x0005d> System.Data.OracleClient.Oci.OciEnvironmentHandle:.ctor
> (System.Data.OracleClient.Oci.OciEnvironmentMode) 
> in <0x0003c> System.Data.OracleClient.Oci.OciGlue:CreateConnection
> (System.Data.OracleClient.OracleConnectionInfo) 
> in <0x0002b> System.Data.OracleClient.OracleConnection:Open () 
> in <0x0004f> (wrapper remoting-invoke-with-check)
> System.Data.OracleClient.OracleConnection:Open () 
> in <0x0006a> Test:Main (string[]) 
> 
> Then I tried it with 
> 
> OS : SuSE 9.1 with Mono 1.04 and Oracle Client from Version 10g 
> 
> ... same problems will appear :-( 
> 
> 
> what's wrong ? ... does a file like oci.dll on linux exist ? 
> please help me 
> 
> best regards 
> Mike 
> 

Hi,
	problem is your program cannot find oracle libraries, so you need to 
set up ORACLE environment to run your program correctly.

Example:

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0.1.0
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_OWNER=oracle
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/opt/oracle/product/9.2.0.1.0/lib
export 
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Lojza