QUERY TO CHECK LIST OF RUNNING REQUEST
Read More »Yearly Archives: 2023
Application DBA Queries
QUERY TO GET all user assigned to GIVEN RESPONSIBILITY
Read More »Oracle Database Monitoring Queries
QUERY TO CHECK SIZE OF ALL TABLESPACES
Read More »FS_CLONE give error at ADOPValidationUtils
FS_CLONE give error at ADOPValidationUtils When executing fs_Clone, the following error is encountered. ERROR [UNEXPECTED]Error occurred running “perl /u01/app/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/app/PROD/fs1/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -patchctxfile=/u01/app/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -phase=fs_clone -logloc=/u01/app/PROD/fs_ne/EBSapps/log/adop/48/20231102_181022/fs_clone/validate/funoracleapps -promptmsg=hide”[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation …
Read More »Understanding AutoConfig in EBS
Understanding AutoConfig in EBS/Oracle Apps R12.2 AutoConfig plays a pivotal role in Oracle E-Business Suite (EBS). When executed, it generates various configuration files from template files. In certain scenarios, …
Read More »Switchover MySQL
Switchover MySQL Source 199Replica 198 SOURCE SET GLOBAL read_only=ON; set global super_read_only=ON; show variables like '%super%read%'; show variables like '%read_only%'; flush tables;flush logs; SHOW MASTER STATUS; REPLICA stop slave; …
Read More »Autoconfig Completed With Error INSTE8_PRF 1
Autoconfig Completed With Error Jtfictx.sh INSTE8_PRF 1 ERROR When attempting to run the autoconfig in apps Tier its completed with error jtfictx.sh INSTE8_PRF 1. ERROR at line 1:ORA-20000: Oracle Text …
Read More »Autoconfig Issue DRG-10502
Autoconfig DRG-10502: Index JTF.JTF_AMV_ITEMS_URL_CTX DNE ERROR: Autoconfig failing with the below error: Executing script in InstantiateFile:jtfictx.shscript returned:**************************************************** jtfictx.sh started at Tue Oct 10 02:23:11 UTC 2023 SQL*Plus: Release 10.1.0.5.0 …
Read More »Restarting MYSQL Instances and Servers
Restarting MYSQL Instances and Servers Environment:- MySQL Database Instances running in two separate Windows Servers namely PROD (172.21.50.162) and DR (10.218.86.8). They have been setup as Source (PROD) and …
Read More »Configuration of MYSQL Master Slave Replication
Configuration of MYSQL Master – Slave Replication Environment:- Two Server’s with MYSQL database and different hosts/nodes, Master (172.21.50.162) and Slave (10.218.86.8). Replication will be configured between these two servers …
Read More »