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
