Oracle 12.1.0.2.0 - Applying Patch 20228093: MATERIALIZED VIEW DEFERRED MODE ORA-00918: COLUMN AMBIGUOUSLY DEFINED
- Download Patch 20228093 (p20228093_121020_Linux-x86-64.zip)
- Ensure environment variables are set, latest opatch version is used 12.1.0.1.4 or higher and Oracle home has Database 12.1.0.2.0 installed.
- Unzip the patch
$ unzip p20228093_121020_Linux-x86-64.zip
- Check for conflicts
$ cd 20228093
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Applying Patch 20228093
- Shutdown all services
- Run opatch apply
$ cd 20228093
$ opatch apply
- Verify patch applied
$ opatch lsinventory |grep 20228093
- Start all services
Patch rollback steps
If any issues after applying the patch and rollback is required, follow below steps
- Stop all services
- Run opatch rollback
$ opatch rollback -id 20228093
- Restart all services
Related Posts
Oracle 12.1.0.2.0 - Applying Patch 18201352: ORA-7445 [QERTBSTART()+3105] CRASHES QUERY WITH DISTINCT AND PJE TRANSFORMATION
Oracle 12.1.0.2.0 - Applying Patch 21948354: DATABASE PATCH SET UPDATE 12.1.0.2.160119 (INCLUDES CPUJAN2016)
Oracle 12.1.0.2.0 - Applying Patch 22139226: OJVM PATCH SET UPDATE 12.1.0.2.160119
No comments:
Post a Comment