Unable to establish connectivity to Oracle through Teradata Studio Express TD Studio Expv15

Teradata Studio
Enthusiast

Unable to establish connectivity to Oracle through Teradata Studio Express TD Studio Expv15

Hi Experts,

i have tried to establish a connection to connect to Oracle 11g db through TD Std Exp v15 ,unfortunately i am unable to establish the connection below are the steps i have followed

Reference

https://forums.teradata.com/forum/teradata-studio/teradata-studio-express-connectivity-to-oraclesqls...

1) get working TNS entry for your Oracle instance ---?

2) download (ideally from OTN website) & install Oracle jdbc drivers (ojdbc6.jar) --> just put them to any folder you like --- done

3) run 'new connection profile' wizard --> choose Oracle as vendor and name your connection as used to ---done

4) install new jdbc driver --> choose "OtherOracle" --> provide JAR file location (from step #2) --> done

5) --> properties tab values to be like this:

  * Connection URL: jdbc:oracle:thin:@//

  * ​​Driver Class: oracle.jdbc.OracleDriver 

Note: /for OracleThinDriver  11 looks like this:/ Connection URL:

jdbc:oracle:thin:@server:1521:db

1) save it,edit credentials, for jdbc URL use notation like this: jdbc:oracle:thin@tns-entry-without-identificator

  *

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.example.net)(PORT=1526))(ADDRESS=(PROTOCOL=tcp)(HOST=node2.example.net)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=exam.prod.net)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=1))))

Step 5

i have captured the TNS entry from the below path from my local system

C:\app\abc\product\11.2.0\dbhome_1\NETWORK\ADMIN

Tns entry from tnsnames.org file

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

need some understanding on the below

jdbc:oracle:thin:@server:1521:db

what do we have to mention beside Connection URL

error message i got

java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

 at java.net.URLClassLoader$1.run(Unknown Source)

 at java.net.URLClassLoader$1.run(Unknown Source)

 at java.security.AccessController.doPrivileged(Native Method)

 at java.net.URLClassLoader.findClass(Unknown Source)

 at java.lang.ClassLoader.loadClass(Unknown Source)

 at java.net.FactoryURLClassLoader.loadClass(Unknown Source)

 at java.lang.ClassLoader.loadClass(Unknown Source)

 at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:213)

 at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

 at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

 at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)

 at org.eclipse.datatools.enablement.internal.oracle.JDBCOracleConnectionFactory.createConnection(JDBCOracleConnectionFactory.java:27)

 at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

 at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

 at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

 at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

can you please guide me where exactly i need to correct???

Thanks,

Rakesh Reddy .G

1 REPLY
Teradata Employee

Re: Unable to establish connectivity to Oracle through Teradata Studio Express TD Studio Expv15

Rakesh, It looks like, from the exception, that it can't find the JDBC driver jar. Did you do steps 2 and 4 from above?