I got a chance to test views_as_tables recently. My friend wanted to take backup of few views which will have content in it. Since database version for her was Oracle 12c, I suggested for VIEWS_AS_TABLES. But here is the catch – She wanted to export specific rows from the view. Traditional way of doing this…
Category: ORACLE 19c
Temporary Tablespace | Sparse files | alter session set events=’60063′
Today we will cover everything about Temporary Tablespace, Sparse files, alter session set events=’60063′ . Everyone might know this – Temporary Tablespace are used for sorting operation in Oracle database. But Have you ever noticed ? Why creating a temporary tablespace with a size of 10gb is faster then creating a data tablespace with a…
How to Migrate OCR , Vote File , ASM SPFILE and ASM Password file to new Diskgroup in Oracle 19c
Similar to Database, storage also comes with support timelines, and this is one of the major reason storage team will ask you to migrate asm disks from old to new. Adding a disks and removing the old disks can be done with minor change in size for external redundancy diskgroups but not for high or…
srvctl start database Fails with CRS-5802: Unable to start the agent process in Oracle 19c
Today, We faced above issue where srvctl start database was failing on one node. It was failing with “CRS-5802: Unable to start the agent process” . There was no clue in database alert log what was causing the problem. Following issue was reported on Sun Solaris OS / 19.11 Binary Version If you check database’s…
How to Add Datafile in Tablespace in Oracle 19c
When I started as L1 Oracle Database Administrator, it was my regular task to check free space at tablespace level and maintain enough space to avoid application downtime because of “Unable to extend <tablespace> by XX Bytes” error. That’s the reason I brought this post. How to add datafile in tablespace in oracle 19c, We…
How to Change Scan Listener Port in Oracle RAC 19c | Modify Scan Listener Port in Oracle RAC 19c
Welcome back, recently I have shared how to change local listener port in Oracle 19c, Similarly today I will cover how to modify scan listener port in Oracle RAC 19c. To be honest with you, I never got such request from application team / Any team as of now. But recently my colleague forgot to…
How to Change Listener Port in Oracle 19c
Changing of Listener Port is not a regular activity. But Application team can request you to change it. Today, we are going to learn how to change Local listener port in Oracle 19c RAC and Non Rac. Why to Change Local Listener Port in Oracle 19c You might be wondering what makes application team to…
Multiplex Control file in Oracle RAC database 19c
If you are working for Financial/Banking domain, you will have a Guidelines given by the Auditors and doesn’t matter if you are restoring a fresh database or making a copy of it. You need to follow it. So recently we had a request to restore a database for PUC purpose, but since it was on…
How to make OPATCHAUTO Simplified in Oracle 19c
Hey Readers, Today I am going to share all the checks we do before patching Oracle RAC / ASM Standalone oracle 19c database server. Some of the steps may not be required if you are doing manual patching. GI and RDBMS owner – Password shouldn’t be lock or expired As we know that analyze command…
root.sh – CLSRSC-196: ACFS driver install actions failed in Oracle 19c
Yesterday, one of my colleague reported an issue where we were doing HAS installation. It was an AIX 7.1 OS on which were trying to install 19.14 Grid Infra and Oracle Binary. All prechecks were completed. And everything was looking good. But when we executed root.sh it failed with – CLSRSC-196: ACFS driver install actions…