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 …

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() …