This tutorial from oracle 11g, and we are going to learn how to configure OEM dbconsole manually on the Linux platform. If you previously configured the OEM console but it is not working. So, we need to drop the existing configuration and recreate the OEM repository, start configuration using the …
In this article, we are going to learn how to drop 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 Prerequisites Before taking any action you must know the location of datafile, controlfile and …
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 …
Read moreHow to install, configure, and use Statspack in Oracle
Hi Guys, in this article we are going to learn how to rename 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 how to rename database using …
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 creating ASM diskgroups you can use asmca (Oracle ASM Configuration Assistant) which is providing a …
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. Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password file backup. …
Read moreHow to Restore RMAN Backup with a Different Database Name
Partitioning in existing table Hello, friends in this article we are going to disuse how to partitioning in 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 …
Read moreHow to Partitioning in existing table using EXCHANGE PARTITION
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 …
Read moreTransport Tablespace from Linux to Windows in ORACLE 11g & 10g