Installation/Configurations19c

Changing Password file in Oracle RAC   1. First check the current configuration of the system and the password file location . [oracle@rac1-test ~]$ srvctl config database -d testdbDatabase unique …

Implement in-memory in your RAC database   Oracle has provided In-memory feature at base_level for free. You use 16GB allocation limit for this feature to be used without the licence. …

Configuring EM Express on 19c Rac Database   SQL> select dbms_xdb_config.getHttpPort() from dual; DBMS_XDB_CONFIG.GETHTTPPORT()—————————–0 SQL> select dbms_xdb_config.getHttpsPort() from dual; DBMS_XDB_CONFIG.GETHTTPSPORT()——————————0 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); PL/SQL procedure successfully completed. SQL> select dbms_xdb_config.getHttpsPort() …

Oracle Dataguard 19c Configuration Implementing a disaster recovery solution for Oracle databases involves setting up Oracle 19c Dataguard with PDB, which ensures data protection and availability. Dataguard provides real-time data …

Unplug and Plug of PDB in a Transparent Data Encryption (TDE) Environment   Within an Oracle environment utilizing Transparent Data Encryption (TDE), the process of transferring a pluggable database (PDB) …

Cleaning Up older records in AUD$ table Auditing refers to the process of monitoring and collecting specific user database actions and storing this information in designated tables. It is a …

Oracle Database 19C Enterprise Manager Express Not Working Our client, who is currently utilizing Oracle 19c Database, has expressed their desire to leverage Oracle Enterprise Manager (OEM) to monitor and …

      As an Oracle Database Administrator, one of the common challenges faced by DBAs is ensuring that the Disaster Recovery (DR) system is in sync with the Primary server. …

Roll forward of Data Guard in Oracle In this blog post, we will be discussing the roll forward option of Dataguard in Oracle, which is a critical process in ensuring …

19c Active DataGuard DML Redirection ACTIVE DATAGUARD DML REDIRECTION is a new feature in Oracle 19c which enables the Data Manipulation Language (DML) operations on the Standby Server to be redirected …