Skip to main content
November 7, 2022
Question

Migrating Oracle Database from 12g to 19c

  • November 7, 2022
  • 3 replies
  • 0 views

Hi,

I am currently using Appian 22.1.875 on Linux servers. Presently, my applications are using Oracle12, but now my DBA team is planning to migrate to 19c. Will there be any issues after the upgradation of DB to 19c? Has anyone tried this? Was there any impact on the existing applications in Production environment because of this migration?

Please help.

Regards,

Chetana

3 replies

csteward
November 7, 2022

We have a few applications that utilize an external Oracle database (not our primary business data source) which was recently upgraded to 19c and we did not have any issues.  Typically unless the database structure is changing (which does not occur during these upgrades), my only concern would be the JDBC drivers, which are listed as the same for Oracle 11g through 19c.

Is there no test instance this will be performed on first?  That is typically the best way to verify, however I would not be concerned.

November 9, 2022

Hi Chris, thank you for your response. Glad to hear that it did not impact your Appian components, anything specific would you recommend looking for, once the migration is done?

Regards,

Chetana

November 9, 2022

Can anyone else suggest if they have used as Primary datasource? Our aplication has Oracle as Primary Datasource.