Implementing Class of Secure Transport (COST) in Oracle RAC 11.2 Introduction:Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances …
Read More »
Oracle Database Archive Log Generation Details The Blog presents a script designed to query and report on redo log switch history and the size of archived logs in an …
Read More »
Disabling and Uninstalling AWR (Doc ID 1909073.1) Some reference on it?– How To Avoid the AWR Usage Without Having Diagnostic Pack License (Doc ID 2276199.1)– Controlling Diagnostic and Tuning …
Read More »
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 …
Read More »
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 …
Read More »
Critical Patch Update for January 2025 The Critical Patch Update (CPU) for January 2025 was released on 21 January 2025. Oracle strongly recommends applying the CPU patches as soon as …
Read More »
Oracle Database 23ai with Oracle E-Business Suite 12.2 Oracle recently announced that Oracle E-Business Suite (EBS) Release 12.2 is certified with Oracle Database 23ai (DB 23ai) for on-premises Exadata …
Read More »
Switchover to Production ODA Environment Standby———- SQL> SELECT PROCESS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE ‘MRP%’; PROCESS———MRP0 SQL> set lines 133 pages 133select database_role,db_unique_name,open_mode,protection_mode from gv$database; DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE PROTECTION_MODE—————- …
Read More »
Troubleshooting Oracle RAC Node Eviction The RAC Node Eviction Troubleshooting Tool is designed to help diagnose and resolve RAC node eviction issues by analyzing uploaded log files. When …
Read More »
ORA-01035: ORACLE only available to users with RESTRICTED SESSION 1. First Check the Pdbs Status SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ———————————————————————————————————————— PDB$SEED …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner