How to use Entity Framework with an Oracle database

Question

I'm a starter in Oracle, I want to use Entity Framework to connect to my Oracle database.

I first installed Oracle 11g R2 and get this and then I install NetManager and create new Service Name

enter image description here

Then, I go to Visual Studio and create a new model but wWhen I want to create a connection it gives me an error message.

enter image description here

Please help me. thanks all

marc_s · Accepted Answer · 2012-04-10 12:06:27Z

1

It had happened me once. In your Oracle home directory there must be two folder in directory C or D:\app\user\product\11.2.0:

Names of folder must be smth like that:

client_1   and    dbhome_1

There must be tnsnames.ora in \client_1\Network\Admin\Sample. If not, create one. Then first of all delete all texts in this file and copy this to that file:

orcl=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.77.31)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))

Instead orcl you will write your data Source. Also for host and port number. And Service name.

It must work. If not copy tnsnames.ora and listener.ora to \client_1\Network\Admin.

And test it again.

edited Apr 10, 2012 at 12:06

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 10, 2012 at 10:32

Ezio Auditore da Firenze

1,22614 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Pouya Over a year ago

@ FerhadJabiyev: in Sample folder have two files , sqlnet.ora and tnsnames.ora,Then I can put into one file? thanks

Ezio Auditore da Firenze Over a year ago

tnsnames.ora file and You must copy Listener.ora file from dbhome_1\Network\Admin\Sample to client_1\Network\Admin\Sample

Pouya Over a year ago

# tnsnames.ora Network Configuration File: J:\app\MOHSEN\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. CMMorcl=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.135.23)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))

Ezio Auditore da Firenze Over a year ago

@mohsen everything seems ok here. Have you copied Listener.ora from dbhome_1\Network\Admin\Sample to client_1\Network\Admin\Sample?

Ezio Auditore da Firenze Over a year ago

@mohsen ok. And have you copied all files from client_1\Network\Admin\Sample to client_1\Network\Admin?

|

Collectives™ on Stack Overflow

How to use Entity Framework with an Oracle database

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related