Small app for test .Net Core Oracle client.
Based on ericmend oracleClientCore-2.0 library (Nuget)
-
Install OCI - Client Oracle or full Oracle client.
-
(linux) Unzip the files and declare the environment variables. eg: LD_LIBRARY_PATH="/opt/oracle/instantclient"; OCI_HOME="/opt/oracle/instantclient"; OCI_LIB_DIR="/opt/oracle/instantclient"; PATH=$PATH:"/opt/oracle/instantclient"
-
(windows) Unzip the files and declare the environment variables. eg: LD_LIBRARY_PATH="C:\instantclient_12_2"; OCI_HOME="C:\instantclient_12_2"; OCI_LIB_DIR="C:\instantclient_12_2"; PATH=%PATH%;"C:\instantclient_12_2"
-
Set NLS_LANG settings, if it is not setteted correctly eg: in windows: SET NLS_LANG=SLOVAK_SLOVAKIA.EE8MSWIN1250 ( or set registry key), in Linux you can use: export NLS_LANG=SLOVAK_SLOVAKIA.UTF8 . // Slovak NLS lang settings
-
NLS_LANG= BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1 //Portugeese NLS lang settings alt 1
-
NLS_LANG= PORTUGUESE_PORTUGAL.WE8MSWIN1252 //Portugeese NLS lang settings alt 2 ...
More resources about possible values: NLS_LANG FAQ
Work has been done to work on Windows / Linux / MacOsX. Tested so far only Windows (Win10) and Linux (Ubuntu 17.10, CentOS 7).
- Download actual Oracle .Net Core library http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html
- Copy it to lib directory - sample: c:\work\oracleClientCore-Sample\lib.. and add as reference
- Configure your conn string - possible samples in code - with or withouth tnsnames.ora
- Configure NLS_LANG for language settings - see above