菜鳥問題﹕怎么連接另一台數據庫服務器? 最简单的办法就是在ORACLE配置文件tnsnames.ora中加入服务器的SID,然后就可以通过该SID登陆了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 請問服務器的SID是什么?具體怎么加呢? 直接在net config assistant工具中配置吧服務器的SID可以去问一下安装数据库的人 D:\oracle\ora90\network\ADMIN目录下的tnsnames中加入dbcon = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = databasename) ) )其中127.0.0.1是数据库所在的服务器的地址,SERVICE_NAME = 远程数据库名字然后,用dbcon就能进行操作了(它为连接服务名) # TNSNAMES.ORA Network Configuration File: c:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora92) ) )WATCHDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.122)(PORT = 1521)) ) (CONNECT_DATA = (SID = ORCL) ) )ORA817 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kec-sekedgx7nzt)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora817) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = kec-sekedgx7nzt)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = ora817) (PRESENTATION = http://admin) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )这是我机器上的TNSNAMES。ORA,其中ora92对应服务器A中的ORACLE9i,watchdb对应服务器B中的ORACLE805,ORA817对应本机的ORACLE8I。 Oracle备份问题 请教oracle文件的问题 oracle能用db_link 连接notes吗? nvl的问题 恳请大虾指点一下Oracle全文检索设置的相关文章,非常感谢 数据表备份的问题 DEVELOP 2000 连接错误, 指教!! 再PL/SQL中,能否再出现异常后,处理相应的异常,然后程序继续运行后面的代码吗?我在编成中发现,只要已发生一个异常,程序就全部结束了 菜鸟求助!关于查询子句! 关于startup 和 shutdown的研究。 关于oracle中日期计算的问题!请教各位! 简单的sql语句问题
服務器的SID可以去问一下安装数据库的人
dbcon =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = databasename)
)
)
其中127.0.0.1是数据库所在的服务器的地址,SERVICE_NAME = 远程数据库名字
然后,用dbcon就能进行操作了(它为连接服务名)
# Generated by Oracle configuration tools.ORA92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora92)
)
)WATCHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.122)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)ORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kec-sekedgx7nzt)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kec-sekedgx7nzt)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ora817)
(PRESENTATION = http://admin)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)这是我机器上的TNSNAMES。ORA,其中ora92对应服务器A中的ORACLE9i,watchdb对应服务器B中的ORACLE805,ORA817对应本机的ORACLE8I。