1.OracleOraDb10g_home1TNSListener和OracleServiceNANFUNG服务已启动
2.服务器注册表中已有Oracle_Sid=NanFung
3.服务器系统环境变量中已有Oracle_HOME和Oracle_Sid两项值,分别为:
Oracle_HOME=C:\oracle\product\10.2.0
Oracle_Sid=NanFung
4.服务器端listener.ora文件为:
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = NanFungDB)
(SID_NAME = NanFung)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.78)(PORT = 1521))
)
5.客户端tnsnames.ora为:
# tnsnames.ora Network Configuration File: I:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
NANFUNGDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.78)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = NanFungDB)
)
)
6.在服务器端连接:
7.客户端连接:
请问如何解决?谢谢!~