Forum Discussion

NK12's avatar
NK12
Occasional Contributor
7 years ago

Unable to establish-Oracle Database Connection through ready api tool

Hello all,   I'm not able to establish the Oracle Data Base connection Have copied proper(ojdbc14.jar file) in bin\ext folder used the driver name as oracle.jdbc.driver.OracleDriver conne...
NK12's avatar
NK12
Occasional Contributor

Hello All,

1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear

2.I'm using the connection string as

jdbc:oracle:thin:UserName/Password@ServerName:1521:Sid

3.When i click on Test Connection Button it is not showing any pop up message as Connection successfully tested

4.However it shows in logs as The JDBC driver [oracle.jdbc.driver.OracleDriver] is already registered.

 

richie 

1.I'm able to connect my oracle db using my credentials through Toad Tool

2.My Java version is 1.8.0_172( I did research for this java version JDBC jar files-ojdbc6 and 7 are compatible

 

 

 

 

richie's avatar
richie
Community Hero
7 years ago
Hi NK12,

I have some thoughts but i'm driving at moment. Will respond in about an hour and a half.

Cheers

richie

  • richie's avatar
    richie
    Community Hero
    7 years ago
    Quick question. What version of oracle are you trying to connect to? (Not your local oracle installation, but the remote database you are trying to connect to?)
  • NK12's avatar
    NK12
    Occasional Contributor
    7 years ago

    richie

     

    It is Oracle 12

     

  • richie's avatar
    richie
    Community Hero
    7 years ago
    Hi ,

    Is it
    12? Uses ojdbc6.jar and %7.jar
    12.1.x.x? Uses ojdbc6.jar and %7.jar
    12.2.x.? Uses ojdbc8.jar
    12.c? Uses ojdbc8.jar

    Just need to make sure youre using the correct version

    In regards to testing your connection with toad....did you force it to connect via the thin driver? Toad uses tnsnames.ora file to connect by default, even though you might have thr thin driver setup as well. We need to determine IF the connection test is using the thin driver or tnsnames.ora file. With this in mind, rather than try and mess around disabling your tns connection in toad, can you navigate to the relevant directory and either rename the file (youll need elevated local admin privileges to edit this ifni remember correctly) so toad cant use the tnsnames.ora file OR comment out the connection setup in your tnsnames.ora file. Make sure toad is shut down whilst editing the file. Then relaunch toad and try and connect using the thin driver. That will confirm if its a soapui issue or not.

    Finally. Did you confirm that your environment variables (classpath, path and java_home) are correct? (Remember there can be other jre instances packaged up with other installed software...so you need to run 'java -version' at command prompt to ensure its using the jre you want it to. Ok. Thats it for now,

    Cheers

    richie



  • richie's avatar
    richie
    Community Hero
    7 years ago
    Added in error
  • NK12's avatar
    NK12
    Occasional Contributor
    7 years ago

    I'm able to succesfully establish the connection through my DBA team.

     

    DBA team grant the access for me to get in through Read

     

    Steps

    Hello All,

    1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear

    2.I'm using the connection string as

    jdbc: oracle:thin:UserName/Password@ServerName:1521:<SID Name>

     

     

  • richie's avatar
    richie
    Community Hero
    7 years ago
    Hi NK12,

    I dont understand what you mean when you say "dba granted access through read".

    Were you trying the wrong useraccount details? Or are you saying you are using a different useraccount with connect/read only access where the useraccount you were using had insert/update/read access, but for some reason it didnt work?

    Can you explain what the actual issue was?

    Cheers

    richie