question Re: SQOOP Connection Issue ( Sqoop to Oracle) in Support Questions

question Re: SQOOP Connection Issue ( Sqoop to Oracle) in Support Questions https://community.cloudera.com/t5/Support-Questions/SQOOP-Connection-Issue-Sqoop-to-Oracle/m-p/290378#M214846 Hi Jsensharma,Thank you for your updates**********************************With netstat : [cloudera@quickstart ~]$ netstat -tnlpa | grep 1521 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) [cloudera@quickstart ~]$ sudo netstat -tnlpa | grep 1521 [cloudera@quickstart ~]$ *****************************************************************************I have added '--driver' and facing a new issue now. And we are able to list the tables in sql developer for 'HR' user. [cloudera@quickstart ~]$ sqoop list-tables \ > --driver oracle.jdbc.driver.OracleDriver \ > --connect jdbc:oracle:thin:@localhost:1521:pdborcl \ > --username hr \ > -P \ > --verbose Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 20/02/24 11:41:28 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.13.0 20/02/24 11:41:28 DEBUG tool.BaseSqoopTool: Enabled debug logging. Enter password: 20/02/24 11:41:31 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory 20/02/24 11:41:31 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory 20/02/24 11:41:31 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time. 20/02/24 11:41:31 INFO manager.SqlManager: Using default fetchSize of 1000 20/02/24 11:41:32 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection. 20/02/24 11:41:32 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:662) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:560) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:539) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:506) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:595) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:230) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496) ... 15 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:161) at oracle.net.nt.ConnOption.connect(ConnOption.java:159) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:428) ... 20 more Could not retrieve tables list from server 20/02/24 11:41:32 ERROR tool.ListTablesTool: manager.listTables() returned null Mon, 24 Feb 2020 19:47:35 GMT Prabhu_Muppala 2020-02-24T19:47:35Z