ORA-00031: session marked for kill Solution

ORA-00031

In this tutorial, we will learn how to solve the ORA-00031 session marked for kill error. How do you resolve ORA 00031? Step 1. Login in Database with administrator (sys) user and find spid to kill at os level. If you have the user details which find the details as per user name using the … Read more

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 drop default tablespace. Action – … Read more

PRCR 1086 resource ora.mgmtdb is already registered

Solution PRCR 1086 resource ora.mgmtdb

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 log. PRCR 1086 resource ora.mgmtdb … Read more