- oracle官网提供了instantclient,下载instantclient-basic包,将包解压存放到本地,下载地址:https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html,下图所示:
- 在instantclient_19_3目录下新建 sqlnet.ora文件 和 \NETWORK\ADMIN\tnsnames.ora两个文件
-
sqlnet.ora文件内容 --------------------------------------------------------- SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora文件内容 ---------------------------------------------------------------------------------- orcl245 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.21.245 )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl ) ) )
- 配置环境变量
变量名 变量值 TNS_ADMIN D:\oracle\instantclient_19_3 NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK //用于中文乱码
-
安装PL/SQL Developer,并配置oracle的连接参数:
打开PL/SQL,Tools-->Preferences,配置Connection的Oracle Home和OCI library,如下图所示:
-
重新启动PL/SQL,OK!
使用PL/SQL连接oracle(不安装oracle客户端 )
最新推荐文章于 2022-06-22 08:30:56 发布