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 …

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 …

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 …

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 …

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—————- …

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 …

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    …

Configuring AdminServer for HA   1. Check the current Network Configuration [root@test1 u01]# ifconfig -aens34: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500inet 192.168.131.200 netmask 255.255.255.0 broadcast 192.168.131.255inet6 fe80::250:56ff:feab:e4e prefixlen 64 scopeid 0x20<link>ether 00:50:56:ab:0e:4e txqueuelen …

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 …