比如:STEPDEVE 这个就不可以
STEPDEVE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STEPDEVE)
)
)
比如STEPDEVE_1.1 这个就可以,只要STEPDEVE_1.1 中有一个符号“.”就可以,这是为什么?谢谢
STEPDEVE_1.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STEPDEVE)
)
)
STEPDEVE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STEPDEVE)
)
)
比如STEPDEVE_1.1 这个就可以,只要STEPDEVE_1.1 中有一个符号“.”就可以,这是为什么?谢谢
STEPDEVE_1.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STEPDEVE)
)
)
解决方案 »
- 安装完CRS后,OracleCSService服务启动不了.....
- oracle 动态执行的sql语句中, insert into 中用多个union all 连接出来的语句效率高, 还是把union all分成多个insert into 效率高呢, 为什么?
- OTL编译错误,求救
- 请问这样的数据如何插入?
- connect_by_root 的使用方法
- oracle 9i 在window 2000server 上的安装
- 如何在多个回话中共享包的数据?
- trigger:每次update table1,table2字段值自增1,不运行?
- 导入导出
- oracle12 打不开管理控制台
- 我应聘联创时的一个SQL题,大家踊跃讨论。
- !!!!!!!求一条SQL语句!!!!!!!在线等各位达人!!!!!!!!
如果有的话,连接很难成功.
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.1.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STEPDEVE)
)
)
为什么不可以?我看了我的tnsnames.ora文件我觉得没有什么问题,以下是我的
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MYBILL)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OEMREP)
)
)
ORA-12154: TNS:could not resolve service name,那个service_name是不能随便改的,
只有最顶行的那个名称才可以以任何形式的字串存在的.