Understanding Tablespace’s MAXBYTES, AUTOEXTENSIBLE, BYTES, INCREMENT_BY

In Oracle, a tablespace is a logical storage container used to manage and organize the physical storage of database objects such as tables, indexes, and partitions. When working with tablespaces, you may come across several important attributes, including MAXBYTES, AUTOEXTENSIBLE, and INCREMENT_BY. Let’s break down each of these attributes: Let’s walk through the steps to […]

Oracle Grid 11.2.0.4 upgrade to 12.2.0.1

Upgrading Oracle Grid Infrastructure from version 11.2.0.4 to 12.2.0.1 involves several steps and considerations. You need to have Oracle Grid software for upgrading Oracle grid along with patches. General steps followed for this upgrade, You need to create same directory structure for your GRID_HOME on all RAC nodes.  Also for this upgrade Oracle need at […]

Oracle Grid 11.2.0.4 upgrade to 19c

Upgrading Oracle Grid Infrastructure and Oracle Database to version 19c offers several benefits: These are just a few of the reasons why upgrading to Oracle Grid Infrastructure and Oracle Database 19c can be beneficial. However, it’s important to thoroughly assess your specific requirements and consult Oracle’s official documentation and support resources before proceeding with the […]

Oracle 11.2.0.4 Dataguard Setup

Oracle Data Guard is a high-availability solution provided by Oracle for creating and maintaining standby databases. It is designed to ensure the availability, reliability, and data protection of Oracle databases. Data Guard provides a comprehensive set of tools, services, and features to automate the management, monitoring, and maintenance of a standby database environment. Data Guard […]