question

MayH avatar image
MayH asked Spirent_Admin answered

Connecting to Oracle DB w/ the Database Client

So here I am trying to connect to an Oracle 11g service using the built-in Oracle database type ![alt text][1] And when I tried connecting, it keeps on telling me that my username/password is incorrect -- which I know for a fact that they are right. How can I get this to work? [1]: http://forums.spirent.com/storage/attachments/89-1.png
iTestdatabase sessionOracle
1.png (127.1 KiB)
2.png (167.6 KiB)
10 |950
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Spirent_Admin avatar image
Spirent_Admin answered
The DB was exposed as a Named Service rather than by SID iTest automatically generates some JDBC connection strings for the out-of-box supported DB Session types. For Oracle, to hit up the Name Services, the JDBC connection string would be different from that generated by iTest. (Feel free to Google the difference in Oracle JDBC connection strings between SID vs Named Service) So, here's the (proven) solution -- basically use "Custom" database type, and fill in your JDBC connection string. Worked like a charm. ![alt text][1] [1]: http://forums.spirent.com/storage/attachments/90-2.png
10 |950
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.