After Oracle 10g has 11g odac installed, the PL/SQL connection prompt TNS: the specified connection identifier cannot be resolved

I have just joined a new project recently. The requirements have been completed and will enter the detailed design stage. The project framework should use a multi-project system framework that is being developed by other project teams and use this main framework to develop modules of our own system. I have learned about the composition of this framework over the past few days, mainly uses the WCF Service, entityframework 4.1 Framework, and ext. NET component development, by the way, I learned EF knowledge.

I installed Visual Studio 2010 and Oracle 10g server on my machine. When learning EF, I found that adding ADO. the Oracle Database driver is missing when the net object data model is used. If the relevant information is poor, the odac driver is to be installed. Therefore, the Oracle 11g odac driver is installed.

After the installation is complete, use PL/SQL to log on to the original database and the system prompts "TNS: Unable to parse the specified connection identifier" error.

Found the relevant information:

First:

Add this line to the header of the D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ listener. ora file.

Direct_handoff_ttc_listener = off

Run the following command to restart the listener:

-------------------------------------------------------------------

LSNRCTL stop
LSNRCTL start

Second:

Open PL/SQL in tool -- preference -- connection, right window

In the Oracle Home Directory Name, select the server version installation path: oradb10g_home1

Click OK to close the PL/SQL window. Then, the database with the original configuration is successfully logged in.

However, Oracle connection driver still does not appear in EF implementation. It is unclear why, and we will solve it later.

 

Let's write it here today. It's time to take a rest over the weekend!

If you have encountered any of the above unsolved problems and want to support them, thank you very much ~~~