First, the question
here is the first description of my environment: win8.1 (64bit) +oracle11g (64bit) +pl/sql (32bit).
The situation is: NET Manager is configured properly, the test is successful, but there is no databse option when you connect with PL/SQL
I went online Baidu for a long time, finally found the answer.
Ii. Solutions
PL/SQL developer using Instantclient to connect to the Oracle version:
? 1. Download the 32-bit Oracle instantclient and expand to a directory such as C:\instantclient-basic-nt-11.2.0.2.0;:/http www.oracle.com/technetwork/topics/winsoft-085727.html
2. Copy the Tnsnames.ora of the system to the directory;
? 3. set up the Oracle_home and OCI Library in Plsql Developer:
Tools? Preferences? Oracle? Connection:
oracle_home:c:\instantclient-basic-nt-11.2.0.2.0
OCI Library:c:\instantclient-basic-nt-11.2.0.2.0\oci.dll
4. under the Plsql Developer directory, create a new bat file, replace its shortcut, and start the Plsql Developer:
@echo off
Set path=c:\instantclient-basic-nt-11.2.0.2.0
Set oracle_home=c:\instantclient-basic-nt-11.2.0.2.0
Set tns_admin=c:\instantclient-basic-nt-11.2.0.2.0
set Nls_lang=american_america. ZHS16GBK
Start Plsqldev.exe
Turn: PL/SQL in win8.1 System connection oracle11g no database processing method