Ed Chen Logic - To Make My Logic More Logical

DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment

by Ed Chen
July 24, 2021July 26, 2021

I consistently get the wrong figures about free space of temporary tablespace in database tools, so I made a research. First of all, it's a… Read More »

How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated

by Ed Chen
July 21, 2021June 9, 2021

ORA-12850 Met an error when I tried to monitor the database by querying sessions. ORA-12850: Could not allocate slaves on all specified instances: 2 needed,… Read More »

How to Resolve ORA-28232: invalid input length for obfuscation toolkit

by Ed Chen
July 17, 2021May 29, 2021

ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »

How to Resolve ORA-29283: invalid file operation: nonexistent file or path [29434]

by Ed Chen
July 14, 2021July 14, 2021

ORA-29283 Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes failed with ORA-29283. ORA-29283: invalid file operation: nonexistent… Read More »

How to Resolve PRCD-1120 : The resource for database could not be found.

by Ed Chen
July 10, 2021May 26, 2021

PRCD-1120 PRCD-1120 means that the database you want to operate with is not found in the cluster. Usually, there may be typos in the command.… Read More »

How to Resolve ORA-01149: cannot shutdown - file 1 has online backup set

by Ed Chen
July 7, 2021July 7, 2021

ORA-01149 ORA-01149 means that some data files are in backup mode, so you can't shutdown the database in this moment. SQL> shutdown immediate; ORA-01149: cannot… Read More »

Oracle 19c Grid Installation Prerequisite Check - PRVG-12935

How to Resolve PRVG-12935: The virtual memory manager tunable parameter "vmm_klock_mode" does not have expected "BOOT" value on nodes

by Ed Chen
July 3, 2021May 19, 2021

PRVG-12935 When performing a pre-installation check of Oracle 19c grid infrastructure, we saw: PRVG-12935: The virtual memory manager tunable parameter "vmm_klock_mode" does not have expected… Read More »

How to Resolve LRM-00109: could not open parameter file LRM-00113: error when processing file

by Ed Chen
June 30, 2021May 15, 2021

LRM-00109 We usually put most parameters in a PARFILE for routine data pump operations, but you might see LRM-00109: could not open parameter file. in… Read More »

How to Resolve PLS-00123: program too large

by Ed Chen
June 26, 2021July 26, 2021

PLS-00123 When we compile a big program unit, we may get PLS-00123 if it exceeds any one of compiler limitations that Oracle allows. ... declare… Read More »

How to Find Oracle Table Creation Date Time

by Ed Chen
June 23, 2021June 12, 2021

We usually retrieve table information from ALL_TABLES, but it has no table creation date. This is because table is also an object type, so we… Read More »