Tags » 11g

BPM update adds Case Management Web Interface and REST APIs

Oracle has just released BPM 11.1.1.7 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
Errors

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
11g

DBMS_METADATA.GET_DDL database link password missing

Another annoying bug that was “introduced” in 11.2.0.4.

11.2.0.3:

$ sqlplus test/test

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

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

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

11g

ORA-02072

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
Oracle

V$SYSAUX_OCCUPANTS, DBA_EXTENTS extreme slowness

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

Oracle