Hi, According to Flyway documentation they support Oracle 12.2, 18.3 and 19.3. https://flywaydb.org/documentation/database/oracle
Again though, I would stress that if this is a new installation, I'd recommend using PostgreSQL instead of Oracle, because DSpace doesn't plan to support Oracle much longer: https://github.com/DSpace/DSpace/issues/8214 (In mid 2023, we plan to remove all Oracle specific code from DSpace which means you will be locked into the last version of DSpace which had Oracle specific code.) Tim On Wednesday, June 15, 2022 at 1:01:15 PM UTC-5 [email protected] wrote: > Tim, thank you very much for the reply. Our company also has Oracle 19c. > Do you know if Flyway is compatible with Oracle 19c? > > Em quarta-feira, 15 de junho de 2022 às 12:12:19 UTC-3, Tim Donohue > escreveu: > >> Hi, >> >> It looks like one of those log lines gives you the answer... see this >> message: >> >> "*Flyway Enterprise Edition or Oracle upgrade required: Oracle 12.1 is >> no longer supported by Flyway Community Edition, but still supported by >> Flyway Enterprise Edition.'"* >> >> It sounds like Flyway Community Edition (which DSpace 7 relies on) no >> longer supports Oracle 12.1. So, you'd have to upgrade Oracle. >> >> Please keep in mind we are dropping support for Oracle as of Summer 2023. >> So if this is a new install, I'd **high recommend** using PostgreSQL >> instead. See this announcement: >> https://github.com/DSpace/DSpace/issues/8214 >> >> Tim >> >> On Tuesday, June 14, 2022 at 3:59:07 PM UTC-5 [email protected] wrote: >> >>> Another part of the log in debug mode: >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> *[java] 2022-06-14 17:06:59,609 DEBUG org.flywaydb.core.Flyway @ Memory >>> usage: 66 of 146M [java] 2022-06-14 17:06:59,609 INFO >>> org.dspace.storage.rdbms.FlywayUpgradeUtils @ Flyway table >>> 'schema_version' appears to be outdated. Will attempt to upgrade it >>> automatically. Flyway Exception was >>> 'org.flywaydb.core.internal.license.FlywayEditionUpgradeRequiredException: >>> Flyway Enterprise Edition or Oracle upgrade required: Oracle 12.1 is no >>> longer supported by Flyway Community Edition, but still supported by Flyway >>> Enterprise Edition.' [java] 2022-06-14 17:06:59,611 DEBUG >>> org.apache.http.impl.conn.PoolingHttpClientConnectionManager @ Closing >>> expired connections [java] 2022-06-14 17:06:59,612 DEBUG >>> org.apache.http.impl.conn.PoolingHttpClientConnectionManager @ Closing >>> connections idle longer than 30 SECONDS [java] 2022-06-14 17:06:59,620 >>> DEBUG org.springframework.context.support.ClassPathXmlApplicationContext @ >>> Closing >>> org.springframework.context.support.ClassPathXmlApplicationContext@3ffb3598, >>> >>> started on Tue Jun 14 17:06:56 BRT 2022 [java] 2022-06-14 17:06:59,644 >>> INFO org.dspace.services.caching.CachingServiceImpl @ destroy() [java] >>> 2022-06-14 17:06:59,646 INFO >>> org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting >>> down EhCache CacheManager 'org.dspace.services' [java] 2022-06-14 >>> 17:06:59,646 DEBUG net.sf.ehcache.CacheManager @ CacheManager already >>> shutdown [java] 2022-06-14 17:06:59,646 INFO >>> org.dspace.services.sessions.StatelessRequestServiceImpl @ shutdown >>> [java] 2022-06-14 17:06:59,647 DEBUG >>> org.dspace.services.caching.CachingServiceImpl @ instantiateMapCache(String >>> eventQueueCache) [java] 2022-06-14 17:06:59,647 WARN >>> org.dspace.services.sessions.StatelessRequestServiceImpl @ Request >>> interceptor >>> (org.dspace.services.events.SystemEventService$EventRequestInterceptor@6b01558a) >>> >>> failed to execute on end (request-440-1655237218986): Cannot invoke >>> "org.dspace.services.model.Cache.getKeys()" because "queueCache" is null >>> [java] 2022-06-14 17:06:59,651 INFO >>> org.dspace.servicemanager.DSpaceServiceManager @ DSpace service manager is >>> shut down. [java] 2022-06-14 17:06:59,651 INFO >>> org.dspace.servicemanager.DSpaceKernelImpl @ DSpace kernel shutdown >>> completed and unregistered MBean: >>> org.dspace:name=2daf4d2d-028f-4a30-a681-8febdbc98984,type=DSpaceKernel* >>> >>> Em quarta-feira, 8 de junho de 2022 às 18:59:08 UTC-3, Aroldo Rique >>> escreveu: >>> >>>> Hello everybody. >>>> >>>> I'm trying to install *dspace 7.2* with Oracle client on another >>>> machine. When I run the command >>>> dspace@dspace/data/dspace-src-backend/dspace/target/dspace-installer> ant >>>> fresh_install, the following *database error* occurs: >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> *Buildfile: >>>> /data/dspace-src-backend/dspace/target/dspace-installer/build.xmlinit_installation:prepare_configs: >>>> >>>> [mkdir] Created dir: >>>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temp >>>> [copy] Copying 193 files to >>>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temp >>>> [copy] Copying 1 file to >>>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temp >>>> [copy] Copying 14 files to >>>> /data/dspace-src-backend/dspace/target/dspace-installer/config-tempinit_configs: >>>> >>>> [copy] Copying 1 file to /dspace/config [delete] Deleting directory >>>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temptest_database: >>>> >>>> [java] 2022-06-08 18:44:49,681 WARN >>>> org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by >>>> name or id=database. Will try to look up bean by type next. [java] >>>> org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean >>>> named 'database' available [java] at >>>> org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:816) >>>> >>>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>>> org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1288) >>>> >>>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) >>>> >>>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) >>>> >>>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>>> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1115) >>>> >>>> ~[spring-context-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>>> org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) >>>> >>>> [dspace-services-7.2.1.jar:7.2.1] [java] at >>>> org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) >>>> >>>> [dspace-api-7.2.1.jar:7.2.1] [java] at >>>> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) >>>> >>>> [dspace-api-7.2.1.jar:7.2.1] [java] at >>>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >>>> [dspace-api-7.2.1.jar:7.2.1] [java] Caught exception: [java] >>>> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist >>>> [java] [java] at >>>> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) [java] >>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) >>>> [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) >>>> >>>> [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) >>>> [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) >>>> [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) >>>> [java] at >>>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) >>>> >>>> [java] at >>>> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) >>>> >>>> [java] at >>>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) >>>> >>>> [java] at >>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) >>>> >>>> [java] at >>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) >>>> >>>> [java] at >>>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) >>>> >>>> [java] at >>>> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) >>>> >>>> [java] at >>>> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) >>>> >>>> [java] at >>>> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) >>>> >>>> [java] at >>>> org.dspace.storage.rdbms.DatabaseUtils.getCurrentFlywayState(DatabaseUtils.java:1414) >>>> >>>> [java] at >>>> org.dspace.storage.rdbms.FlywayUpgradeUtils.upgradeFlywayTable(FlywayUpgradeUtils.java:83) >>>> >>>> [java] at >>>> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:112) >>>> [java] at >>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native >>>> Method) [java] at >>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) >>>> >>>> [java] at >>>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>> >>>> [java] at >>>> java.base/java.lang.reflect.Method.invoke(Method.java:568) [java] >>>> at >>>> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) >>>> >>>> [java] at >>>> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) >>>> >>>> [java] at >>>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >>>> [java] 2022-06-08 18:44:50,182 WARN >>>> org.dspace.services.sessions.StatelessRequestServiceImpl @ Request >>>> interceptor >>>> (org.dspace.services.events.SystemEventService$EventRequestInterceptor@22848820) >>>> >>>> failed to execute on end (request-16-1654724689695): Cannot invoke >>>> "org.dspace.services.model.Cache.getKeys()" because "queueCache" is >>>> nullBUILD >>>> FAILED/data/dspace-src-backend/dspace/target/dspace-installer/build.xml:770: >>>> >>>> Java returned: 1* >>>> >>>> Has anyone had this problem and managed to solve it? Thanks in advance >>>> for any help. >>>> >>>> Aroldo Rique >>>> Recife/Brasil >>>> >>> -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/9561d0f2-a6d6-4524-94fd-8dffd687d2c3n%40googlegroups.com.
