Installation/Configurations19c

Export & Import Process in Oracle 19c Container Database (CDB/PDB)   In this guide, we’ll walk through how to use the Data Pump (expdp/impdp) utility for export and import when …

How to Enable Archive Log Mode in Oracle 19c RAC Database: Step-by-Step Guide   In this article, we will learn how to enable Archive Log Mode in an Oracle 19c …

Disable SYS Auto Jobs from the Database   ======================================== DBMS_AUTO_TASK_ADMIN.DISABLE still shows the client_name enabled in DBA_AUTOTASK_CLIENT view (Doc ID 1565768.1) for Reference: Disable database jobs (DBMS_SCHEDULER , AUTOTASKS and …

Installing 19.18 Oracle Database on Linux 8.7 [root@oratest u01]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.209.128 oratest.oracle.com oratest [root@oratest ~]# uname -arLinux oratest.oracle.com 5.15.0-3.60.5.1.el8uek.x86_64 #2 SMP Wed …

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 …