Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12154: TNS:could not resolve the connect identifier specified

User_SDELXAug 21 2019 — edited Aug 22 2019

Windows Oracle Database 18c Express Edition

imp 'system/manager@xyz' file=C:\SHARE\CPSDBBACKUP_08152019.DMP full=yes log=C:\SHARE\implog.txt

Import: Release 18.0.0.0.0 - Production on Wed Aug 21 14:55:32 2019

Version 18.4.0.0.0

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

IMP-00058: ORACLE error 12154 encountered

ORA-12154: TNS:could not resolve the connect identifier specified

IMP-00000: Import terminated unsuccessfully

-----------------------------------

tnsping xe

TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 21-AUG-2019 14:58:26

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

Used parameter files:

E:\Oracle\dbhomeXE\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.197.46)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))

OK (0 msec)

How can I fix ORA-12154: TNS:could not resolve the connect identifier specified?

Thank you,

Dmitriy

This post has been answered by L. Fernigrini on Aug 21 2019
Jump to Answer
Comments
Post Details
Added on Aug 21 2019
24 comments
7,409 views