When upgrading Jira to a newer version, I am not sure if the new Oracle JDBC driver 12.2.0.1 works with our Oracle server release 12.1.0.2.
So by asking Google, I found it is. Here is the interoperability support matrix:
References:
https://blogs.oracle.com/upgrade/client-certification-for-oracle-database-1210212201
https://blogs.oracle.com/upgrade/oracle-database-122-lifetime-support-policy-updated