Oracle
Oracle Database is one of the most powerful and reliable database management systems on the market.
Widely used in highly complex corporate applications, and renowned for its robustness, security and performance, it supports critical environments and large volumes of data.
In this category, you’ll find tutorials for installing, administering and optimizing Oracle Database, as well as tips for managing instances, implementing replication with Data Guard and automating processes with tools such as OEM and scripts. Also explore backup, recovery and data migration strategies for modern environments.
After completing a database upgrade, difficulties arose in starting the database via srvctl. To fix this, you have to tell srvctl the new home…
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…
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…
When creating a simple table, an insufficient privileges error occurred:ERROR at line 1: ORA-01031: insufficient privileges.This happened…
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…
Problem: When trying to execute opatchauto outofplace, the execution failed with the error below: Solution: One of the ORACLE_HOME already…
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…
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…
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…
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…