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 …
In Data Pump EXPDP command use estimate only, to check the estimate the disk space required for the export backup job without performing real export backup. Before creating the export dump it’s better to check dump size using estimate_only. For example we are going to take demo of scott user. …
Read moreEstimate Required Disk Space for Export Using Estimate_only
How to fix ORA-01654 unable to extend index in tablespace Hi guys, I’m getting an “ora-01654 unable to extend index” error during the production database shutdown in the system tablespace. Actually, in my case, the database is created manually and the tablespace size is 200MB and autoextend also is off. …
Hello friends, in this article we are going to learn how to rename a database using the NID utility step by step. So in this demo, we are going to rename the db11g database name to ocptech. Before the NID utility, we can rename the database using creating a new …
Sometimes we need to add extra swap space in our Linux machine, so in this article, I’m going to show you how to add swap space to a Linux server. We have two ways to adding swap space in Linux environment. Create swap space using the file. Use Hard disk …
Hi, Today I am getting the “ORA-12919: Can not drop the default permanent tablespace” error. Actually, I tried to drop users tablespace which is the default tablespace for the database user and I’m getting the above error. ORA-12919 Can not drop the default permanent tablespace Cause – We tried to …
Read moreORA-12919: Can not drop the default permanent tablespace