Error: While connecting to Oracle database from Pyspark

I have set the Spark Class path in environment variables.
SPARK_CLASSPATH = C:\Oracle\Product\11.2.0\client_1\jdbc\lib\ojdbc6.jar

IllegalArgumentException Traceback (most recent call last)
in ()
7 jdbcurl = "jdbc:oracle://nn01.itversity.com:3306/retail-db?username=retail_dba&password=itversity"
8 #"jdbc:mysql://quickstart.cloudera:3306/retail_db?user=retail_dba&password=cloudera"
----> 9 dfx = sqlContext.read.format(source="jdbc", url=jdbcurl, dbtable="table_name").load()

C:\spark-2.1.0\python\pyspark\sql\context.pyc in read(self)
462 :return: :class:DataFrameReader
463 """
--> 464 return DataFrameReader(self)
465 
466 @property

C:\spark-2.1.0\python\pyspark\sql\readwriter.pyc in init(self, spark)
68 
69 def init(self, spark):
---> 70 self.jreader = spark.ssql_ctx.read()
71 self._spark = spark
72

C:\spark-2.1.0\python\lib\py4j-0.10.4-src.zip\py4j\java_gateway.py in call(self, *args)
1131 answer = self.gateway_client.send_command(command)
1132 return_value = get_return_value(
-> 1133 answer, self.gateway_client, self.target_id, self.name)
1134 
1135 for temp_arg in temp_args:

C:\spark-2.1.0\python\pyspark\sql\utils.pyc in deco(*a, **kw)
77 raise QueryExecutionException(s.split(': ', 1)[1], stackTrace)
78 if s.startswith('java.lang.IllegalArgumentException: '):
---> 79 raise IllegalArgumentException(s.split(': ', 1)[1], stackTrace)
80 raise
81 return deco

IllegalArgumentException: u"Error while instantiating 'org.apache.spark.sql.hive.HiveSessionState':"

Any suggestions on this please?

7 jdbcurl = "jdbc:oracle://nn01.itversity.com:3306/retail-db?username=retail_dba&password=itversity"
8 #“jdbc:mysql://quickstart.cloudera:3306/retail_db?user=retail_dba&password=cloudera”

for this thing to work, there should be a oracle database running on nn01.itversity.com and more over it should have its listener on port 3306. In general oracle uses port 1521 as listener. Please make sure you have these things setup and try again…

I have the actual server name and port number, But I modified here.