question Re: Can we use Oracle SID in --connect option of sqoop loader? in Archives of Support Questions (Read Only)

Can we use Oracle SID in --connect option of sqoop loader?

nilesh_shrimant — Fri, 08 Sep 2017 10:34:23 GMT

Geerally when we use --connect option in sqoop we use "jdbc:oracle:thin:@hostname:port/DB_SERVICE_NAME".

But can we user DB_SID instead of DB_SERVICE_NAME in connect option? If yes what will be the syntax for that.

Re: Can we use Oracle SID in --connect option of sqoop loader?

jsensharma — Fri, 08 Sep 2017 11:36:13 GMT

According to the JDBC Driver implementation it can take SID as well like, If the database to which you want to connect resides on host prodHost, at port 1521, and system identifier (SID) ORCL, and you want to connect with user name scott and password tiger, then use either of the two following connection strings:

Using host:port:sid 

syntax:
String connString="jdbc:oracle:thin:@prodHost:1521:ORCL";

NOTICE: After Port there is a Colon (:) and then SID.
https://docs.oracle.com/cd/B28359_01/java.111/b31224/jdbcthin.htm

Are you getting any error while using SID in the same URL ?

Re: Can we use Oracle SID in --connect option of sqoop loader?

nilesh_shrimant — Fri, 08 Sep 2017 16:03:44 GMT

Hi @Jay SenSharma, Thanks very much for the information. "String connString="jdbc:oracle:thin:@prodHost:1521:ORCL" this worked fine.

Re: Can we use Oracle SID in --connect option of sqoop loader?

jsensharma — Fri, 08 Sep 2017 16:10:14 GMT

@Nilesh Shrimant

Good to know that your issue is resolved. It will be wonderful if you can make the correct answer as "Accepted" so that it will be useful for other HCC users to quickly browse the answered threads.