The post Removing Old Grid Home appeared first on Oracle Solutions. Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-component System Version ————— 19.20.0.0.0 System node Name ————— testlinux Local System Version ————— 19.20.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.20.0.0.0 up-to-date GI 19.20.0.0.230718 up-to-date DB { [OraDB19000_home5 [db1,db2]]19.20.0.0.230718 up-to-date [OraDB19000_home6 [db3]]19.20.0.0.230718 up-to-date } D ..read more

The post Materialized View refresh error appeared first on Oracle Solutions. Materialized View refresh error generating huge Archive Logs after Database Upgrade to 19c. Issue:- A huge amount of archive log generation when materialized view refreshing after database upgrade from 11g to 19c and performance issues while accessing the database.   Analysis:- On checking the issue it was noticed that a database feature naming “MV Refresh stats Collection” was introduced from Oracle Database 12.2.0.1. This is used to monitor refresh performance of Materialized views. Database collects and stores ..read more

The post AC-50480: Internal error occurred appeared first on Oracle Solutions. AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora SOLUTION: AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [ID 1324667.1]   To implement the solution, please execute the following steps: NOTE: Ensure that you have taken a backup of your system before applying the recommended solution. 1. Clean the Data Topology Model Sqlplus apps/… SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT; 2. Run AutoConfig on all tiers, firstly ..read more

The post adapcctl.sh exiting with status 204 appeared first on Oracle Solutions. While cloning Oracle Applications You might encounter an issue: adapcctl.sh exiting with status 204 Start Services log shows: opmnctl: starting opmn managed processes… ================================================================================ opmn id=adfcvs.chainsys.com:6250 0 of 1 processes started. ias-instance id=CVS1213_adfcvs.adfcvs.chainsys.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ——————————————————————————– ias-component/process-type/process-set: HTTP_Server ..read more

The post Application Report Queries appeared first on Oracle Solutions. QUERY TO CHECK LIST OF RUNNING REQUEST SELECT q.concurrent_queue_name qname, f.user_name, a.request_id “Req Id”, Decode(a.parent_request_id, –1, NULL, a.parent_request_id) “Parent”, a.concurrent_program_id “Prg Id”, a.phase_code, a.status_code — ,b.os_process_id “OS” — ,vs.sid — ,vs.serial# “Serial#” — ,vp.spid , a.oracle_process_id “spid”, ( Nvl(a.actual_completion_date, SYSDATE) – a.actual_start_date ) * 1440 “Time”, c.concurrent_pr ..read more

The post Application DBA Queries appeared first on Oracle Solutions. QUERY TO GET all user assigned to GIVEN RESPONSIBILITY SELECT UNIQUE u.user_id, Substr(u.user_name, 1, 30)           user_name, Substr(r.responsibility_name, 1, 60) responsiblity, Substr(a.application_name, 1, 50)    application FROM   fnd_user u, fnd_user_resp_groups g, fnd_application_tl a, fnd_responsibility_tl r WHERE  g.user_id(+) = u.user_id AND&nb ..read more

The post Oracle Database Monitoring Queries appeared first on Oracle Solutions. QUERY TO CHECK SIZE OF ALL TABLESPACES SELECT /* + RULE */ df.tablespace_name “Tablespace”, df.bytes / ( 1024 * 1024 ) “Size (MB)”, SUM(fs.bytes) / ( 1024 * 1024 ) “Free (MB)”, Nvl(Round(SUM(fs.bytes) * 100 / df.bytes), 1) “% Free”, Round(( df.bytes – SUM(fs.bytes) ) * 100 / df.bytes) “% Used” FROM   dba_free_space fs, (SELECT&n ..read more

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