Tarun Chopra

Thanks much Tomas. I was able to get fresh DB going and it worked for Oracle. Quite possible it could be the way I was accessing DB. I may go towards MySQL to get this going given that Oracle may have issues going forward. Question: Does following look like good plan for Oracle to MySQL switch or am I missing it big time 1) Shutdown Existing App server 2) Export Oracle into dump file 3) Build new environment with fresh MySQL DB connection 4) Shutdown new App Server 5) Import Oracle dump into MySQL...

Hey Tomas I double checked and DB looks good. Infact, using same credentials and SQL provided with in EJBCA (create-tables-ejbca-oracle.sql) I was able to create whole schema with no error. Would appreciate if you could share more sign on a) datasource using Oracle driver, exact syntax b) standard.xml update for oracle driver c) database.properties for database.driver Is there a place where I can look for Docker image using Oracle? BTW, can we use docker with external Oracle Database? that would...

Thx Tomas again! I am making progress in troubleshooting but still no luck. So, I was able to drop all tables, clean recycle bin. Tried again, and still gives Ora error of either table does not exist. I dropped again, picked up Schema creating SQL from how-to and created DB from fresh. It did pass the DB errors but it ended up doing another error - 10.180.151.234 16:18:42,157 ERROR [org.jboss.as.controller.management-operation] (DeploymentScanner-threads - 2) JBAS014612: Operation ("deploy") failed...

Appreciate you looking into this, please review and give me further pointers: here is server.log from another attempt. worked with Database person and he confirmed there are no locks, cleard/dropped all tables and elevated access to highest level for the Schema updated/sym linked driver to ojdbc7.jar, it shows driver 12.1 version now vs old 11.1 now) don't see 39 tables that used to create earlier. it only creates 11 tables. i do see Ora error this time but thats just saying cannot create table.

Appreciate you looking into this, please review and give me further pointers: here is server.log from another attempt. worked with Database person and he confirmed there are no locks, cleard/dropped all tables and elevated access to highest level for the Schema updated/sym linked driver to ojdbc7.jar, it shows driver 12.1 version now vs old 11.1 now) don't see 39 tables that used to create earlier. it only creates 11 tables. i do see Ora error this time but thats just saying cannot create table.

Thanks much to look into this Tomas here is server.log. i changed DB to SERVER_FQDN will post more information later as well as i am trying to try few things.

Appreciate you looking into this, please review and give me further pointers: here is server.log from another attempt. worked with Database person and he confirmed there are no locks, cleard/dropped all tables and elevated access to highest level for the Schema updated/sym linked driver to ojdbc7.jar, it shows driver 12.1 version now vs old 11.1 now) don't see 39 tables that used to create earlier. it only creates 11 tables. i do see Ora error this time but thats just saying cannot create table....

thx how is the configuration in standard.xml for driver? the issue is that it driver works but app server dies so it is some optimization that is required in app to DB channel On Mon, Sep 21, 2020, 22:25 Tomas Gustavsson anatom@users.sourceforge.net wrote: The most/only important is "database.name=oracle". Oracle is a very common database used in production environments, so it is certain that it works. EJBCA giving error for ant deploy or install https://sourceforge.net/p/ejbca/discussion/123123/thread/f7cbf035cf/?limit=50#0e23...