Should Run datapatch After DBCA mustafakalayci, 2022-11-03 Yesterday, I was testing some stuff in database and I needed to create new homes/new databases (new life new beginning). at a point I realized that something is not right about database. One thing to another I found the reason and it was interesting to me. I used DBCA to… Continue Reading
APPLY with status WITH ERRORS in the PDB mustafakalayci, 2022-10-29 Yesterday, I was doing some tests about noncdb to pdb conversions and during one of these tests I got a strange error. By the way, I am doing those tests because of a side effect of noncdb to pdb. I have already created an SR about it and write a… Continue Reading
How to Check Empty Space in a Securefile LOB mustafakalayci, 2022-09-27 Hi, PS: please check last sql statement in this post for shorter and faster solution. first sql is for showing all information about the lob. Yesterday, while checking segment space usage data in a client’s database and some of the LOB segments were absurdly big. So, I want to check… Continue Reading
catcon.pl cheat sheet mustafakalayci, 2022-08-26 Hello, Oracle uses a container database architecture permanently anymore, you should be familiar with “catcon.pl” perl file. Let’s say you have container database with 10 different PDBs and you need to run a script file on all of those pdbs (maybe even in root and seed too) so what you… Continue Reading
Audits are not Purged mustafakalayci, 2022-07-30 Hello, This week I realized that some of my databases’ audit data are not purged and audit tables get bigger. I already have a scheduler job to purge my audit records but somehow job has been completed successfully but audit records are not deleted. This is 19.15 version, NON-CDB databases…. Continue Reading
lsnrctl or new db connection is too slow mustafakalayci, 2022-07-20 Hello everyone, I know this is not new but I haven’t seen this problem for a long time and it takes a while to find out it. A team leader (who is an elder brother to me) from the company I started to my first job called me and asked… Continue Reading
How to Convert LONG to Clob PART 2 mustafakalayci, 2022-05-06 Hi, I just want to write a small post today. Some time ago, I shared a way to convert long to clob in a query directly: http://10.157.89.12/2020/04/06/how-to-convert-a-long-column-to-clob-in-a-query/ Even if this method works, it works really slow and anything slow annoys me! So, I want to share another method which is much… Continue Reading
Zero Data Loss DISASTER Database for Standard Edition 2 mustafakalayci, 2022-04-22 Hi, As you know Data Guard is an Enterprise Edition option and only accepted method to protect your data against a “DISASTER” (DR) is data guard. How about Standard Edition 2(SE2)? Is this possible? Well I did it so, king of yes 🙂 with some risk of course. Warining: I… Continue Reading
3 Ways to Migrate a Non-CDB Database to a PDB mustafakalayci, 2022-03-25 Hi Everyone, Time is fast and everything is changing constantly. Multi-tenant architecture has come many years ago and starting by 21c, it is the only option! So, old “non-cdb” databases must be migrated/converted to a PDB (Pluggable database). I must admin that I was being lazy for many years and… Continue Reading
STOPPED Job While Migrating Non-CDB to PDB via Autoupgrade mustafakalayci, 2022-03-20 Hi, Lately, I started to learn about autoupgrade which is the new upgrade tool for almost anything. Many thanks to Mike Dietrich for amazing blog posts ( https://mikedietrichde.com ). His blog is a real treasure. I am about to migrate some non-cdbs to pdbs and before doing that I wanted… Continue Reading