oracle数据库用expdp命令报错，求解？？

[JoePotter]

[oracle@timran dir1]$expdp scott/scott@orcl directory=MY_DIR dumpfile=expdp_scott2.dmp tables=emp,dept

Export: Release 11.1.0.6.0 - Production on 星期日, 08 12月, 2013 16:08:35

Copyright (c) 2003, 2007, Oracle. All rights reserved.

UDE-12154: 操作产生了 ORACLE 错误 12154
ORA-12154: TNS: 无法解析指定的连接标识符

[CT_LXL]

引用 楼主 j610152753 的回复:

[oracle@timran dir1]$expdp scott/scott@orcl directory=MY_DIR dumpfile=expdp_scott2.dmp tables=emp,dept Export: Release 11.1.0.6.0 - Production on 星期日, 08 12月, 2013 16:08:35 Copyright (c) 2003, 2007, Oracle. All rights reserved. UDE-12154: 操作产生了 ORACLE 错误 12154 ORA-12154: TNS: 无法解析指定的连接标识符

连接不上实例orcl,看一下监听是否有问题

[JoePotter]

嗯！在linux中和windows中配置是一样的吗？

[CT_LXL]

引用 2 楼 j610152753 的回复:

嗯！在linux中和windows中配置是一样的吗？

lsnrctl status 看一下orcl是否正常

[JoePotter]

[oracle@timran ~]$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 08-12月-2013 17:22:46 Copyright (c) 1991, 2007, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=timran.localdomain)(PORT=1521))) TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 Linux Error: 111: Connection refused 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 Linux Error: 111: Connection refused

[JoePotter]

不知道那里出错啦。

[JoePotter]

listener.ora： LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = timran.localdomain)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= timran11g) (ORACLE_HOME = /u01/oracle) (SID_NAME = timran11g) ) ) tnsnames.ora： LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = timran11g) (PRESENTATION = RO) ) ) TIMRAN11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = timran.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = timran11g) ) )

[惜分飞]

expdp 使用于服务端，一般不需要tns orcl 应该不存在

[JoePotter]

谢谢大家，我已经解决啦，方法如下 这个报错跟权限相关，一番google，解决如下： # chmod 777 /var/tmp/.oracle 原因分析：应是Oracle卸载不干净，导致/var/tmp/.oracle目录权限不足，故而报错。

[sd_oracle_dba]

楼主，我在win7下遇到这个问题，请问怎么解决呢？查遍百度都没找到答案。