Saturday, March 29, 2025

Finding and Monitoring SQLs in Execution

›
  Dictionary view V$SQL_MONITOR is used to find out SQLs currently in execution and a little history of SQLs executed in the recent past. Th...
Thursday, March 6, 2025

ORA-65093: multitenant container database not set up properly

›
RMAN-00571: ======================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===...
Saturday, February 15, 2025

ORA-00058: DB_BLOCK_SIZE must be 16384 to mount this database

›
This error may be returned during different scenarios; however, the root cause may be the same. I was trying to use duplicate command to bui...
Saturday, February 1, 2025

ORA-31655: no data or metadata objects selected for job

›
  Whenever datapump export is initiated, it should (mainly) either by database level, schema level, or table level. If you omit to tell exp...
Monday, January 6, 2025

ORA-16086: Redo data cannot be written to the standby redo log

›
2024-11-22T07:09:14.930561+00:00 Errors in file /data/oracle/MYDB/admin/ diag / rdbms /MYDB/MYDB7/trace/MYDB7_lgwr_178713.trc: ORA-16086: Re...
Thursday, December 26, 2024

RMAN-06172: no AUTOBACKUP found or the specified handle is not a valid copy or piece

›
       RMAN> restore controlfile from '/home/oracle/current.257.1073287779_20240609_0030';       Starting restore at 12-JUN-24 ...
Saturday, October 19, 2024

ORA-01103: database name ... in control file is not ...

›
S QL> srtup pfile = init.ora   ORACLE instance started.       Total System Global Area 3226043912 bytes   Fixed Size                  91...
Saturday, September 28, 2024

RMAN-06617: UNTIL TIME

›
RMAN-00571: ===========================================================   RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==========...
Sunday, August 11, 2024

ORA-29339: tablespace block size 4096 does not match configured block sizes

›
SQL> create tablespace testtbs blocksize 4k datafile '+DATA' size 2m;   create tablespace testtbs blocksize 4k datafile '...
Sunday, July 28, 2024

ORA-03214: File size specified is smaller than minimum required

›
SQL> alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m;   alter da...