- 将instantclient.rar解压到指定目录,如:C:\instantclient
在根目录下新建NETWORK \ ADMIN目录 - 设置环境变量
TNS_ADMIN=C:\instantclient\NETWORK\ADMIN
Path=C:\instantclient - 在NETWORK\ADMIN目录里新建tnsnames.ora文件,用记事本打开并编辑
SOCIETY-163 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.163)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SOCIETY) ) )
SOCIETY-163为自定义的网络服务名 - 打开PL SQL>Tools>Preferences>Connection
在Oracle Home填C:\instantclient
OCI Library填C:\instantclient\oci.dll - 当客户端与服务器的NLS_LANG设置不一致,中文会显示乱码,在环境变量里添加如下项即可
NLS_LANG= SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Oracle instantclient 连接数据库服务器
最新推荐文章于 2021-04-07 03:18:34 发布