The fast load for copy in Oracle uses the tnsnames.ora file on the target machine to determine the Oracle instance's port number. If this file is not correct, you may see the following error in the kernel’s log file:(<model name>_<host name>.log):
TNS:no listenerTNS:no listenerSee your Oracle system administrator for help to adjust this Oracle setting. For more information on the fast load, see the Advanced User Guide.