Oracle 12.2 & Alfresco Content Services 5.2.2

[ivanovpavel1983]

Hello.

When we are stopping the application with "./alfresco.sh stop" command, we have an error:

The parameters is:

db.driver=oracle.jdbc.OracleDriver
db.url=jdbcracle:thin:@//srv-alfdb01.isb:1521/ALFEKKA
db.pool.max=375
db.pool.min=20
db.pool.statements.max=300
db.pool.validate.query=select 1 from dual

JDBC Driver is : ojdbc8.jar

JAVA Oracle 1.8 Update 161

DB Oracle + DATABASE RELEASE UPDATE 12.2.0.1.180116

With the jdcb7 driver, the application does not start at all...

[afaust]

The error during stopping of the Alfresco server is just an unlucky timing of an asynchronous thread trying to run a job when the DB connection has / is already (been) shut down.

As for Alfresco not starting up, it is hard to tell without any logs. One of my customer is running Alfresco 5.2.1 with Oracle 12.1 and jdbc7 driver JAR without any hiccups.

[cesarista]

In fact Ojdbc7.jar is the "supported" driver for Oracle 12:

Supported Platforms | Alfresco Documentation 

Regards.

--C.

[ivanovpavel1983]

When we try to use ojdbc7.jar, we have errors:

[afaust]

That error likely does not have antyhing to do with the DB driver. This is an issue where apparently someone tried to persist objects in Tomcat sessions that cannot be stored. Alfresco itself does not try to store such data in the session, so there must be a 3rd-party extension / customisation at play...