How to install Oracle prior using dotConnect with Visual Studio

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
maxima120
Posts: 11
Joined: Tue 15 Mar 2016 14:19

How to install Oracle prior using dotConnect with Visual Studio

Post by maxima120 » Sun 01 May 2016 21:32

I am reinstalling my dev machine. I had Oracle 11G installed (some client tools from complicated Oracle installer ages ago). The guy who knew what to install is gone now.

Are there simple instructions how to install Oracle on client machine to develop using Dotconnect for Oracle with Visual Studio and EF?

(I might need Oracle to run some PLSQL applications like PL/SQL Developer or SQL Plus tool)

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: How to install Oracle prior using dotConnect with Visual Studio

Post by Shalex » Mon 02 May 2016 11:02

Oracle 9.2.0.4 or higher is required for Entity Framework to function properly.
maxima120 wrote:Are there simple instructions how to install Oracle on client machine to develop using Dotconnect for Oracle with Visual Studio and EF?
This question exceeds the goals of our support. Please contact Oracle Support Team. In general, it is enough to launch the installation wizard and follow its steps.

maxima120
Posts: 11
Joined: Tue 15 Mar 2016 14:19

Re: How to install Oracle prior using dotConnect with Visual Studio

Post by maxima120 » Mon 02 May 2016 11:29

I followed dotConnect install and it didn't work in the end (project with EF model in it refused to open).

Devart support should state what dependencies are on the Oracle installation. This is exactly your job. You should know better than anyone how Oracle installation is complicated. There are quite a few installations exist. And each of them have dozens of options.

> Oracle 9.2.0.4 or higher is required

is not the answer. there is a hundred different things can be called Oracle.

For example I am currently looking at this:
http://www.oracle.com/technetwork/datab ... 98987.html

I understand first 2 zips are for server db install

client is for client machines.. If I run this it has a lots of components. Which one do I have to install in order to satisfy Devart product?

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: How to install Oracle prior using dotConnect with Visual Studio

Post by Shalex » Wed 04 May 2016 08:14

For the base CRUD functionality, it is enough to install Oracle Database Express Edition without Oracle Client, because dotConnect for Oracle Professional includes the Direct mode feature: https://www.devart.com/dotconnect/oracl ... tmode.html.

If you want to use an advanced functionality, you should install the corresponding Oracle edition (https://docs.oracle.com/cd/E11882_01/li ... m#DBLIC116) with the needed feature. For example:
  • Oracle Spatial (http://blog.devart.com/using-entity-fra ... rpmap.html) is supported in Oracle Database Enterprise Edition only
  • the Oracle Real Application Clusters functionality is supported in Oracle Database Standard Edition and Oracle Database Enterprise Edition. Additionally, you should install Oracle Client in this case (because the feature is not supported in the Direct mode)

maxima120
Posts: 11
Joined: Tue 15 Mar 2016 14:19

Re: How to install Oracle prior using dotConnect with Visual Studio

Post by maxima120 » Wed 04 May 2016 08:16

Thank you.

Post Reply