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 18201352: ORA-7445 [QERTBSTART()+3105] CRASHES QUERY WITH DISTINCT AND PJE TRANSFORMATION

- Download Patch 18201352 (p18201352_121020_Linux-x86-64.zip)

- Ensure Oracle home has Oracle Database 12.1.0.2.0 installed

- Set environment variables, ensure latest opatch version available for 12c release is used, 

- Unzip the patch

$ unzip p18201352_121020_Linux-x86-64.zip

- Check for patch conflicts

$ cd 18201352

$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./


Applying Patch 18201352 (Offline Patching)

- Shutdown all services (for offline patching)

- Run opatch apply

$ cd 18201352

$ opatch apply

- Verify patch

$ opatch lsinventory |grep 18201352

- Restart all services

Patch rollback steps (Offline)

If any issues after applying the patch and rollback is required, follow below steps:

- Stop all services

- Run opatch rollback

$ opatch rollback -id 18201352


- Restart all services

Related Posts

Oracle 12.1.0.2.0 - Applying Patch 20228093: MATERIALIZED VIEW DEFERRED MODE ORA-00918: COLUMN AMBIGUOUSLY DEFINED