Oracle Database import DMP File error handling method

An error occurred while executing the import command to the Oracle database, which probably means that the service name could not be found in TNS

Let's talk about the resolution step

1: Enter Oracle user, use Cat to view the. bash_profile file, locate the Oracle_home variable

2: Enter the Oracle_home/network/admin directory

3: Check the Tnsnames.ora listening file, find the corresponding listener name, such as the following import statement, can be executed successfully

[Email protected] admin]$ IMPDP efoas/[email protected]enfocog directory=expdp_dir dumpfile=efoas_14_ 20141118_1350.dmp Logfile=efoas_14_20141118_1350.log

Summary: Import and export username/[email protected] The ServerID here is the name of the listener in TNS, not the name of the database.

Oracle Database import DMP File error handling method