远程连接数据库的问题 本地NT下ORACLE要通过链路连接远程数据库,请问如何建立与远程数据库的连接串(都是ORACLE) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1、在本地建立TNSNAME,指向对方DuiFang = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Ora) ) ) 2、建数据库链接create database link 链接名 connect to 对方用户名 identified by 对方口令; 操作对方库:SELECT * FROM tablename@链接名 nt 下找到TNSNAMEs.ora文件,用记事本打开加入下面代码test = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521)) --修改10.1.1.2为目的数据库的IP) (CONNECT_DATA = (SERVICE_NAME = Ora) --修改Ora为目的数据库的实例名) ) 这样就得到了TEST连接串测试sql>conn system/manager@test 数据库在机房,只有一个ORACLE用户,无法直接进行文件操作 **Find the file mentioned above and then write codes below in it****create local instance**LocalInstance = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = objectip)(PORT = objectport)) ) (CONNECT_DATA = (SERVICE_NAME = Name) ) ) **create link**create database link linkname connect to objectname identified by objectpassword 请教一个oracle游标的用法! 运行jdbc应用时并用cme连接oracle,端口冲突? oracle10g存储过程的问题 刚装完Oracle,不会用 请教ORACLE中SQL的执行过程。 问个sql的写法 字符型字段,值为空,如何用SQL语句判断此字段值为空? 关于回滚 怎样定义一个JOB每隔20分钟执行一下? 新手请教:关于日期显示的问题. 跪求:怎样把日期字段的日期值一天不漏的显示出来 50 分请教一个问题
DuiFang =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Ora)
)
) 2、建数据库链接
create database link 链接名 connect to 对方用户名 identified by 对方口令;
SELECT * FROM tablename@链接名
加入下面代码
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521)) --修改10.1.1.2为目的数据库的IP
)
(CONNECT_DATA =
(SERVICE_NAME = Ora) --修改Ora为目的数据库的实例名
)
)
这样就得到了TEST连接串
测试
sql>conn system/manager@test
**create local instance**
LocalInstance =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = objectip)(PORT = objectport))
)
(CONNECT_DATA =
(SERVICE_NAME = Name)
)
) **create link**
create database link linkname connect to objectname identified by objectpassword