Error PRCD-1229 after manual upgrade
After completing a database upgrade, difficulties arose in starting the database via srvctl. To fix this, you have to tell srvctl the new home…
Remove orphaned tables from Data Pump
Check for orphan tables in the database. We have two orphan jobs in the database. This is verified by the NOT RUNNING status.Let’s…
ORA-16905: The member was not enabled yet.
I finished configuring a Data Guard Broker, and the members were displaying the Warning: ORA-16905: The member was not enabled yet. The fix is…
ORA-01031 – GENERATED BY DEFAULT AS IDENTITY
When creating a simple table, an insufficient privileges error occurred:ERROR at line 1: ORA-01031: insufficient privileges.This happened…
Cleaning the OEM software library
In order to purge the OEM’s OMS Shared File System, the filesystem /middleware/swlib/ is constantly alarming due to the use, in my case…
OPATCHAUTO-72126
Problem: When trying to execute opatchauto outofplace, the execution failed with the error below: Solution: One of the ORACLE_HOME already…
ORA-01996: GRANT failed: password file ” is full
I needed to assign the DBA privilege to a user and came across the error: The error is due to the entries option that is used to create the…
Error starting OMS service
I got an error when I tried to start OMS. The SYSMAN password was changed directly in the database, instead of being changed correctly via…
ORA-15221: ASM operation requires compatible.asm of string or higher
When trying to create a SPFILE in an ASM instance, I got the following error: ORA-15221: ASM operation requires compatible.asm of 11.2.0.0.0…
How to estimate index size
To estimate the size of an index before creating it, we can use the DBMS_SPACE package. This is useful for assessing the impact of creating a…