portaldb =
(DEs criptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IP)(HOST = 192.168.0.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = portaldb)
)
) 我要连接到192.168.0.13 数据库名为portaldb 的ORACLE数据库。谢谢!
(DEs criptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IP)(HOST = 192.168.0.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = portaldb)
)
) 我要连接到192.168.0.13 数据库名为portaldb 的ORACLE数据库。谢谢!
尽量都保持大写 DESCRIPTION
问题2:第3行多余,这一行可全部去掉;
问题3:第5行的右括号多余,去掉;
问题4:
(CONNECT_DATA =
(SERVICE_NAME = portaldb)
)
之间少一行:(SERVER = DEDICATED)修改后应为:
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =portaldb)
)
问题5:第二行(PROTOCOL = IP)中IP应改为TCP
正确的配置文件为:portaldb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = portaldb)
)
)
portaldb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.13)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = portaldb)
)
) 就可以了吗?
我给出一个我的正确的配置文件,如下所示:
SIEDW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.7)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = SIEDW)
)
)
这个TNSNAME 我觉的最好是 不要自己写。
因为这里面 格式要求很严格的。
空格什么的 都要一致。