Oracle- PL/SQL DEV的远程配置
2024-08-27 04:42:41
首先装好Oracle企业版或者客户端精简版。之后要修改你的的tnsnames.ora文件,来增加数据库。
我的ORACLE实例是ORACLE1,放在D:\oracle\ 目录下。我的IP地址是 192.168.1.102
修改如下:
添加:
DEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORACLE1)
)
)
这样就把一个远程的数据库添加到本机的客户端中了。然后打开PL/SQL DEV 软件。在工具->首选项中修改:
Oracle主目录名:D:\oracle\
OCI库:D:\oracle\ora92\bin\oci.dll
这样设置之后,就可以通过PL/SQL DEV来访问远程的Oracle数据库了。
附上最原始的tnsnames.ora文件
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. ORACLE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VKP1W8IQZW4QTSX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oracle1)
)
) INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VKP1W8IQZW4QTSX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
最新文章
- jquery禁用文本框
- AutoCompleteTextView自动补全文本框
- html中表格table的内容居中显示
- Codeforces Round #372 (Div. 2) C
- [转载].Net中如何操作IIS(源代码)
- Apache虚拟主机(vhost)配置教程
- 3 weekend110的shuffle机制 + mr程序的组件全貌
- django的model对象转化成dict
- imagick-3.1.0RC2 安装错误
- Hbase单机安装部署
- WHY数学表达式的3D可视化
- Jenkins构建触发器
- 【Golang 接口自动化03】 解析接口返回XML
- Zabbix监控PostgreSQL
- multi thread for Java
- 【架构】SpringCloud 注册中心、负载均衡、熔断器、调用监控、API网关示例
- Jquery编历数组
- php中文正则匹配
- boost noncopyable类
- Entity Framework 6.0 Tutorials(9):Stored Procedure Mapping