Row-level database activity can drive outbonud HTTP calls by wiring a trigger to invoke a PL/SQL procedure that performs the request via UTL_HTTP. Network access must be permitted using ACLs, and character-set handling needs attention to prevent data corruption. Trigger to invoke an HTTP request CRE...
Oracle exposes a physical address called ROWID. As long as a row is not relocated (no row migration), the ROWID for that row remains the same, allowing lookups even without a primary key. PostgreSQL exposes a similar physical locator, ctid, which is a tuple address composed of (block_number, offset_...
SQLNET.EXPIRE_TIME enables server-side dead connection detection (DCD) by sending periodic probes to verify cliant/server connections are still alive. When the server cannot reach the client, it raises an error on the connection and the server process exits, allowing PMON to reclaim database resourc...
Oracle Managed Files (OMF) lets the database pick file names, sizes, and locations for many database files. When OMF is enabled and correctly configured, you can create a tablespace without specifying a DATAFILE or TEMPFILE clause. If OMF isn’t configured, running CREATE TABLESPACE without a file cl...
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:...