fbpx

How to upgrade ORACLE 11G to 19C

Upgrade oracle 11g to 19c

In this article, we are going to learn how to upgrade the oracle 11g to 19c database on the Linux platform step by step. My Environment for this practice Prerequisites: Before starting the upgrade make sure you have done the below checklist: Stop the Listener Take full database backup using RMAN Purge Recycblebin Gather Dictionary … Read more

Change Archivelog mode and Destination In Oracle 19c

Change Archivelog mode and Destination

In this article, we are going to learn how to change archivelog mode and destination in oracle 19c. Start Change Archivelog mode and Destination Step 1: Check Archive log mode Status Check current archive log mode status in oracle 19c. As we checked our database running in no archive mode. Step 2: Create the Archive … Read more

How to Change Archivelog Destination in Oracle

Change Archive Log Destination

In this article, we are going to learn how to change archive log destination in the oracle database production (LIVE) environment step by step. Sometimes we face disk space issues in the production environment due to high archive generation. So, here we are going to discuss how to change the archive destination in a standalone … Read more

How to kill Inactive sessions in ORACLE?

kill Inactive sessions

Hi, In this article we are going to learn how to kill inactive sessions. Sometimes there are so many inactive sessions available in the database. Due to these inactive sessions our database response a little slowly. So we need to kill them using the below steps. Read: How to create a database link Subscribe on YouTube … Read more

How to check Database size and tablespace Utilization?

Database size and tablespace Utilization

Database size and tablespace Utilization? In this article, we are going to check full database size, used size, and free space in the database as well as check the tablespace utilization details. Read: Find redo log members, redo log file size and redo log status Subscribe on YouTube Step 1. To check Database total space. … Read more

How to Relocate Datafiles in Oracle?

Relocate Datafiles in Oracle

In this article, we are going to learn how to Relocate Datafiles in Oracle from one mount point to another mount point or disk. In other words, you can say that due to insufficient disk space we need to move data files to a different location. Read: How to drop oracle database manually Subscribe on … Read more

How to Configure OEM DBconsole Manually

OEM DBconsole Manually

OEM DBconsole Manually This tutorial is from oracle 11g, and we are going to learn how to configure OEM dbconsole manually on the Linux platform. If you have previously configured the OEM console but it is not working then we need to drop the existing configuration and recreate the OEM repository, start configuration using the … Read more

Oracle 19c Installation on OEL 7 step by step

ORACLE 19C INSTALLATION ON LINUX

Hello Friends, in this article we are going to learn how to install oracle 19c on OEL 7) step by step. In this installation, we use the oracle-database-preinstall-19c package. Creating Non-CDB database in silent mode – ORACLE 19C OS Version OS version which we are going to use in this article. Prerequisite for Oracle 19c … Read more

How to install, configure, and use Statspack in Oracle

Statspack in Oracle

Oracle Statspack Hello guys, in this article we are going to learn how to install, configure and use statspack in oracle. In this activity, I’m going to use the Oracle 12c environment. Introduction to Statspack If the DB server running very slow, then we need to perform DB tuning and it is very important to … Read more

How to Rename Database Using Controlfile

How to Rename Database Using Controlfile

How do I change a database name in Controlfile? Hi Guys, in this article we are going to learn how to rename a database using controlfile. Actually, we have two ways to rename the oracle database listed below. Rename Database using controlfile. Rename Database using NID utility. So, here I’m going to us first one … Read more

Creating Non CDB database in silent mode – ORACLE 19C

Creating Non CDB database in silent mode

In this example, we are using oracle 19c and going to learn how to Creating Non-CDB database in silent mode. As you know, we can also create a database using the DBCA utility but in some cases, we don’t have access to the GUI. So here we will learn silent mode database creation step by … Read more

How to Create Pluggable Database Oracle

Create Pluggable Database Oracle

In this article, we are going to learn how to create pluggable database Oracle in oracle 12c or 19c. Here I’m going to create a pluggable database using PDB seed (PDB$SEED). How to set Oracle Pluggable Database Automatic startup Create Pluggable Database Step 1. Check current database details with existing pdbs. In my case the … Read more

How to set Oracle Pluggable Database Automatic startup

Pluggable Database Automatic startup

As you know the pluggable database concept introduce in oracle 12c and when we startup the CDB database the PDBs (Pluggable Database) will be mount stage. So that time we need to open PDBs manually using alter command. Here we are going to learn how to Oracle Pluggable Database Automatic startup step by step. To … Read more

