-
配置ORACLE_HOME环境变量
ORACLE_HOME= E:\oracle12C\sawluoracle\product\12.2.0\dbhome_1
-
下载Oracle Client Package(instantclient-basic-nt-11.2.0.3.0.zip)解压到oracle安装目录product下
-
拷贝tnsnames.ora到instantclient_11_2路径下
tnsnames.ora路径:E:\oracle12C\sawluoracle\product\12.2.0\dbhome_1\network\admin
instantclient_11_2路径:E:\oracle12C\sawluoracle\product\instantclient_11_2 -
PLSQL中配置Oacle Home和OCI library
路径:tools-preferences
Oacle Home路径:E:\oracle12C\sawluoracle\product\instantclient_11_2
OCI library路径:E:\oracle12C\sawluoracle\product\instantclient_11_2\oci.dll
配置好后点击apply 确定
5. 使用普通用户登录验证