Tags » 11g

BPM update adds Case Management Web Interface and REST APIs

Oracle has just released BPM Bundle Patch 3 which adds the out of the box web interface for Advanced Case Management and REST APIs for working with BPM. 302 more words

checking used cursor counts

A note to self post for queries to use to check cursor counts presently in use and to troubleshoot ORA-1000: maximum open cursors exceeded:

select sum(a.value), b.name…

139 more words

Oracle DB 11gR2 - Audit files generated in $ORACLE_HOME/rdbms/audit even though location is changed

Oracle DB 11gR2 – Audit files generated in $ORACLE_HOME/rdbms/audit even though location is changed

show parameters
NAME                     TYPE                     VALUE
----------------       ------------------ --------------------
audit_file_dest     string /var/adm/log
audit_sys_operations boolean FALSE
audit_trail string DB… 79 more words

DBMS_METADATA.GET_DDL database link password missing

Another annoying bug that was “introduced” in

$ sqlplus test/test

SQL*Plus: Release Production on Sat Apr 12 15:01:02 2014

Copyright (c) 1982, 2011, Oracle. 691 more words

Searching for Doc Id 1428008.1 on MOS

If you are searching online for information about multiple Authentication Providers in Oracle BI 11g, you could find references (even on my own blog) to Doc Id; 1428008.1 on My Oracle Support (MOS). 66 more words



Have a look at the error description:

$ oerr ora 2072
02072, 00000, "distributed database network protocol mismatch"
// *Cause: This should never happen between different PRODUCTION releases of
// ORACLE, but may happen between alpha and beta releases, for example. 400 more words


One of our customers uses a custom tool for gathering license information from their databases. This tool runs the following query, to check the SYSAUX tablespace: 1,365 more words