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

Tony007Sep 30 2021

hi am having this error when doing import in 19c in solaris
oracle@hostname:/u01/app/oracle/product/19.0.0/dbhome_1$ impdp schmename/pswd@dbname schemas=schmename directory=TEST_DIR dumpfile=dumpfile_schemao1.dmp.dmp logfile=impdpSCOTT.log

Import: Release 19.0.0.0.0 - Production on Thu Sep 30 16:24:10 2021
Version 19.5.0.0.0

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

UDI-12154: operation generated ORACLE error 12154
ORA-12154: TNS:could not resolve the connect identifier specified

oracle@hostname:/u01/app/oracle/product/19.0.0/dbhome_1$ lsnrctl

LSNRCTL for Solaris: Version 19.0.0.0.0 - Production on 30-SEP-2021 16:24:16

Copyright (c) 1991, 2019, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> service
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "dbname" has 1 instance(s).
Instance "dbname", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "acorXDB" has 1 instance(s).
Instance "dbname", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: hostname, pid: 1243>
(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=44004))
The command completed successfully
LSNRCTL> exit
oracle@hostname:/u01/app/oracle/product/19.0.0/dbhome_1$ impdp schmename/pswd@dbname:1521/192.168.8.138 schemas=schmename directory=TEST_DIR dumpfile=ACOR_schemao1.dmp.dmp logfile=impdpSCOTT.log

Import: Release 19.0.0.0.0 - Production on Thu Sep 30 16:25:25 2021
Version 19.5.0.0.0

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

UDI-12154: operation generated ORACLE error 12154
ORA-12154: TNS:could not resolve the connect identifier specified

Comments
Post Details
Added on Sep 30 2021
0 comments
626 views