- ‘.patch_storage’ consumes quite some space?
- Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
- RollbackSession failed in system modification phase — Archive not rolled back
- verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
- SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log
- ORA-16700: The standby database has diverged from the primary database
- AUTO_STATS_ADVISOR_TASK missing after the upgrade causing ORA-20001
- Tracing listener dynamic service registration
- ORA-16766: Redo Apply is stopped
- Listener — Linux Error: 2: No such file or directory
- Unhandled datatype (-25) found in kxsbndinf — capturing bind variables
- Message xxxx not found; No message file for product=RDBMS, facility=ORA
- ORA-20001: Statistics Advisor: Invalid task name for the current user
- ORA-12516 TNS:listener could not find available handler with matching protocol stack
- IMP-00403: Warning: This import generated a separate SQL file “logfilename_sys” which contains DDL that failed due to a privilege issue.
- RMAN-05158: WARNING: Auxiliary (datafile / tempfile) file name conflicts with a file used by the target database
- ORA-00600: internal error code, arguments: [ksvworkmsgalloc: bad reaper] open resetlog fail
- ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks
- ORA-26040: Data block was loaded using the NOLOGGING option
- ORA-12801: error signaled in parallel query server
- ORA-00093: pga_aggregate_limit must be between
- ORA-01033: ORACLE initialization or shutdown in progress with Dataguard
- The home is not clean and cannot be used due to a failed OPatch execution
- Size of a table containing large object columns — clob & blob
- Resize Operation Completed For File# (Doc ID 1982901.1)
- ORA-16038 — when network is slow
- ORA-63999: data file suffered media failure — Oracle shut down by itself
- File ID for temp data files
- DBMS_STATS GATHER_FIXED_OBJECTS_STATS hangs
- SQLPlus spool to multiple files
- ORA-01489 or ORA-22835 when using LISTAGG
- ORA-08102: index key not found, obj# 35775, file 34, block 5830 (2) on a function-based index
- ORA-01878: specified field not found in datetime or interval
- DBMS_LDAP example
- ORA-02085: database link MYDB_LINK connects to MYDB
- Invalid Java Class objects and ORA-29534
- ORA-24247: network access denied by access control list (ACL)
- SQL Patch another example
- oratop – a handy tool to monitor database in real-time
- ORA-16649: possible failover to another database prevents this database from being opened
- ORA-01795 — PARSE ERROR: ospid=17974, error=1795 for statement
- ORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameter LOG_ARCHIVE_DEST_1 destination
- ORA-16714: the value of property is inconsistent with the database setting
- Oracle patch apply order matters
- Adding a column with default taking a long time?
- Strange issue PL/SQL: SQL Statement ignored & ORA-00942
- Interesting fact — having space within data file name
- Monitor Temporary Tablespace Usage
- Converting column data type from clob to varchar?
- ORA-19510 & ORA-27044 RMAN duplicate failed on CIFS
- ORA-01244: unnamed datafile(s) added to control file by media recovery
- ORA-01623: log xx is current log for instance xxxx (thread 1) – cannot drop
- ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM]
- PGA_AGGREGATE_LIMIT
- SGA_MAX_SIZE specified is high ORA-00700: soft internal error, arguments: [sms physmem limit]
- Process running with Bequeath (beq) Protocol?
- Delete a snapshot control file?
- Create symbolic link on CIFS share under Linux
- ORA-16624: broker protocol version mismatch detected
- Dynamic Service Registration with IPC protocol?
- Oracle 19c — ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
- little things to pay attention
- Fatal NI connect error 12514 and TNS-12564
- OPatch needs exec option on /tmp
- Rebuilding database from scratch due to an interruption
- ORA-19527: physical standby redo log must be renamed
- ORA-27106: system pages not available to allocate memory
- JDBC Numeric Overflow with SQL error code: 17026
- Which Oracle session is generating redo logs most?
- Monitoring process/session usage in Oracle SE
- Oracle Instant Client installation on Linux
- DB_BLOCK_CHECKSUM vs DB_BLOCK_CHECKING
- Interesting case with ORA-00245
- RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy
- ODG — ORA-38760 This database instance failed to turn on flashback
- ODG — ORA-16854: apply lag could not be determined
- Things to note in Oracle Initialization Parameter Files
- Oracle startup failure with ORA-00704 ORA-00604
- Large size of trace files from MMON
- Which user to run ADRCI?
- Purging flat (non-XML) text listener log file for ASM, SCAN etc.
- Purging Audit Trail in RAC & ODG with ASM environment
- A subtle detail of outer join
- SchemaSpy — Graphical Database Schema Metadata Browser
- Redo & Standby Redo files created as OMF when duplicating a standby database
- Getting AWR report every hour automatically
- RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
- Disable or add hint for queries you cannot touch the query text
- Buffer Cache Usage for a lob segment if cached
- select sequence NEXTVAL slow?
- Oracle ADR partition full due to large trace files
- ODG broker error: ORA-1005: null password given; logon denied
- ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
-
Follow
Following
Already have a WordPress.com account? Log in now.
JoeLi's TechLife 