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 …
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 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 …
Read moreCreating Non CDB database in silent mode – ORACLE 19C
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 …
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 …
Read moreHow to set Oracle Pluggable Database Automatic startup
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 …
Export Tables using PARFILE, Table export also known as the table level export in oracle data pump utility. DBA take table level export using expdp data pump command. Oracle DBA perform export import task as per there requirements. Export backup also called as logical backup. The export backup we can …
Hi friends, in this article we are going to solve the ORA-01244 error, that you will be facing during manual database recovery. ORA-01244 unnamed datafiles added to control file by media recovery Cause: Actully that error most of the time you will face during the recovery, due to the datafile …
Read moreORA-01244: unnamed datafile(s) added to control file by media recovery
In this article we are going to learn how to load oracleasm module or solve if oracleasm not mounted. Some time we face loading module oracleasm failed error. During creating the ASM disk we are facing the below error Read: Oracle Database Migration from Non-ASM to ASM oracleasm module not …