Oracle Grid 11.2.0.4 upgrade to 19c
Upgrading Oracle Grid Infrastructure and Oracle Database to version 19c offers several benefits:
- Enhanced Performance: Oracle Database 19c introduces numerous performance enhancements, including automatic indexing, real-time statistics, and improved memory management. These improvements can lead to faster query execution and overall system performance.
- Improved Security: Oracle Database 19c includes advanced security features such as Data Redaction, Unified Auditing, and Privilege Analysis. These features help protect sensitive data and strengthen overall system security.
- Long-Term Support: Oracle 19c is a long-term support release, which means it will receive regular updates, bug fixes, and security patches for an extended period. By upgrading to 19c, you ensure that your system remains supported and can take advantage of future enhancements.
- Simplified Management: Oracle 19c introduces several management features to simplify administration tasks. For example, Automatic Indexing and Automatic SQL Plan Management help optimize query performance without manual intervention. Additionally, the Database Configuration Assistant (DBCA) provides an improved graphical interface for creating and managing databases.
- Oracle Multitenant: Oracle 19c offers enhanced features and improvements to Oracle Multitenant, which allows you to consolidate multiple databases into a single container database. This feature provides better resource utilization, simplified management, and improved scalability.
- Integration with Oracle Cloud: Oracle 19c is tightly integrated with Oracle Cloud services, enabling seamless migration of on-premises databases to the cloud. This integration offers benefits such as simplified data management, elastic scalability, and access to additional cloud-based features.
These are just a few of the reasons why upgrading to Oracle Grid Infrastructure and Oracle Database 19c can be beneficial. However, it’s important to thoroughly assess your specific requirements and consult Oracle’s official documentation and support resources before proceeding with the upgrade.
You cannot upgrade Oracle Grid from version 11.2.0.4 to directly 19c. you need to upgrade grid from 11.2.0.4 to 12.1.0.2 or 12.2.0.1 first.
However, 11.2.0.4 database can be directly upgraded to 19c, you need to apply patches first.
Grid Infrastructure Upgrade to 19c
Required patches in the target Grid Infrastructure Home:
| From Release | Fix required in target GI home | Description | Additional comments |
| 18c | none | ||
| 12.2.0.1 | none | ||
| 12.1.0.2 | 30272995 | PRE UPGRADE CLUVFY FAILS TO DETECT PATCHES APPLIED IN ENV | Required for upgrades to 19.8.0.0.0.200714 and 19.9.0.0.0.201020 |
Required patches in the source Grid Infrastructure Home:
| From Release | Fix required in source GI home | Description | Additional comments |
| 18c | none | ||
| 12.2.0.1 | none | ||
| 12.1.0.2 | 21255373 | CSSD : DUPLICATE RESPONSE IN GROUP DATA UPDATE | Fix included in 12.1.0.2.190115 |
Database Upgrade to 19c
| From Release | Fix required in source DB home | Fix required in target DB home | Fix required in GI home | Description | Additional comments |
| 18c | 28553832 | LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY | |||
| 29213893 | DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE | Only required if the following querry returns multiple rows (select count(*) from obj$ where name=’USER$’;) | |||
| 12.2.0.1 | 28553832 | LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY | |||
| 29213893 | DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE | Only required if the following querry returns multiple rows (select count(*) from obj$ where name=’USER$’;) | |||
| 12.1.0.2 | 21255373 | CSSD : DUPLICATE RESPONSE IN GROUP DATA UPDATE | Fix included in 12.1.0.2.190115 | ||
| 28553832 | LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY | ||||
| 29213893 | |||||
| 11.2.0.4 | 31561819 | INCOMPATIBLE MAXMEMBERS AT CSSD LEVEL CAUSING DATABASE INSTANCE NOT ABLE TO START | Fix included in GI 19.9.0.0.0 | ||
| 29213893 | LNX-191-EXA:CSSD PROCESS CANNOT GET REAL-TIME PRIORITY | Only required if the following querry returns multiple rows (select count(*) from obj$ where name=’USER$’;) |
Managing older database with 19c Grid Infrastructure:
| With Release | Fix required in source DB home | Description | Additional comments |
| 18c DB | None | ||
| 12.2.0.1 DB | None | ||
| 12.1.0.2 DB | none | ||
| 11.2.0.4 DB | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Fix included in 11.2.0.4.190416 |
Doc Id : 2542082.1
Harshad Vengurlekar
Experienced OCM-certified Oracle Database Administrator with over 18 years of expertise in designing, implementing, and managing complex database solutions. My expertise spans performance optimization, security, and high-stakes solution implementation. Adept at managing complex environments with precision.
No Comments