Remove Disk from ASM diskgroup in Oracle 19c.
Follow 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 MoreAdd Disk to ASM diskgroup in Oracle 19c.
Follow 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 MoreDrop ASM Diskgroup in Oracle 19c.
Follow 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 MoreCreate ASM Diskgroup in Oracle 19c
Follow 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 MoreORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading of a secondary time zone data file is in an active state
Please 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 MoreORA-01591: lock held by in-doubt distributed transaction 1.92.66874
Below 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 MoreQuery to get session details for pending transactions in Oracle Database
Please 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 MoreWay to analyze ADOP logs
DBA’s find ADOP is little is bit tricky when compare to adpatch. In this blog we are going to cover to best ways to scan adop logs. To debug Online…
Read MoreAfter 19c upgrade in EBS 12.1.3 running autoconfig errors on application tier
Autoconfig errors after 19c upgrade on application tier while read UTL_FILE_DIR parameters. Error Message: PROGRAM : (/d01/dev/appl/apps/fnd/12.0.0/patch/115/bin/txkCfgUtlfileDir.pl) TIME : FUNCTION: main::getUtlFileDirParam [ Level 1 ] ERRORMSG: Unable to read UTL_FILE_DIR…
Read MoreGetting ORA-600 error while running Generate Asset Trace program
When running the concurrent program ” Generate Asset Trace” report and the initial request for this fails, subsequent spawns of “FATRACE – SLA Sub request” continuously initiate and start to…
Read More