C:\Documents and Settings\Administrator>exp jxkh/jxkh@jxkh file=c:\jxkh_080603.d
mp inctype=complete full=y(执行这条命令时报错)Export: Release 8.1.7.0.0 - Production on 星期二 6月 3 11:55:39 2008(c) Copyright 2000 Oracle Corporation. All rights reserved.
EXP-00056: ORACLE 错误 12154 出现
ORA-12154: TNS: 无法处理服务名
EXP-00000: 导出终止失败C:\Documents and Settings\Administrator>
JXKH_118 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.118)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jxkh)
)
)
JXKH_117 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jxkh)
)
)tnsnames.ora配置如下:(均能用pl\sql连接上)
JXKH_yzt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.128)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jxkh)
)
)
mp inctype=complete full=y(执行这条命令时报错)Export: Release 8.1.7.0.0 - Production on 星期二 6月 3 11:55:39 2008(c) Copyright 2000 Oracle Corporation. All rights reserved.
EXP-00056: ORACLE 错误 12154 出现
ORA-12154: TNS: 无法处理服务名
EXP-00000: 导出终止失败C:\Documents and Settings\Administrator>
JXKH_118 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.118)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jxkh)
)
)
JXKH_117 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jxkh)
)
)tnsnames.ora配置如下:(均能用pl\sql连接上)
JXKH_yzt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.10.128)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jxkh)
)
)
解决方案 »
- 请问怎么解决报错“ora-00911:无效字符”?
- 请帮忙写一个function实现这个功能
- 求一条SQL
- 游标有什么用
- 怎么看oracle 帮助文件 DESC[RIBE] {[schema.]object[@connect_identifier]} ??
- oracle10 安装成功后怎么没有 Enterprise Manager Configuration Assistant
- 怎样把一个用户创建的表以及sequences 等 对象,复制到另外一个用户下
- 请高手教教我,一个挺简单但又不太好解决的问题!
- 紧急求救!语句有毛病
- plsql如何关闭&的提示框
- 百分求教 :Oracle不包含某条件的模糊查询语句
- oracle817安装失败!
mp inctype=complete full=y
试试