The post ODA Space Utilization Issue appeared first on Oracle Solutions. Oracle Database Appliance Space Utilization Issue   One of the basic issue when having ODA (Oracle Database Appliance) system is space utilization in /opt mount point. Recently I was facing the same issue on my Oracle Database Appliance version 19.17.0.0.0 one node, on checking the /opt mount point thoroughly it was found a file “dcs-agent.log” was generating the same log message repeatedly and a file of around 1.5G was being made daily on just one node. File Location :- /opt/oracle/dcs/log/dcs-agent.log   Error ..read more

The post FS_CLONE give error at ADOPValidationUtils appeared first on Oracle Solutions. 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/funoraclea ..read more

The post Understanding AutoConfig in EBS appeared first on Oracle Solutions. 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, you may need to identify and customize these template files to override the default settings used by AutoConfig. **Key Considerations for Customizing AutoConfig Templates** 1. Non-Customizable Templates: If a template file contains the “LOCK” keyword, it is not eligible for customization. AutoCo ..read more

The post Switchover MySQL appeared first on Oracle Solutions. Switchover MySQL   Source 199 Replica 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; set global read_only=OFF; set global super_read_only=OFF; show variables like '%read_o%'; SHOW MASTER STATUS; -- TEST-SQL2-bin.000002 --2760785 create user 'rep_user'@'172.25.2.198' identified with mysql_native_password by 'CP@MySQL2023'; create user 'repcat'@'%' identified by 'CP@MySQL2023 ..read more

The post Autoconfig Completed With Error INSTE8_PRF 1 appeared first on Oracle Solutions. 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 error: DRG-10502: index JTF.JTF_AMV_ITEMS_URL_CTX does not exist ORA-06512: at “CTXSYS.DRUE”, line 160 ORA-06512: at “CTXSYS.CTX_DDL”, line 1119 ORA-06512: at “CTXSYS.AD_CTX_DDL”, line 336 ORA-06512: at line 96     SOLUTION 1. Drop the index JTF_AMV_ITEMS_URL_CTX from APPS and JTF schema and then ..read more

The post Restarting MYSQL Instances and Servers appeared first on Oracle Solutions. 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 Replica (DR) using the MySQL native replication configuration which are in-sync.   Restarting the MYSQL Databases (DR Server). Login to the DR (10.218.86.8) environment. Start the MYSQL workbench Connect to the server using the root user and password. In the SQL Tab run the following command ..read more

The post Configuration of MYSQL Master Slave Replication appeared first on Oracle Solutions. 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 as MYSQL Master – Slave replication. On Master (172.21.50.162):- Login to the Master (172.21.50.162) environment. Start the MYSQL workbench Connect to the server using the root user and password. Use this command to check the status of the slave server at the moment and ..read more

The post Oracle EBS Database Upgrade from 12c to 19c Part-2 appeared first on Oracle Solutions. Oracle EBS Database Upgrade from 12c to 19c Part-2   This post is a continuation of the previous article on Oracle EBS Database Upgrade from 12c to 19c Part-1. Here, we will delve into the remaining part of the database upgrade process from 12c to 19c. Let’s begin with Section 6, building upon Section 5 discussed in the last post.   Section 6 – Create the CDB through DBCA Step 1. Create the CDB On the database server node Source 19c environment and run below from GUI Terminal/VNC Ru ..read more

The post Oracle EBS Database Upgrade from 12c to 19c Part-1 appeared first on Oracle Solutions. Oracle EBS Database Upgrade from 12c to 19c Part-1   In this article, I will be discussing the process of upgrading Oracle Database 12.1.0.2 to the latest version, 19.19 (Latest PSU APR-23), while using Oracle EBS Apps R12.2.12. This post follows the previous article on upgrading Oracle EBS Apps from version 12.2.0 to 12.2.12. If you are new here and interested in installing and upgrading Oracle E-Business Suite R12.2.x, you can refer to the following link for a step-by-step installation guide ..read more

The post Oracle Apps Upgrade 12.2.0 to 12.2.12 appeared first on Oracle Solutions. Oracle EBS Upgrade from 12.2.0 to R12.2.12   This post will offer comprehensive guidance on upgrading Oracle EBS Release R12.2.0 to R12.2.10. It is crucial to understand that this guide is part of a series dedicated to EBS apps upgrades. Hence, it is important to acknowledge that the specific patches needed for a fresh installation of the R12.2.0 version may differ. Nevertheless, the steps described in this post will remain unchanged regardless of any variations in the required patches.   To install v ..read more