Hello Readers, Today I will be sharing methods of Postgres SQL installation on Linux. I know, I was away from the system for a while now, I apologize for it, but I have a great news, in past 2 years, I got a chance to explore Postgres SQL. Today I will be sharing methods of…
Category: HOWTO
Expdp using VIEWS_AS_TABLES in Oracle 19c
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…
ORA-00221: error on write to control file | ORA-00206: error in writing (block xx, # blocks xx) of control file | ORA-27063: number of bytes read/written is incorrect | De-multiplexing of Control file and Redo log members in Oracle
Last week we had an incident were one of the storage went down. Just to give you clear idea, we have 2 different storage for Redo logs and controlfiles. This way we have multiplexing on database and so at Storage level too. My second shift started with following issue where one of the production database…
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 Deinstall Oracle 19c Grid Infrastructure
Today we will cover how to deinstall oracle 19c grid infrastructure. Deinstallation of Grid Infrastructure is one of the most rarest request you will come across as Oracle DBA. When Deinstallation of Oracle 19c Grid Infrastructure will come ? When requestor want to de-induct the server and they want all services to be deleted from…
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 Check and Set Hidden or Underscore Parameter in Oracle 19c
Changing Hidden parameters may lead to serious corruption issues, high performance degradation and other problems in the database. Oracle Doc I was upgrading my database from 11g to 19c, and pre-upgrade sql asked me to remove all the hidden parameters before starting actual upgrade of the database. You can refer following document which I used…