要连接远程数据库,怎么修改tnsname.ora文件 原先都是本地的数据库,现在想连接远程的名为ABC数据库那要怎么修改tnsname.ora文件? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 主机IP地址)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ABC) ) ) ERROR:ORA-12154:TNS:无法解析指定的连接标识符 注意此处不能有空格TEST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 你要连接机器的ip)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = 你要连接数据库的sid))) 10G 可以用 net manager进行配置,顺便还可以测试连接 配置的第一行行首,也就是tnsname前面 远程的数据库叫oracle,IP:192.168.2.189,下面的配置有问题吗?(我就改了HOST,和SERVER_NAME两处)# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.SANDING = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.2.189)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =oracle) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 链接名 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 地址)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 是的,就地址跟ORCL两处改动过 你的主机和oracle主机在同一个域没有? 两点:1.ping一下你的服务器IP,是否ping的通;2.下面连接的不是书库看名,是sid名 这个网络没有域客户机的IP是:192.168.1.123服务器的IP是:192.168.2.189 都能ping通,SID就是oracle这个名称 直接登录主机,查看一下主机监听的service name执行 lsnrctl status ,把运行结果贴上来看看 请教大家一个问题感觉很诡异 MS SQL函数如何转化为ORACLE函数 oracle 9i 导入dump文件问题 oracle 里建的表在哪里呢,能像sql server的企业管理器一样查询出来并能看见内容吗?在哪里看呢??? 利用utl_file进行文件读写的错误 为什么方案下面多了很多表 问个sql语句 求救:我在redhat9下安装oracle9i初期碰到的问题 Services Name的问题,很急,希望大家快快帮忙 查询语句求助 大数据查询sql 求助
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ABC)
)
)
ORA-12154:TNS:无法解析指定的连接标识符
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 你要连接机器的ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 你要连接数据库的sid)
)
)
# Generated by Oracle configuration tools.SANDING =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.2.189)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =oracle)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
链接名 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
是的,就地址跟ORCL两处改动过
都能ping通,SID就是oracle这个名称
执行 lsnrctl status ,把运行结果贴上来看看