连接时如下提示:
SQL> connect scott/tiger @lu1gzzb;
ERROR:
ORA-12154: TNS:could not resolve service name另外服务器端$oracle_home/network/admin/tnsnames.ora内容如下:
# TNSNAMES.ORA Network Configuration File: /oracle/oracle9i/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.lu1gzzb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.175)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =lu1gzzb )
)
)
另外客户端$oracle_home/network/admin/tnsnames.ora文件内容如下:
# TNSNAMES.ORA Network Configuration File: C:\oracle9i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LU1GZZB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.175)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lu1gzzb)
(SERVER = DEDICATED)
)
)
希望知道原因的能告诉偶一声,再次谢谢
SQL> connect scott/tiger @lu1gzzb;
ERROR:
ORA-12154: TNS:could not resolve service name另外服务器端$oracle_home/network/admin/tnsnames.ora内容如下:
# TNSNAMES.ORA Network Configuration File: /oracle/oracle9i/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.lu1gzzb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.175)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =lu1gzzb )
)
)
另外客户端$oracle_home/network/admin/tnsnames.ora文件内容如下:
# TNSNAMES.ORA Network Configuration File: C:\oracle9i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LU1GZZB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.175)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lu1gzzb)
(SERVER = DEDICATED)
)
)
希望知道原因的能告诉偶一声,再次谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货