Test connection failed during custom setup with Oracle 11g.

Don Max (24●12●28) | asked Jan 13 '14, 7:22 a.m.
retagged Feb 04 '19, 3:10 p.m. by Michael Afshar (701●4)

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.

Comments

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

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

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Paul Ellis (1.3k●6●13) | answered Jan 15 '14, 6:58 a.m.
JAZZ DEVELOPER

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:

thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL

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

See: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html

For the other parts of this string, then these settings need to match your Oracle tnsnames.ora file:

oracleserver.example.com = 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,

Paul

Comments

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 teamserver.properties file, or will the JTS custom setup wizard do everything?

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

It's all about the answers!

Related questions

Test connection failed during custom setup with Oracle 11g.

One answer

Your answer