首先介绍下环境
服务器上安装好64位Oracle 12c最新版本;
客户端安装64为Oracle Client 12c;(安装路径C:\app)
客户机下载解压Oracle intantclient_11_2(安装路径C:\app\aa\product\instantclient_11_2,这个随意)
客户机安装PL/SQL Developer 11
1.下载64位Oracle Client 12c安装。
在\instantclient_11_2目录下,建两个文件夹\network\admin,建tnsnames.ora文件。
内容如:
<span style="font-size: 18px;">#TEST前面不能有空格,否则报错连不上。</span>
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
TEST3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
3.下载PL/SQL Developer 11版安装http://files.allroundautomations.com/plsqldev1104.exe
注册码:
Product Code:4t46t6vydkvsxekkvf3fjnpzy5wbuhphqz
serial Number:601769
password:xs374ca
4.在PL/SQL Developer选项中设置
Oracle Home=C:\app\aa\product\instantclient_11_2\
OCI library=C:\app\aa\product\instantclient_11_2\oci.dll
*5.环境变量path= C:\app\aa\product\12.1.0\client_1\BIN;保持默认不改。(搜出来一大堆要设环境变量,没用。)