Oracle - the database is Not Available in CSA on a new install
search cancel

Oracle - the database is Not Available in CSA on a new install


Article ID: 140657


Updated On:


Clarity PPM On Premise


On a brand new environment, the Oracle Database has been set up. The server information has been entered into the CSA application, but it cannot find the database, it states Not Available. How to troubleshoot this further? Does Oracle need a listener on the Clarity server or on Oracle database? 


Release : All applicable Clarity versions


Our application does not install anything on the Oracle server. There is no listener on our side, we simply use an installed and configured Oracle schema with a working TNS listener.

To understand the problem, proceed as follows:

0. Verify you followed all the steps in the documentation (below)

1. Ensure you are able to connect to the Oracle database with SQL developer/SQL plus

2. If this works, ping the Oracle database server from the Clarity server

3. If this works, install SQL plus or SQL developer on the Clarity server and attempt connecting.

4. One other thing you can do is use the IP instead of the database servername in CSA to eliminate any DNS issue


Clarity Oracle database configuration technical documentation