Migrate to WM and oracle 19c

ello,

We are planning to upgrade from WM9.12 to WM10.5.
In the same time we want to upgrade to oracle19c, which is supported since the 10.3 version.
This migration will be done usign fresh install of servers, IS and DBs.

Is anyone already using this version of oracle (if yes with which WM version) ?
Did you encounter major issues with it ?

Thanks for your contribution
Vincent LAFITTE

Hi Vincent,

what is your current database version?
Oracle 12c I assume?

Your DBA might be able to assist you by copying the current schema to the new database and then run Database Configurator to migrate the schema to the new version.

When using the JDBC Adapter remember to update your ojdbc driver jar to the matching version.

Copy your current IS installation to the new box and install the new instance in a different installation directory.
After that you can run the migration utility to move and upgrade your implementation.

See Upgrade Documentation for further informations.

Regards,
Holger

Hi Vincent,

Just looking on this thread: :grinning:
Yes with ISv9.12/10.3 working fine having loaded with thin driver (ojdbc7.jar) configuration connecting to ORA-19C Rel-1… so far it looks promising though!

HTH,
RMG

1 Like

Hi,

I would prefer updating the ojdbc.jar to a newer version (i.e. ojdbc8.jar from a more recent Release).
Otherwise the Adapter might not be able to use the JDBC 4 specific features.

These drivers are available from Oracle Download section for free download.

The last ojdbc7.jar I am aware is from JDBC Driver 12.1.0.2.
From 12.2.0.1 onwards there is only an ojdbc8.jar available, some newer releases from the 19c releases might also contain an ojdbc10.jar, this might will probably not work with the current wM releases as I didn´t notice that any of them is certified against Java 10 or newer.

Regards,
Holger