SLTechnology News&Howtos › Database ›

UDE-12154: operation generated ORACLE error 12154

Shulou Source: shulou.com Published: 2022-06-01 10:46:09 10月03日 Update

[oracle@PLUSTEST ~] $expdp system/gacHZdba2018@PLUSDEV directory=dump_dir dumpfile=plusdevschema.dmp schemas=PLUSDEV

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

Expdp exported Times error, ORA-12154 TNS: unable to parse the specified connection identifier

Solution:

1. Confirm that the shcemas is correct

2. Add the ip address to the export statement

[oracle@PLUSTEST ~] $expdp system/gacHZdba2018@172.19.31.100/PLUSDEV directory=dump_dir dumpfile=plusdevschema.dmp schemas=PLUSDEV