PLSQL 配置连接ORACLE数据库
2023-09-11 14:16:57 时间
http://blog.csdn.net/leather0906/article/details/6456095
PLSQL配置登录用户信息
http://www.2cto.com/database/201208/151708.html
配置环境变量 TNS_ADMIN D:\OracleClient
在改目录下配置链接文件 TNSNAMES.ORA
# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.117)(PORT = 1521)) EASYCONC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.117)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = easyconc) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ZHIYUANZHE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 211.137.44.38)(PORT = 1523)) ) (CONNECT_DATA = (SERVICE_NAME = ZHIYUANZHE) ) ) ShenHe=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.24)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) hptax = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 136.16.38.120)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = syzs) ) ) VSTAR = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 136.20.16.62)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VSTAR) ) )
解决乱码问题:配置环境变量 NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK
相关文章
- Oracle数据库:oracle嵌套分组函数(聚合函数),组函数的练习题,挺复杂的,用好decode函数,很有趣
- Oracle数据库:oracle组函数,聚合函数,多行函数,avg,sum,min,max,count,group by,having
- Oracle数据库:oracle数据类型转换to_char()日期和数字转字符,to_number()字符转数字,to_date()字符转日期函数
- Oracle数据库:oracle字符类型、数字类型、创建表表名的命名规则
- Oracle数据库:oracle 11g安装教程,已安装好的oracle各个文件夹的作用,oracle用户权限怎么样
- Oracle imp/impdp 导入dmp文件到数据库
- oracle 如何查看创建表等数据库对象时的DDL语句
- Oracle数据库内置函数
- Oracle基本操作,Oracle修改列名,Oracle修改字段类型
- oracle函数 current_timestamp
- oracle数据库之子查询
- 数据恢复:如何恢复Linux中意外删除的Oracle和MySQL数据库
- 性能测试过程中oracle数据库报ORA-27301 ORA-27302错
- [Oracle]如何取Control File 的Dump
- springMVC 配置jdbcTemplate连接Oracle数据库出错
- oracle数据库备份
- 将oracle从数据库32位平台迁移到64位置
- 【从翻译mos文章】在oracle db 11gR2版本号被启用 Oracle NUMA 支持
- Oracle数据库创建只读用户
- oracle的imp导入时覆盖目标数据库
- Oracle数据库sql常用