Oracle客户端连接数据库配置
2023-09-11 14:17:16 时间
配置文件和路径
- 配置文件:
tnsnames.ora
- 默认路径:
%ORACLE_HOME%\network\admin\tnsnames.ora
,%ORACLE_HOME%
通常在环境变量中使用。 - 我的路径为:C:\Program Files (x86)\Oracle\Instant Client\network\admin\tnsnames.or
配置文件如下:
# tnsnames.ora Network Configuration File. # Generated by Oracle configuration tools. # Sample: #DatabaseName = # (DESCRIPTION = # (ADDRESS_LIST = # (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) # ) # (CONNECT_DATA = # (SERVER = DEDICATED) # (SERVICE_NAME = ServiceName) # (INSTANCE_NAME = InstanceName) # ) # ) # Modify the following content to fit your own needs. DummyDatabase = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DummyService) ) ) pcidata_hce = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devorcl) ) ) FM_DEV= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.223)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testorcl) ) ) hceorcl = //数据库名称自定义文中唯一值 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.123)(PORT = 1521)) //数据库IP及端口号 (CONNECT_DATA = (SID =orcl) //实例名 ) ) pdatatest = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.182)(PORT = 1521)) (CONNECT_DATA = (SID =pdatatest) ) ) 162ora = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.162)(PORT = 1521)) (CONNECT_DATA = (SID =pdjgorcl) ) )
这样就可以通过pl/sql developer连接了。
相关文章
- SQL数据库转换为ORACLE后的isNull 处理
- Oracle数据库:oracle外连接left/right/full outer join on,oracle扩展的左右外连接展示符号(+)
- Oracle数据库:oracle函数,单行函数,多行函数,upper,lower,initcap,字符串函数
- Oracle数据库:oracle字符类型、数字类型、创建表表名的命名规则
- Oracle数据库:oracle启动,oracle客户端工具plsql安装教程和使用方法
- Oracle数据库:啥是oracle数据库?你为啥要学oracle?
- 科技云报道:分布式数据库一定会替代Oracle吗?
- Oracle 12C优化器的巨大变化,上生产必读(下)
- 细说Oracle数据库与操作系统存储管理二三事
- [转]Oracle 行转列 动态出转换的列
- Oracle-未能加载文件或程序集“oracle.dataaccess”或它的某一个依赖项。试图加载格式不正确的程序。
- 《Oracle数据库管理与维护实战》——2.1 Oracle总体结构
- oracle查看表是否被锁
- oracle的隐式游标
- Oracle 数据库之最:你见过最高的 SQL Version 是多少?
- 使用OCCI连接Linux下Oracle数据库
- Oracle数据库迁移之物理迁移
- 数据库--oracle安装配置(本地安装的步骤及各种问题解决方案)
- Oracle 10g RAC TAF
- [Oracle]如何获得出现故障时,客户端的详细连接信息
- Oracle数据库学习笔记
- 各种数据库(oracle、mysql、sqlserver等)在Spring中数据源的配置和JDBC驱动包
- 测试oracle数据库的脱机备份和恢复
- 在shell终端操作oracle数据库的常用命令
- Oracle:ORA-01219 数据库或可插入数据库未打开 仅允许在固定表或视图中查询