Oracle SQL Connector for Hadoop Distributed File System (HDFS) Publish Command Fails with java.sql.SQLRecoverableException: Network Adapter could not establish the connection (Doc ID 1558318.1)

Last updated on JUNE 04, 2013

Applies to:

Oracle SQL Connector for Hadoop Distributed File System - Version 2.0 and later
Linux x86-64

Symptoms

Oracle SQL Connector for Hadoop Distributed File System (OSCH), publish command fails with the following error:

$ hadoop jar $OSCH_HOME/jlib/orahdfs.jar oracle.hadoop.exttab.ExternalTable \
  -D oracle.hadoop.exttab.tableName=<Table Name> \
  -D oracle.hadoop.exttab.dataPaths=<Data Path> \
  -D oracle.hadoop.hdfs.exttab.connection.url="jdbc:oracle:thin:@//<hostname>:<port>/<SID>" \
  -D oracle.hadoop.hdfs.exttab.connection.user=ORACLE  -publish

Oracle SQL Connector for HDFS Release 2.0.0 - Production

Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.

[Enter Database Password:]
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
oracle.net.ns.NetException: The Network Adapter could not establish the connection
....................

 

Connecting to Oracle database using the same hostname/port/sid works fine usng Sqlplus or Jdbc Sample program.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms