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
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
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
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
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
How do I manually drop a database? In this article, we are going to learn how to drop the oracle database manually step by step. Perform these steps in UAT first don’t perform on the production database server. How to Create Pluggable Database Oracle How do I drop an entire database? Prerequisites Before taking any … Read more
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 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
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
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
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
Transport tablespace from Linux to windows platform step by step In this tutorial, I’m going to show you how Transport tablespace from Linux to windows platform, in oracle Database we can transport tablespace and Database from one platform to another platform. In this topic, I’m using Redhat Linux 6 (64 bit) and Microsoft Windows 7 … Read more
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