Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Test connection failed during custom setup with Oracle 11g.

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.

1

0 votes

Comments

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



One answer

Permanent link

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 

2 votes

Comments

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"

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 1,381
× 343

Question asked: Jan 13 '14, 7:22 a.m.

Question was seen: 8,230 times

Last updated: Feb 04 '19, 3:10 p.m.

Confirmation Cancel Confirm