Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
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 »Oracle Database Archive Log Generation Details
Yearly Archives: 2025
Disabling and Uninstalling AWR
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 »How to Verify Oracle Data Guard Sync Status
Verify whether your Primary Oracle Database is in sync with the Standby Database in a Data Guard configuration. Solution: To ensure synchronization, you need to check the Managed Recovery Process …
Read More »Disable SYS Auto Jobs from the Database
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
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 »EBS 12.2: Application tier SSL wallet gives error while opening Apache folder via Oracle Wallet Manager
ISSUE: I had to renew my customer’s EBS SSL certificate as it was about to expire soonSince the EBS 12.2.7 wallet had the ability to open wallet in GUI mode …
Read More »After login to EBS 12.2.5 the Home page gives error: You have encountered an unexpected error. Please contact the system administrator for assistance
ERROR: When we click on the home button on landing page after login on java applet we are facing this issue.” You have encountered an unexpected error. Please contact the …
Read More »Critical Patch Update January 2025
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 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
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 »