Question

Upgrade from Oracle 12c to 19c

  • 5 March 2020
  • 6 replies
  • 3306 views

Userlevel 4
Badge +9

Can I find information about upgrading an IFS database from 12c to 19c?

From november 20 2020 we should have upgraded to 19c due end of support from Oracle on 12c.


6 replies

Userlevel 6
Badge +14

I don’t have anything to help you but we’re in the same situation - probably like many folks on here.  I’d be interested to see the same info too.

Thanks in advance!

Nick

Userlevel 5
Badge +10

Same here. It would be nice to have some official comment from IFS on this, other than “contact your IFS consultants”.

Userlevel 6
Badge +15

Hi Mattias,

Currently Oracle 19c is supported for Apps 10 UPD6 and above.

Assuming you are using Apps 10, you first need to request and install UPD6 or above.

You can then use Oracle DBUA tool shipped along with Oracle 19c software to upgrade from 12c to 19c.

Apps 10 RDBMS Supported Platform info

If you are currently not on IFS Apps 10, then you need to contact IFS Support regarding Oracle 19c support timeline.

Userlevel 7
Badge +15

Hi Mattias,

 

What version and release of IFS are you currently running?

We are currently running IFS Application 8 SP1+ but in the middle of upgrading to IFS Application 10.  We currently have Oracle 12c installed but will be migrating to Oracle 19c shortly.  We are lucky because we are only now moving to IFS Application 10 so we’ll just have to reinstall our servers with Oracle 19c the proceed with testing and upgrading as normal.

IFS recommends using the Oracle data pump tool to export and import rather than the Oracle DBUA tool.  The format would be something like the following.

 

Export

expdp <username/password> parfile=E:\app\admin\IFS10PRD\scripts\exp_parfile.par

 

exp_parfile:

DIRECTORY=DATA_PUMP_DIR
DUMPFILE=full_ifs10prd_exp_%U.dmp
FULL=Y
CONTENT=ALL
FILESIZE=8192M
CONSISTENT=Y
LOGFILE=full_ifs10prd_exp.log

 

Import

impdp <username/password> parfile=E:\app\admin\IFS10PRD\scripts\imp_parfile.par

 

imp_parfile:

DIRECTORY=DATA_PUMP_DIR
DUMPFILE=DATA_PUMP_DIR:FULL_IFSDEV_EXP_%U.DMP
FULL=Y
CONTENT=ALL
LOGFILE=full_ifs10prd_imp.log

 

William Klotz
 

Userlevel 6
Badge +15

Hi William.

IFS recommends Datapump utility as part of their Upgrade documentation to upgrade both IFS Applications and Oracle database software as this is included in their Upgrade Deployment guide. 

If clients are considering a standalone DB software upgrade, DBUA is a safe and quicker option. Datapump option can be used too but there will be few manual steps involved to achieve a clean upgrade/migration. 

 DBUA upgrade requires some Oracle DBA background and experience. 

More info: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-A10C2BBB-F884-4BD3-A8EA-3A8E48029E2E

Userlevel 7
Badge +15

Hi Srikanth,

 

Thank you for the explanation.  DBUA would be an easier path to upgrade just the database for us in the future if we need to just upgrade the database.

 

Thank you,

William Klotz

Reply