ORA-01244

ORA-01244: unnamed datafile(s) added to control file by media recovery

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

ORA-12919 Can not drop the default permanent tablespace

ORA-12919: Can not drop the default permanent tablespace

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

ORA 03297

Resize Oracle datafiles down to the minimum without facing ORA-03297

Hi, Today we are going to discuss how to Resize Oracle datafiles down to the minimum without facing ORA-03297. As we know the data-files stored our data and they are growing daily basis. suppose your data-files have grown in the past but now you want to reclaim as much space …

Read moreResize Oracle datafiles down to the minimum without facing ORA-03297

ORA-10456 cannot open the standby database

ORA-10456 cannot open the standby database

Here we are going to discus how to solve ORA-10456: cannot open standby database media recovery session may be in progress. The ORA-10456 is Oracle Data guard error. Note: The following error is coming at that time when you trying to open your standby database in read-only mode without stopping the archive process. ORA-10456 cannot open the …

Read moreORA-10456 cannot open the standby database

Solution PRCR 1086 resource ora.mgmtdb

PRCR 1086 resource ora.mgmtdb is already registered

In this article, I’m going to discuss the PRCR 1086 resource ora.mgmtdb resource which I was facing at the time of grid configuration on the Oracle Linux 6.7 platform. I have checked the logfile for grid configuration which is existing on the following path “/u01/app/oraInventory/logs/installActions2019-03-16_09-10-07PM.log“, and got the following information from the …

Read morePRCR 1086 resource ora.mgmtdb is already registered

Enable Notifications    OK No thanks