oracle 11g ORA-12514错误，我的解决办法

关注

原创最新推荐文章于 2026-03-22 00:28:03 发布 2w 阅读 AI 写同款· GEO 优化 ›

Oracle数据泵导入dmp文件，报UDI-12154、ORA-12154错误解决办法 1. 数据泵导入dmp文件，报UDI-12154、ORA-12154 　　1.1 导入命令 impdp cwy_init/init@orcl directory=DATA_PUMP_DIR dumpfile=cwy_init_0806.dmp REMAP_SCHEMA=cwy_init:cwy_init transform=segment_attributes:n logfile= imp_... 阅读详情

前言:网上有很多解决办法，删listener.ora也好，还是什么也好，都解决不了我这个问题，依然报12514错误，以下是我逐个尝试后成功的监听字符串。。

listener.ora文件：

# listener.ora Network Configuration File: d:/app/john/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = cjtfs)
      (ORACLE_HOME = d:/app/john/product/11.1.0/db_1)
      (PROGRAM = cjtfs)
    )
     (SID_DESC =
      (GLOBAL_DBNAME = cjtfs)
      (ORACLE_HOME = d:/app/john/product/11.1.0/db_1)
      (SID_NAME = cjtfs)
    )
)
LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    )
)

tnsnames.ora文件：

# tnsnames.ora Network Configuration File: d:/app/john/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

CJTFS =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cjtfs)   #要和listener.ora里面的cjtfs位置的名字保持一致
    )
)

如果还解决不了，那就留言，我一般会常看blog的。。。。大家一起解决。。互相学习。