Click here to Skip to main content
13,593,025 members
Click here to Skip to main content
Add your own
alternative version


10 bookmarked
Posted 8 Aug 2012
Licenced CPOL

Setting-up Oracle Database for .NET development

, 8 Aug 2012
Rate this:
Please Sign up or sign in to vote.
How to set-up an Oracle database for .NET development.


I recently had to set-up a new development environment for a .NET application consuming an Oracle Database and found out that it wasn’t that easy, so I thought I’d share how I did it.


This is just a tip, I used it on my dev machine and it worked, I did not test this any further and there’s absolutely no warranty, express or implied. If anything should happen, I’m just saying I told you and I cannot be held responsible.


I downloaded and installed a free Oracle Database Express Edition.

The 11g Release 2 is available here: Yet, in this case I had to install a 10g in 32-bit which can’t be found on OTN anymore…..except on a Japanese OTN page?!!

If you need the Oracle Database 10g Express Edition (x86) as I did here’s the link:

Installing the Server

Nothing special here: install OracleXE.exe, keep everything by default:

  • installation directory: C:\oraclexe
  • default port: 1521
  • configure the SYS or SYSTEM account

Once installed, an administration web page should start. Check that everything runs fine, if so, you’re done, now let’s prepare it for the .NET world!

Installing OCI and ODP.NET

Oracle Call Interface (OCI) is the basic and compulsory method to access Oracle using a client. On top of OCI, we’ll need the Oracle Data Access Components (ODAC). Both OCI and ODAC are a set of dlls and that are shipped as a ZIP, available on Oracle’s web site (
In my case I specifically needed the, in your case just be careful to use an ODAC version matching your Oracle Database version and bitness.
Then here’s how I configured my environment:

  • I created a “C:\oracle” just like OracleXE did,
  • I extracted the content of my archive in this directory,
  • I removed the path “C:\oraclexe\app\oracle\product\10.2.0\server\bin” from myPATH environment variable…
  • …and added the “C:\oracle\instantclient_11_1” in the PATH so my OCI dlls are used,
  • I copied the Oracle.DataAccess.dll that is in “C:\oracle\odp.net20\\bin\2.x\”in “C:\oracle\instantclient_11_1”,
  • I removed all Oracle.DataAccess.dll from the GAC so I’ll be sure my .NET apps we’ll always use the Oracle.DataAccess.dll they reference,
  • I copied the OraOps11w.dll contained in the “C:\oracle\bin” in“C:\oracle\instantclient_11_1”

Installing SQL Developer

  • Download SQL Developer from OTN:
  • Extract and place the sqldeveloper directory in “C:\oracle
  • Launch SQL Developer, and it should run nice and easy

Point of interest

It is even easier with CodeFluent Entities.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Member 8770718
United States United States
No Biography provided

You may also be interested in...


Comments and Discussions

QuestionRegarding NetConfigurationAssistant Pin
yashvi_rsy15-May-13 17:19
memberyashvi_rsy15-May-13 17:19 
GeneralMy vote of 5 Pin
Christian Amado8-Aug-12 3:35
memberChristian Amado8-Aug-12 3:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web04-2016 | 2.8.180618.1 | Last Updated 8 Aug 2012
Article Copyright 2012 by Member 8770718
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid