# Daml oracle error

**URL:** <https://forum.canton.network/t/daml-oracle-error/6486>\
**Category:** App Development\
**Tags:** daml, ledger-api, canton\
**Created:** [April 26, 2023, 3:40pm UTC](https://forum.canton.network/t/daml-oracle-error/6486 "2023-04-26T15:40:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![harikrishna\_sri\_ramo](https://yyz2.discourse-cdn.com/flex034/user_avatar/forum.canton.network/harikrishna_sri_ramo/32/5567_2.png) [@harikrishna\_sri\_ramo](https://forum.canton.network/u/harikrishna_sri_ramo)\
**Post date:** [April 26, 2023, 3:40pm UTC](https://forum.canton.network/t/daml-oracle-error/6486/1 "2023-04-26T15:40:49Z")

</div>

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](https://public-api.port/) = xxxx  
[//public-api.address](https://public-api.address/) = xxxx

```haskell
}

```

}

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)

---

<div class="post-metadata">

**Author:** ![Mate\_Varga](https://yyz2.discourse-cdn.com/flex034/user_avatar/forum.canton.network/mate_varga/32/2308_2.png) [@Mate\_Varga](https://forum.canton.network/u/Mate_Varga)\
**Post date:** [May 2, 2023, 8:53am UTC](https://forum.canton.network/t/daml-oracle-error/6486/2 "2023-05-02T08:53:37Z")

</div>

Hi @harikrishna_sri_ramo,

Could you please make sure that you have followed the documentation on setting up [Oracle for persistence](https://docs.daml.com/canton/usermanual/persistence.html#oracle) and confirm that your DD4ODRUN schema was empty when you started up the canton process using this configuration?

Kind Regards,  
Mate

---

<div class="post-metadata">

**Author:** ![harikrishna\_sri\_ramo](https://yyz2.discourse-cdn.com/flex034/user_avatar/forum.canton.network/harikrishna_sri_ramo/32/5567_2.png) [@harikrishna\_sri\_ramo](https://forum.canton.network/u/harikrishna_sri_ramo)\
**Post date:** [May 3, 2023, 5:17am UTC](https://forum.canton.network/t/daml-oracle-error/6486/3 "2023-05-03T05:17:22Z")

</div>

Hi Mate,

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

Regards  
Harikrishna