Hive同步数据到Oracle报错：java.sql.SQLException: ORA-12592: TNS:bad packet

大数据架构师Pony

已于 2022-06-21 10:35:59 修改

阅读量870

点赞数

分类专栏：大数据之Hive 文章标签： hive oracle hadoop

于 2022-06-14 14:06:10 首次发布

本文链接：https://blog.youkuaiyun.com/u011110301/article/details/125276781

版权

报错如下：

2022-02-21 18:07:56,595 FATAL [IPC Server handler 22 on 42371] org.apache.hadoop.mapred.TaskAttemptListenerImpl:
 Task: attempt_1639734219463_44543_m_000001_0 - exited : 
 java.io.IOException: java.sql.SQLException: ORA-12592: TNS:bad packet

        at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:233)
        at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:46)
        at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:658)
        at org.apache.hadoop.mapreduce.task.TaskInputOutputContextImpl.write(TaskInputOutputContextImpl.java:89)
        at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.write(WrappedMapper.java:112)
        at org.apache.sqoop.mapreduce.hcat.SqoopHCatExportMapper.map(SqoopHCatExportMapper.java:56)
        at org.apache.sqoop.mapreduce.hcat.SqoopHCatExportMapper.map(SqoopHCatExportMapper.java:35)
        at org.apache.hadoop.