Oracle reported error when importing imp data: ORA-12592: TNS: Package error, ora-12592tns
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/43153127
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.
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/43153127