Error when trying to use Oracle RAC
« Back
Tags:
Question ID: 104469
▲
3
▼
♥ 0

User is receiving this error during installation of ALMv11. The error also occurs when adding a additional entry in the DB Server tab.

Error

Failed to Test Connection;
Test connection failed;
No suitable driver found for jdbc:hp:oracle:TNSNamesFile=C:\\app\\Administrator\\product\\11.2.0\\client_1\\network\\admin\\tnsnames.ora;TNSServerName=Oracle10g;

Items Verified

Oracle tnsnames.ora is correct.
Can tnsping Oracle database.
Can connect using JDBC Connectin Tool from HP Knowledgebase article KM194278.
Connection String is formatted as outlined in the installation guide.
jdbc:HP:oracle:TNSNamesFile=\\tnsnames.ora;TNSServerName=OrgRAC

Marked as spam
Posted by (Questions: 5, Answers: 1)
Asked on February 28, 2012 1:07 pm
71 views
Answers (1)
▲
3
▼
✔
Private answer

Solution

Installation Guide connection string example. is incorrect.
Do not use hp in the string. Instead use mercury. (See example below)
Correct Syntax:
jdbc:mercury:oracle:TNSNamesFile=C:appAdministratorproduct11.2.0client_1networkadmintnsnames.ora;TNSServerName=Oracle10g

Incorrect Syntax:
jdbc:hp:oracle:TNSNamesFile=C:appAdministratorproduct11.2.0client_1networkadmintnsnames.ora;TNSServerName=Oracle10g

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on February 28, 2012 1:09 pm
▲
0
▼
That worked! I will be opening a case with HP for this one to update in the guide.
( at February 28, 2012 1:12 pm)
« Back
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Got it!
X
Scroll to Top