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 NOVEMBER 08, 2022

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

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Cause

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

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)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

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