How Oracle Enable TDE on RAC 19c DB
There're 5 major steps to enable Transparent Data Encryption (TDE) on Oracle 19c RAC database in this post. Set Wallet Parameters Create Keystores Set TDE… Read More »How Oracle Enable TDE on RAC 19c DB
How to Resolve ORA-00283 and ORA-00264
ORA-00283 and ORA-00264 When you saw both ORA-00283 and ORA-00264 at the same time like the following: SQL> recover database; ORA-00283: recovery session canceled due… Read More »How to Resolve ORA-00283 and ORA-00264
How to Patch Grid and Oracle Home 12c (PSU 32917447)
In this post, I want to patch PSU 32917447 on grid and oracle home 12.1.0.2. Since I have talked about patching Grid and RAC database… Read More »How to Patch Grid and Oracle Home 12c (PSU 32917447)
How to Get Sequence DDL from ALL_SEQUENCES
You don't have to export and import sequences by data pump, you can compose the creation statements by querying ALL_SEQUENCES: [oracle@primary01 oracle]$ vi compose_create_sequence.sql set… Read More »How to Get Sequence DDL from ALL_SEQUENCES
How to Get Synonym DDL from ALL_SYNONYMS
You don't have to export and import public synonyms by data pump, you can compose the creation statements by querying ALL_SYNONYMS:: [oracle@primary01 oracle]$ vi compose_create_or_replace_synonym.sql… Read More »How to Get Synonym DDL from ALL_SYNONYMS
How Oracle Shrink Temp Tablespace
First of all, let's see how much size of the temporary tablespace is currently. SQL> column gb format 9999.99; SQL> select sum(bytes)/1024/1024/1024 gb from dba_temp_files… Read More »How Oracle Shrink Temp Tablespace
DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment
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 »DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment
How to Resolve ORA-12850 Oracle Error Message
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated Met an error when I tried to monitor the database by querying… Read More »How to Resolve ORA-12850 Oracle Error Message
How to Resolve ORA-28232 Oracle Error Message
ORA-28232: invalid input length for obfuscation toolkit Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error.… Read More »How to Resolve ORA-28232 Oracle Error Message
How to Resolve ORA-29283 Oracle Error Message
ORA-29283: invalid file operation: nonexistent file or path [29434] Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes… Read More »How to Resolve ORA-29283 Oracle Error Message