Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\lenovo>exp system/abc123@//192.168.16.5/orcl tables=(users) file=d:/use
rs.bakExport: Release 10.2.0.3.0 - Production on 星期四 11月 29 23:11:41 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 12170
ORA-12170: TNS: 连接超时
EXP-00000: 导出终止失败C:\Users\lenovo>
我的D:\oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora文件内容:# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)按理来说,数据库的HOST对应的改成了192.168.16.5,为什么还不行呢,无解,
环境:windows DOS窗口下。
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\lenovo>exp system/abc123@//192.168.16.5/orcl tables=(users) file=d:/use
rs.bakExport: Release 10.2.0.3.0 - Production on 星期四 11月 29 23:11:41 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 12170
ORA-12170: TNS: 连接超时
EXP-00000: 导出终止失败C:\Users\lenovo>
我的D:\oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora文件内容:# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)按理来说,数据库的HOST对应的改成了192.168.16.5,为什么还不行呢,无解,
环境:windows DOS窗口下。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货