Oracle Solutions
474 FOLLOWERS
Oraclesolutions intends to share all the valuable knowledge and keys to relevant products of Oracle Especially Databases and ERP.
Oracle Solutions
2d ago
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
Oracle Solutions
2d ago
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
Oracle Solutions
2d ago
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
Oracle Solutions
2d ago
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
Oracle Solutions
2d ago
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
Oracle Solutions
2d ago
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
Oracle Solutions
2d ago
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
Oracle Solutions
3M ago
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
Oracle Solutions
3M ago
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
Oracle Solutions
3M ago
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