Unable to configure oracle database

When I set this oracle config and try to run the Camunda it stopped and I’m unable to read the errors.

How to enable the server log and see the all errors?
Also, help me to configure the Oracle DB for the log

Hello @naveenk ,

have you added the oracle jdbc driver to the configuration/userlib folder?

By default, the h2 driver is contained in the distro.

Jonathan

Thanks for the reply,

Yes, I have placed that file. Is that the correct JDBC driver?

Hello @naveenk ,

should be. It would be very helpful to get the logs.

Why do you not have any logs? If you run it from cmd, there should be a log.

Jonathan

I’m new to the Camunda, and not sure where to check. When I start the Camunda command prompt it closes after showing this error. Is there anywhere I see the logs in the text file?

Hello @naveenk ,

this is actually very helpful. This error states that you cannot reach the host.

Can you verify that you can reach the database with the given address from the machine Camunda Run should be running on?

For your current evaluation, is it relevant that you connect to the oracle database?

If not, you could configure a file-based h2 connection for testing purposes and resolve the oracle db configuration issue in the meantime.

Jonathan

I was able to connect the oracle database from that machine,

Below is the configuration from the Oracle SQL developer

Can you review the config again which is in default.yml file?

spring.datasource:
url: jdbc:oracle:thin:@ivf*****.dbdeet.vc.or*****.com:1521:xe
driver-class-name: oracle.jdbc.OracleDriver
username: ivfr
password: 1Om*******h&

Hello @naveenk ,

I found an article about configuring oracle jdbc:

Maybe you could follow it and especially have a look at the connection url.

Jonathan

Hi Naveen,Kindly configure your logging using the following in default.yml file (configuration folder).

1 Like

Put the Hostname instead of the Service Name into the database url !

1 Like