在XP 系统里安装了oracle,局域网中有一台服务器,IP 是192.168.0.118,服务器是linux AS5系统,oracle 10G的数据库,想把一DMP 文件导入到该服务器上,导入的时候总是提示:C:\Documents and Settings\Administrator>imp mcc2/mcc file=h:\ora\20101113.cmp IG
NORE=N FULL=YImport: Release 10.2.0.1.0 - Production on 星期三 12月 8 09:54:31 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: 遇到 ORACLE 错误 12560
ORA-12560: TNS: 协议适配器错误
IMP-00000: 未成功终止导入在百度里搜索出来的解决方法都不能解决问题。谁能帮个忙,看看到底怎么回事。sqlnet和tnaname文件的内容分别为
SQLNET:# sqlnet.ora Network Configuration File: h:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.118)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
TNSNAME:# tnsnames.ora Network Configuration File: H:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.118)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
请帮忙看看到底配置哪儿出问题了。
NORE=N FULL=YImport: Release 10.2.0.1.0 - Production on 星期三 12月 8 09:54:31 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: 遇到 ORACLE 错误 12560
ORA-12560: TNS: 协议适配器错误
IMP-00000: 未成功终止导入在百度里搜索出来的解决方法都不能解决问题。谁能帮个忙,看看到底怎么回事。sqlnet和tnaname文件的内容分别为
SQLNET:# sqlnet.ora Network Configuration File: h:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.118)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
TNSNAME:# tnsnames.ora Network Configuration File: H:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.118)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
请帮忙看看到底配置哪儿出问题了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货