How to create ASM diskgroup

create diskgroup asm

In this article, we are going to learn how to create an ASM diskgroup, so here I’m going to show you the complete steps to creating ASM devices and then the ASM disk group. To create ASM diskgroups you can use asmca (Oracle ASM Configuration Assistant) which is providing a GUI interface. But in this … Read more

How to Restore RMAN Backup with a Different Database Name

How to Restore RMAN Backup with a Different Database Name

Hello friends, in this article I’m going to demonstrate to you Restore RMAN Backup with a Different Database Name on New Server step-by-step guide. Restore oracle database from rman backup to another server Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password … Read more

How to Partitioning in existing table using EXCHANGE PARTITION

How to Partitioning in existing table using EXCHANGE PARTITION

Partitioning in existing table Hello, friends in this article we are going to disuse how to partition the existing table using EXCHANGE PARTITION. If you want to learn more about partition click here. In this article, we are going to perform the below actions. Create a sample table and insert some records in this table. … Read more

How to Convert the NON-CDB database to CDB

How to Convert the NON-CDB database to CDB

In this article, I’m going to show you how to convert a NON-CDB database into cdb database. Convert non-container database to multitenant pluggable database with Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit. Run the following commands on both machines. Output from Non-CDB database Output from CDB database Output from CDB database Run the … Read more

How to upgrade 11g to 19c manually?

How to upgrade 11g to 19c manually

In this article, we are going to discuss how to upgrade Oracle 11g (11.2.0.4) to 19c (19.2.0.0) manually. Follow me step by step carefully. Start to upgrade 11g to 19c manually Source Environment About Source Details OS Details Redhat Linux 7.6 (64 bit) Oracle Database version 11.2.0.4 Database Name OCP ORACLE_HOME path /u01/app/oracle/product/11.2.0.4/dbhome_1 Target Environment … Read more

19c data guard new features

data guard new features

Hello friends, in this article I’m going to discuss here oracle Oracle 19c Data Guard concepts. The changes in Oracle 19c Data Guard concepts and administration are listed below The process of flashback a physical standby to a point-in-time that was captured on the production (primary) is simplified by automatically replicating restore points from production … Read more

Oracle 19c Active Data Guard-DML Redirection

Oracle 19c Active Data Guard-DML Redirection

DataGuard DML Redirection Hello friends, in this article we are going to discuss the oracle 19c DML Redirection feature with DataGuard. ACTIVE DATAGUARD DML REDIRECTION is a new feature in Oracle 19c which enables the Data Manipulation Language (DML) operations on the standby server to be redirected and run on the production (Primary) database. The updated data will … Read more

Oracle 19c Data Guard Configuration step by step

Oracle 19c Data Guard Configuration

Hello friends in this article, we going to discuss Oracle 19c Data Guard Configuration step by step. Oracle Data Guard is a high availability model which prevents downtime and data loss by using redundant systems and software to eliminate single points of failure. Our Environment for this practice Primary Environment DB_NAME OCP DB_UNIQUE_NAME OCP IP … Read more

Oracle Database 19c Installation on Oracle Linux 7

Oracle Database 19c Installation on Oracle Linux 7

Hello, friends in this article we are going to discuss Oracle database 19c (64-bit) Installation on Oracle Linux 7. Using this article we are going to Install an Oracle 19c server based with a 2GB swap. Software I used in this article VMware Oracle Linux 7 (64-bit) Oracle Database 19c (19.3, 64-bit) Download Database Software You … Read more

Oracle 19c RPM based Installation

Oracle 19c RPM based Installation

Hello, friends in this article we going to Install Oracle 19c RPM based on Oracle Linux 7 64-bit, and the article based on a server installation with a 2GB swap, please follow all the steps carefully. How to Install oracle 19c If you have Unbreakable Linux Network (ULN) access, so as per oracle documentation you … Read more

Create Manual Database in Oracle 19c

Create Manual Database in Oracle 19c

Hi, in this article we are going to discuss how to create a Manual database in oracle 19c. In my last article, we discussed how to create a database in RPM-based installation in the Oracle 19c database. Our Environment Operating System Oracle Linux 7 Database version Oracle Database 19c Database Name ocptech So before creating a database we … Read more

Cloning Database Using DBCA

Cloning Database Using DBCA

In this article, we are going to learn Cloning Database Using DBCA. A cloning Database is just a copy of your production database that is used for testing purposes or you can use any other purpose also, after cloning the Database you have the same copy of your production database. For making a Database clone … Read more