Database backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem If the database was started using SQL*Plus, and the ORACLE_UNIQUENAME environment…
Read MoreBelow sql script to check the Highest SQL Wait Time using Active Session History (ASH) col session_id for a10 col session_serial# for a10 col session_state for a20 SELECT h.session_id, h.session_serial#,…
Read MoreBelow sql script to check if any Debug or Trace profile options have been set to Y in Oracle ERP application, select distinct a.application_short_name app_short, user_profile_option_name optname, decode(level_id, 10001,’SITE’, 10002,’APP…
Read MoreFollow the below steps to remove a disk from ASM diskgroup in Oracle 19c. 1. Check the ASM disks in ASM DiskGroup. 2. Remove disk from ASM diskgroup. 3. Check…
Read MoreFollow the below steps to add a disk to ASM diskgroup in Oracle 19c. 1. Create ASM disk. 2. Check the ASM disks. 3. Add disk to ASM diskgroup. 4.…
Read MoreFollow the below steps to drop the ASM Diskgroup. 1. Check the ASM diskgroup. 2. Drop ASM diskgroup. 3. Check the disk dropped from from ASM Diskgroup 1. Check the…
Read MoreFollow the below steps to create the ASM Diskgroup. 1. Create ASM disk. 2. Check the ASM disks. 3. Create ASM diskgroup. 4. Check the newly added disk in ASM…
Read MorePlease use the below to fix the issue. CONN / as sysdba alter session set “_with_subquery”=materialize; alter session set “_simple_view_merging”=TRUE; set serveroutput on VAR numfail number BEGIN DBMS_DST.UPGRADE_DATABASE(:numfail, parallel…
Read MoreBelow is an example for transaction id 1.92.66874, you need to replace correct transaction id. Trying to manually commit or rollback this transaction commit force ‘1.92.66874’; ORA-02058: no prepared…
Read MorePlease get session detail for transaction 95.22.1516570 (Replace with your transaction id) select t1.sid, t1.username, t2.xidusn, t2.used_urec, t2.used_ublk from v$session t1, v$transaction t2 where t1.saddr = t2.ses_addr; and t2.XIDUSN =…
Read More