When running media recovery with RMAN, the alert log may show repeated lines like "ORA-279 signalled during: alter database recover logfile …". Despite the ORA prefix, this is not necessarily an error. ORA-00279 indicates that the database is requesting the next archived redo log needed to...
Regular expressions describe text patterns using literal characters and metacharacters. In Oracle Database (10g and later), SQL gains native regex support through a set of REGEXP_* functions that implement a POSIX-style dialect with several Perl-like features. This guide summarizes the syntax, optio...
When connecting with sqlplus user/password@service you may see a stack similar to: ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM ORA-02002: error while writing to audit trail ORA-00604 indicates a failure in an internal (re...
This note walks through diagnosing and resolving OPatch error code 135 (ZOP-51: "The patch location is not valid for apply") encountered while applying a patch bundle on an AIX single-instance environment. Symptom Running opatch apply from the patch directory fails immediately with ZOP-51:...