ORA-31225: DBMS_LDAP: invalid BER_ELEMENT
Cause: An attempt was made by a PL/SQL module to use a BER_ELEMENT which is not valid and might have already been freed.
Action: Check the BER_ELEMENT in PL/SQL module involving DBMS_LDAP.

ORA-31220: DBMS_LDAP: PL/SQL – Invalid LDAP SSL wallet location.
Cause: There has been an error in the DBMS_LDAP operation.
Action: Please check the LDAP sslwrl value that you use for LDAP operation, or report the error number and description to Oracle Support.

This query shows how many bytes are used by a tablespace and how many are allocated:

SET LINES 150
SET pages 300
col “Tablespace” FOR a30
col “Total MB” FOR a15
col “Used MB” FOR a15
col “% Used” FOR a15
 
SELECT
tablespace_name “Tablespace”,
d.STATUS “Status”,
TO_CHAR((a.bytes / 1048576),’99,999,990.900′) “Total MB”,
TO_CHAR(((a.bytes – DECODE(f.bytes, NULL, 0, f.bytes)) / 1048576),’99,999,990.900′) “Used MB”,
TO_CHAR((((a.bytes – DECODE(f.bytes, NULL, 0, f.bytes)) / 1048576)*100) / (a.bytes / 1048576),’999,999.9′) “% Used”
FROM
(sys.dba_tablespaces d JOIN sys.sm$ts_avail a USING (tablespace_name))
LEFT OUTER JOIN sys.sm$ts_free f USING (tablespace_name)
ORDER BY …

ORA-31407: end_date must be greater than the begin_date
Cause: The end data of the change set is earlier than the begin date. The end date must always be later in time than the begin date, so that the duration between the begin and end dates is a positive amount of time.
Action: Change the begin date and/or the end date, so that the end date is later than the begin date.

ORA-31402: unrecognized parameter string
Cause: Unrecognized parameter was detected.
Action: Check for too many parameters in the call.

ORA-31231: DBMS_LDAP: invalid PROPERTY_SET
Cause: An attempt was made by a PL/SQL module to use a PROPERTY_SET which is not valid and might have already been freed.
Action: Check the PROPERTY_SET in PL/SQL module involving DBMS_LDAP.

ORA-31226: DBMS_LDAP: MOD_ARRAY size limit exceeded
Cause: An attempt was made by a PL/SQL module to add an element beyond the MOD_ARRAY size limit.
Action: Increase the MOD_ARRAY size limit in PL/SQL module involving DBMS_LDAP.

ORA-31221: DBMS_LDAP: PL/SQL – Invalid LDAP SSL wallet passwd.
Cause: There has been an error in the DBMS_LDAP operation.
Action: Please check the LDAP sslpasswd value that you use for LDAP operation, or report the error number and description to Oracle Support.

DBMS_OUTPUT is a package that let you able to write some output on the screen. In SQL*Plus you can enable the output with this command:

SQL> SET serverout ON

All output will be written in a buffer. The default size of the buffer is 20,000 bytes. If you want a different buffer size you must use the enable procedure:

DBMS_OUTPUT.ENABLE (
buffer_size IN INTEGER DEFAULT 20000);

The defualt buffer size is 20,000 bytes, the maximum size is 1,000,000 bytes and the minimum is 2,000. To enable an unlimited buffer size you must …

ORA-31408: invalid value specified for begin_scn or end_scn
Cause: The begin_scn was not greater than zero. The end_scn was less than zero. The end_scn was less than the begin_scn.
Action: Check the values of both begin_scn and end_scn. Correct them to make sure that they form a legal SCN range. An end_scn value of zero indicates an infinite scn range.