It's all about the answers!

Ask a question

Test connection failed during custom setup with Oracle 11g.

Don Max (241531) | asked Jan 13 '14, 7:22 a.m.
retagged Feb 04 '19, 3:10 p.m. by Michael Afshar (7014)

Getting the below error while configuring Oracle database connection properties in Jazz custom setup page.

The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 99999, SQLCODE: 17067). Verify the connection settings in your teamserver.prop

<wbr> erties file. See the Jazz Team Server log for more information.ID CRJAZ2654E

Able to login to the database using https://localhost:1158/em ... 

some suggestions please.

Krzysztof Kaźmierczyk commented Jan 13 '14, 8:23 a.m.

Hi Joe,
Could you please provide your database settings from or from the page where you have error message?

One answer

permanent link
Paul Ellis (1.3k613) | answered Jan 15 '14, 6:58 a.m.

Hi Joe,

As you're using localhost for your em URL, I assume that you have Oracle on the same machine as CLM?

In that case you need to ensure that each one of these are correct:


jazzDBUser = the user you defined in your CREATE USER <name>

{password} = will have been entered in the password field above, but is the IDENTIFIED BY string from the same create users line


For the other parts of this string, then these settings need to match your Oracle tnsnames.ora file: = try using the FQDN as in this example rather than localhost, but HOST in the tnsnames.ora entry

1521/ORCL = these correspond to the PORT and SERVICE_NAME in the tnsnames.ora file.

If you verify these settings and are still encountering a problem, then please see Krzys' comment so we can troubleshoot further.

Kind regards,


Bob 3 commented Jan 31 '19, 12:18 p.m.

When configuring an Oracle database connection, does anything need to be manually updated in the file, or will the JTS custom setup wizard do everything?

There is no mention of updating in the interactive CLM installation workflow, however I am having the same connection error as the original post: Verify the connection settings in your file. The error goes on to cite SQL error 17067, which resolves to "Invalid Oracle URL specified"

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.