EXP-00056: ORACLE error 12154 en

在从库上使用exp导出数据时报错

[oracle@pldb02 oracle]$ exp 'powerdesk/xxxxxx"@powerdes' file=/oracle/powerdes-20170921.dmp log=/oracle/powerdes-20170921.log grants=y

Export: Release 11.2.0.4.0 - Production on Thu Sep 21 13:06:51 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
EXP-00000: Export terminated unsuccessfully

使用tnsping检查：

[oracle@pldb02 oracle]$ tnsping powerdes
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-SEP-2017 13:07:11

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/oracle/app/oracle/product/11.2.0.4/dbhome_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

如果 数据库名称配置不对，添加如下内容

CRSP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = crsp)
    )
  )

重启监听服务

参考文章：https://www.jianshu.com/p/1cef8204a987