Daml oracle error

Questions
, ,
1

Hi ,

I am trying to start canton with oracle persistence storage but getting till error after multiple tries , my schema is empty ., below is my conf file and error I am facing.

domain-managers {
DomainName {
storage {
type = oracle
config {
driver = “oracle.jdbc.OracleDriver”
url = “jdbc:oracle:thin:@”${ORACLE_HOST}“:”${ORACLE_PORT}/${ORACLE_DB}
password = “xxxx”
user = “DD4ODRUN”
}
}
admin-api.address = xxxx
admin-api.port = xxxx
//public-api.port = xxxx
//public-api.address = xxxx

}

}

participants {
Participant1{
storage{
type =oracle
config {
driver = “oracle.jdbc.OracleDriver”
url = “jdbc:oracle:thin:@”${ORACLE_HOST}“:”${ORACLE_PORT}/${ORACLE_DB}
password =“xxxx”
user = “DD4OPRUN”
}

ledger-api-jdbc-url = “jdbc:oracle:thin:DD4OPLEDG/xxxx@”${ORACLE_HOST}“:”${ORACLE_PORT}/${ORACLE_DB}}
admin-api {
port = xxxx
address = “xxxx”
}
ledger-api {
port = xxxx
address = “xxxx”
}
}
\

WARN c.d.c.r.EnterpriseDbMigrations:BoFADomain tid:cf0767182ec52a6bdc805b6b4a1a2f7a - Operation com.digitalasset.canton.resource.DbMigrations.migrateDatabaseInternal failed, exhausted retries: FlywayError(
org.flywaydb.core.api.FlywayException: Found non-empty schema(s) “DD4ODRUN” but no schema history table. Use baseline() or set baselineOnMigrate to true to initialize the schema history table.
at org.flywaydb.core.Flyway$1.execute(Flyway.java:154)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:124)
at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:214)
at org.flywaydb.core.Flyway.migrate(Flyway.java:124)

2

Hi @harikrishna_sri_ramo,

Could you please make sure that you have followed the documentation on setting up Oracle for persistence and confirm that your DD4ODRUN schema was empty when you started up the canton process using this configuration?

Kind Regards,
Mate

3

Hi Mate,

We followed the same process in the documentation.
yes the schema is empty.

Regards
Harikrishna