利用Sqoop从oracle同步数据到HDFS出现The Network Adapter could not establish the connection的解决方法

问题：Data Connector for Oracle and Hadoop is disabled，Error executing statement: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

解决方法：①将Oracle TNS配置文件中HOST中localhost换成本机的IP地址

②打开Oracle Net Manager 修改监听程序中主机信息，把localhost改成本机IP地址

③重启oracle两服务：OracleServiceORCALEDB、OracleOraDb11g_home1TNSListener