Oracle database support 12c 18c 19c patching vs upgrade

To help you plan ahead the Oracle database upgrades and patching, below is an Oracle Database Releases roadmap, showing their lifetime support stages (Premier + Extended) for the latest releases.

Oracle database Release and Support Timelines (MOS Doc ID 742060.1) + Extras

Oracle Support Notes

  • Ensure to maintain Oracle releases that are under Oracle Premium Support  (black bars on the chart) or Extended Support (red bars on the chart)
  • Extended Support is typically for three years following the expiration of Premier Support and only for the Terminal Patch Set release
  • After end of Premium + Extended Support no new patches are released by Oracle + lower SLAs apply for the corresponding database release
  • To receive Extended Support, you must:
    • Continue to pay the support fee for Premier Support 
    • Purchase Extended Support on top of Premier Support fee (unless the fee is waived (usually for the 1st year)
    • Most ULA/PULA contracts include Extended Support fee
    • Enable Extended Support for your Support Identifier (SI) on MOS
Read more »

Oracle PatchSet 11.2.0.4 upgrade issues ORA- PLS-

Below is a list of issues (ORA- and PLS- errors) I encountered after upgrading Oracle 11gR2 Database Enterprise Servers to the latest Patchset 11.2.0.4.
The upgrade mostly done:
– from 11.2.0.3.6-8
– to 11.2.0.4.1 (including Patchset Update PSU 1)
– on platforms: HP-UX Itanium, Linux

ORA-01979: missing or invalid password for role

Problem: Roles with passwords are failing after Oracle database Patchset upgrade

Solution: Recreate a role with a new password or without it.
Example:
alter role REPORTING_RW not identified;

ORA-01791: not a SELECTed expression

Problem: SQL having different number of columns in DISTINCT and ORDER BY clauses failing after Oracle database upgrade but it was working on previous release before last Patchset 11.2.0.4 since developers happily used an Oracle Bug that was fixed in 11.2.0.4. So the correct behavior is on 11.2.0.4 and not on older versions.
SQL> select distinct sal, empno from scott.emp order by deptno;
select distinct sal, empno from scott.emp order by deptno
*
ERROR at line 1:
ORA-01791: not a SELECTed expression

Solution: include all ORDER BY columns into Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email