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

Oracle 12.1.0.2.0 - Applying Patch 21260431: GETTING ORA-4031 AFTER 12C UPGRADE

Oracle 12.1.0.2.0 - Applying Patch 21260431: GETTING ORA-4031 AFTER 12C UPGRADE

- Download Patch 21260431 (p21260431_121020_Linux-x86-64.zip)

- Ensure that Oracle home is Oracle Database 12c Release 12.1.0.2.0

Applying Patch 21260431

- Set environment variables

- Shutdown all services

- Unzip the patch

$ unzip p21260431_121020_Linux-x86-64.zip

$ cd <PATCH_TOP_DIR>/21260431

- Run opatch apply

$ opatch apply

- Verify patch

$ opatch lsinventory |grep 21260431

- Start all services

Rollback Patch 21260431

If any issues after applying the patch and rollback is required

- Stop the services

- Run opatch rollback

$ opatch rollback -id 21260431


- Restart all services

Related Posts:

Oracle Database 12.1.0.2.5 - Applying Patch 19509982: DISABLE FIX FOR RAISING ORA-1792 BY DEFAULT.

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464] [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

When using BI Admin Tools 11.1.1.7.150120 with Oracle Client 12c & invoking Metadata Importa Wizard to import data from Exadata database, you may see above error message in the OBIEERPD_NQSAdminTool.log file.

On the Metadata Import Wizard screen, steps to Import Metadata

1 - Select Data Source
2 - Select Metadata Types (Select all relevant schema objects tables, views, indexes, etc)
3 - Select Metadata Objects - Here Exadata database is visible in the wizard but no oracle schemas are displayed & therefore import cannot proceed. No error message displayed on BI Admin Tool but the error message above is displayed in NQSAdminTool.log file

If your OBIEE Admin Tool environment is an OBIEE 11g Client Tools only install, required Oracle database client library files may be missing as Client Tools is a minimal install only & may not contain all directories as in full install. There may also be a mismatch in java, Oracle Client & OBIEE installed in your environments. Check if it is 32-bit or 64-bit or mismatch.

You can resolve this issue by 

1) Installing Oracle database client software (32-bit or 64-bit depending on version of OBIEE Admin Tool installed). Install only if not already installed.

Once Oracle Client is installed, configure TNSNAMES.ORA entry for your Oracle Database & edit bi_init.bat file under $BI_HOME\bifoundation\server\bin and add TNS_ADMIN variable pointing to location of TNSNAMES.ORA.

2) If you already have Oracle Database 12c Client installed on the Windows machine where OBIEE 11g BI Admin Tools is installed but facing this issue in the Metadata Import Wizard, you can simply copy oracore12.dll as oracore11.dll


OBIEE Admin Tool import will now show all available schemas in step 3 of the Metadata Import Wizard.

Related Posts:

Configuring evaluate function to work in OBIEE

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics