Oracle reported an error when importing imp data: ORA-12592: TNS: Package Error
When using imp to import data, check that only more than 3 million data entries are actually imported into the more than 1 million data entries table and check the import log. The following error message is displayed,
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Tes by using the regular path from EXPORT: the exported file created in V11.02.00 has been imported into the ZHS16GBK Character Set and AL16UTF16 NCHAR character set. importing HYL object to HYL .. importing table "TB_HYL_WS ".................................. ........................................ .......... ........................................ ........................................ ............. IMP-00058: An ORACLE error occurred. 12592ORA-12592: TNS: packet error IMP-00018: the import of part of the previous table has been completed. The import of row 1772044 has been successfully aborted, but a warning is displayed.
After the check, the tns error information points are used to suspect network problems. The importing machine is connected through a client, so the xmanager software uploads the dmp file to the server and re-executes the imp import command, import the table smoothly and view the log information as follows:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V11.02.00 via conventional pathimport done in ZHS16GBK character set and AL16UTF16 NCHAR character set. importing HYL's objects into HYL. . importing table "TB_HYL_WS" 3701686 rows importedImport terminated successfully without warnings.