All Forums Teradata Studio
rakeshsapbo 36 posts Joined 04/13
27 Jul 2014
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- oraclesqlserver
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.JDBCCo nnection.createConnection(JDBCConnection.java:213)
 at org.eclipse.datatools.connectivity.DriverConnectionBas e.internalCreateConnection(DriverConnectionBase.java: 105)
 at org.eclipse.datatools.connectivity.DriverConnectionBas e.open(DriverConnectionBase.java:54)
 at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo nnection.open(JDBCConnection.java:73)
 at org.eclipse.datatools.enablement.internal.oracle.JDBCO racleConnectionFactory.createConnection(JDBCOracleConn ectionFactory.java:27)
 at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv ider.java:83)
 at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(ConnectionProfile.java:359)
 at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(PingJob.java:76)
 at org.eclipse.datatools.connectivity.ui.PingJob.run(Ping Job.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

 
 

Rakesh Reddy G
fgrimmer 553 posts Joined 04/09
27 Jul 2014

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? 

You must sign in to leave a comment.