Solved

Is Oracle 19c support for RAC certified?

  • 12 April 2021
  • 4 replies
  • 496 views
NickPorter
Rank
Userlevel 6
Badge +18

Is Oracle 19c support for RAC officially certified now?

Per the online documentation it still show that 19c RAC is not supported for either Apps9 or Apps10.  Is this correct?  It looks like the page is very out of date.

We are currently running RAC on 12c for both Apps9 and Apps10 and are in the process of migrating to 19c for support reasons.

Can someone either point me to an updated reference or copy/paste into here if it is something I cannot see as a customer?

Thanks!

Nick

icon

Best answer by Kasun Balasooriya 12 April 2021, 18:47

View original
This topic has been closed for comments

4 replies

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

Apps 10

 

Oracle Database

IFS Applications 10 supports both multi-tenant and non-multi-tenant databases. In multi-tenant databases, IFS Applications 10 supports one CDB and PDB. 

IFS recommends using the latest available release update revision of the supported Oracle Database versions.


Oracle 19c

Version IFS Applications Support as of Limitation Solution
Oracle 19c Standard Edition 2 Update 6

Thumbnail generation for media items is not supported up to UPD7.

275500* 274771, 275374 ,276877, 281129
Oracle 19c Enterprise Edition 275500* 274771, 275374, 276877

* Important: The DBCA templates for Oracle 19C is included in Solution ID 275500. Please note the templates must be downloaded separately when using Oracle 19C with IFS Applications 10 UPD6. 

Oracle 12c R2

Version IFS Applications Support as of Limitation Solution
Oracle 12.2.0.1 Standard Edition 2 RTM In Oracle 12.2, non-multitenant databases are deprecated 281129
Oracle 12.2.0.1 Enterprise Edition Oracle error related to complex SQL queries in pluggable databases, LCS Solution 261525

 

Apps9

 

Database Tier

Oracle RDBMS

Important Note: 
(Oracle RDBMS: Only Standard Edition Two, Standard Edition One, Standard Edition and Enterprise Edition are supported)

NOTE that PD supports Oracle versions. Oracle certifies what platform an Oracle version can run on.

Note: Please contact your regional Azure contact person if you have a prospect on Windows Azure.

All available Oracle versions can be found on http://metalink.oracle.com

Version Operating Systems IFS Applications Support as of Limitations Solutions
Oracle 12c     General
  • Windows Server 2012 R2 is supported first from Oracle 12.1.0.2 release, see http://www.oracle.com/technetwork/database/windows/tech-info/sod-oracle-db-win81-win2012r2-2088197.pdf for details.
  • Oracle pluggable databases (PDB) is not supported.
  • IFS PD still recommends configuration using Oracle Manual Shared Memory Management (MSMM) until Automatic Shared Memory Management (ASMM) have been verified.
  • End users cannot change their expired Oracle database password using an IFS Applications client. This functionality was removed in Oracle Database 12c.
  •  Double byte character sets is no longer supported in IFS Applications, instead you should use an Unicode character set.
  • The Gregorian calendar is the only one supported by IFS Applications. The Gregorian calendar must be used in Oracle (and in clients)
  
Oracle 12c

IFS Supported Oracle RDBMS Release

Recommended version for IFS Applications 9 is 12.1.0.2

 All Windows, Unix and Linux flavors supported by Oracle RTM Oracle 12.1.0.2
  • Basic certification tests for IFS Applications 9 have been performed on Oracle 12.1.0.2, both for Standard Edition Two (SE2) and Enterprise Edition (EE) licenses. As per 1st of September Oracle 12.1.0.2 is available for SE2 and EE and can be used for IFS Applications 9. Compared to previous releases Oracle has changed the hardware restrictions to maximum two CPUs (two socket servers) and limited hardware utilization to maximum 16 threads for the SE2 license, so if your hardware and load cope with the SE2 license terms or you have the EE license, Oracle 12.1.0.2 can be used for IFS Applications 9.

Possible LOB Issues when using BASICFILE tablespaces on Windows. Please see LCS Solution 259436

 

Please see IFS Solution 234539, which provides a workaround for an Oracle bug introduced in version 12.1.0.2.0 in the database creation template.

 

241801 Error raised in FNDBAS when upgrading to Enterprise Edition and not running Prepare step and installing IFS Patches or Updates.

 

247656 Performance issue with Optimizer Dynamic Sampling.
Oracle 12c

IFS Supported Oracle RDBMS Release

Recommended version for IFS Applications 9 is 12.1.0.2

 All Windows, Unix and Linux flavors supported by Oracle 12th  of January 2018. Note that IFS is targeting the release on Update 9 but that an installation using Oracle 12.2.0.1 also requires the patches stated under Solutions Oracle 12.2.0.1
  • On Oracle 12.2, debugging using PL/SQL Developer can cause the database to crash unexpectedly. The problem
    seem to arise when PL/SQL Developer tries to update the call stack in the debug session. To workaround
    this problem do the following. Preferences->Debugger-> and uncheck “Update call stack after each step”
    To view the call stack, use the Update Call Stack button in the Test Window. As an alternate solution
    use IFS Developer Studio for debugging. This issue doesn't affect IFS Developer Studio or Oracle SQL
    Developer. Oracle SR 3-16468319461

 

  • Starting from Oracle 12.2, Oracle supports Database Identifiers (View Name, Table Name, Package Names,
    Method Names, etc.) up to 128 characters (128 bytes to be exact). However, IFS Application 9, only
    supports Database Identifiers up to 30 characters. See Solution 256266 for more information

256266 Long Identifiers

256305 Debugging using PL/SQL Developer can possibly crash the database

252260 Required Patches to run IFS Application 9 on Oracle 12.2.0.1

Oracle Database 19c Standard Edition 2


Oracle Database 19c Enterprise Edition

 All Windows, Unix and Linux flavors supported by Oracle IFSAPP9 UPD16   275374,  276877

 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
NickPorter
Rank
Userlevel 6
Badge +18

Thanks @KasunBalasooriya . I appreciate the quick response!

I wish IFS would do a better job of updating publicly available reference docs like this.  These are important details that should be easily available for customersand kept up to date.

Nick

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

Here’s a word doc if the above is not properly formatted. 

1 Attachment
Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
Kasun Balasooriya
Rank
Userlevel 7
Badge +20

Thanks @KasunBalasooriya . I appreciate the quick response!

I wish IFS would do a better job of updating publicly available reference docs like this.  These are important details that should be easily available for customersand kept up to date.

Nick

@KristenGastaldo 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
Terms & ConditionsCookie settings