Oracle impdb command throws ORA-12154 error, but sqlplus and sql developer are working properly

55 views Asked by At

I installed oracle 12c freshly in windows computer and created a new database service. It initially was not recognized by the Oracle SQL Developer, but after I reconfigure the default listener Oracle SQL Developer and SQLPlus were connected to the database service.

But when I tried to import a DB dump using impdb command, repeatedly I got the following error.

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

sql developer connection status

windows services

The import command -

impdp system/password@ORCL schemas=mline directory=TEST_DIR dumpfile=DUMP_V005.DMP logfile=DUMP_V005_LOG.log;

I will be grateful if you could help me to solve this issue. (Please note that I am relatively a beginner in the context of oracle installation process.)

0

There are 0 answers