Unable to connect to oracle database

Question

Hi,
I have created a new test step for jdbc request. I am using&nbsp;oracle.jdbc.driver.OracleDriver for Driver. And the connection string as&nbsp;jdbc:oracle:thin:username/passwd@localhost:1521:sid. All the values I am using in the connection string are being used in the sqldeveloper connections and work just as fine. I had ojdbc7.jar earlier and I was facing the error
"Can't get the Connection for specified properties; java.sql.SQLException: ORA-01017: invalid username/password; logon denied"
I then have downloaded oracle driver ojdbc8.jar and tried, but met with the same error.&nbsp;
I have already copied the jar file to both bin\ext as well as lib folder. Yet the above result.
&nbsp;
Can you please suggest a fix
&nbsp;
Thanks,

richie · Accepted Answer

Hi&nbsp;damodharv&nbsp;
&nbsp;
The error response you're getting would appear to indicate that the driver files are fine - you'd get a could not initialise connection response if the driver files were incorrect I'd imagine - initialising the connection is done before the authentication is attempted - which is what your error response appears to indicate a problem with.
&nbsp;
the .jar driver files are only required in the&nbsp;C:\Program Files\SmartBear\ReadyAPI-2.7.0\bin\ext, not the lib directory
your connection string the host you have is 'localhost' - so you must have Oracle installed on your machine.&nbsp; You say that SQL Developer is using the same parm values - but is it using the tnsnames.ora file for the connection or is it using the oracle jdbc thin driver?&nbsp; I'd double check - cos the connection string should be pretty similar in both ReadyAPI! as SQL Developer.
&nbsp;
Have you confirmed the .jar driver file is the correct version relative to your JDK/JRE installed and your JRE is correct relative to your Oracle version? (i.e. check which version of Oracle you are connecting to, google which version of Java is required to connect, then google the driver file version required to talk to the JDK/JRE installed).
&nbsp;
I believe the connection string that is required has altered depending on the version of Oracle you are trying to connect to.
&nbsp;
If the driver file and Java version is correct to connect to the RDBMS, and the files are in the correct directory (and you haven't got 2 instances of ReadyAPI! installed - i.e. one in Program Files and one in Program Files (x86) directory), then the connection string is likely the issue.
&nbsp;
Is your database definitely a single instance (using an SID) rather than a cluster (using a Service Name)?&nbsp; The connection string is different if connecting to Service Name rather than SID - the port number/Service Name separate is a / rather than a :
&nbsp;
so instead of&nbsp;
jdbc: oracle:thin:username/passwd@localhost:1521:sid 
it was
jdbc: oracle:thin:username/passwd@localhost:1521/service name
You may have to create a new instance of the jdbc thin driver connection string in your Preferences, rather than use the default oracle driver 'OracleThin/oracle.jdbc.driver.OracleDriver'. I've noticed occasionally that ReadyAPI! works when the connection string is slightly different to the one specified and I've had to create a new one (despite the fact there was already one setup by default)
&nbsp;
you've specified the connection string your using as follows:
&nbsp;
jdbc:oracle:thin:username/passwd@localhost:1521:sid - right?
Its been awhile since I connected to Oracle in SoapUI - but for a MIMER RDBMS connection the string was defined as follows:
&nbsp;
jdbc:mimer://&lt;USER&gt;:&lt;PASSWORD&gt;@&lt;HOST&gt;:&lt;PORT:1360&gt;/DB
and so the only way it worked was to include the word 'PORT' adjacent to the relevant port number - e.g. - my connection string for the database was as follows:
&nbsp;
jdbc:mimer://RICHARD:PASSWORD01@127.0.0.1:PORT:1360/WHATEVS
&nbsp;
I've seen various examples of the Oracle connection string required depending on the Oracle version.
&nbsp;
well - the syntax for the connection string is as follows:
&nbsp;
jdbc:oracle:thin:&lt;USER&gt;/&lt;PASSWORD&gt;@&lt;HOST:127.0.0.1&gt;:&lt;PORT:1521&gt;:&lt;SID&gt;
jdbc:oracle:thin:&lt;USER&gt;/&lt;PASSWORD&gt;@//&lt;HOST:127.0.0.1&gt;:&lt;PORT:1521&gt;/&lt;SID&gt;
jdbc:oracle:thin:&lt;USER&gt;/&lt;PASSWORD&gt;@//&lt;HOST:127.0.0.1&gt;:&lt;PORT:1521&gt;:&lt;SID&gt;
or you could try rather than the Oracle thin driver, but adding in the rdbthin driver with syntax as follows:
jdbc:rdbThin://servername:port/dbname","username","password"
Apologies - there's a lot of detail above - but what I'm trying to emphasise is that if you've got all your driver versions, java etc. lined up, your .jar files in the correct directory then its likely considering all the problems people have with this (there are lots of posts about this) that it's likely to be the connection string - so you might need to create a new one in your preferences and play with the pattern/format until it works.
&nbsp;
This is exactly what I had to do a couple of years ago to get my connection working.
&nbsp;
Cheers,
&nbsp;
richie
&nbsp;

Forum Discussion

Unable to connect to oracle database

2 Replies

Recent Discussions

RunTestCase input and return proeprties of the same name

Import API Definition in Ready API

Help needed with importing an API via a URL that requires a certificate for authentication.

Related Content

Unable to connect database in ready api

Unable to connect to Oracle database with service name (no SID)

Unable to Connect to Database