client tnsnames.ora :
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.MYORDB.DOMAIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myordb)
)
)MYORDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myordb)
)
)
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.MYORDB.DOMAIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myordb)
)
)MYORDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myordb)
)
)
我重新配置了tnsname.ora 如下:
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ERP_MYORDB.DOMAIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myordb)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myordb)
)
)
我重新配置了tnsname.ora 如下:
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ERP_MYORDB.DOMAIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myordb)
)
)---------------------------------------------------------------------
这时连接应该没问题啊,看不出有什么问题。
现在报的错是什么?
tnsping 192.168.18.37能成功吗?
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myordb)
)
)
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp)(PORT = 1521))
)
)
)
erp改成IP,重起监听试试
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = myordb)
)
)
+++++++++++++++++++++++++++++++TNSPING TEST