SELECT SCN_TO_TIMESTAMP(13232543131) from dual;
Chennai APPS DBA Blog
I am a software engineer and working as an Oracle Apps DBA. I have started this blog to share my knowledge with others . Here you can find stuff related to Oracle DBA,Oracle Applications DBA,
Tuesday, August 6, 2024
Database Size in SQL Server Management Studio
--List the size of all databases on the server
SELECT
DB_NAME(database_id) AS DatabaseName,
SUM(size * 8 / 1024) AS SizeMB
FROM sys.master_files
GROUP BY database_id;
Thursday, October 19, 2023
Find Logging level for EBS R12.2 Workflow services
col component_name format A50
col parameter_name format a45 head "Parameter Name"
col parameter_value format a30 head "Value"
SELECT b.component_name,
c.parameter_name,
a.parameter_value
FROM fnd_svc_comp_param_vals a,
fnd_svc_components b,
fnd_svc_comp_params_vl c
WHERE b.component_id = a.component_id
AND b.component_type = c.component_type
AND c.parameter_id = a.parameter_id
AND c.parameter_name like '%LOG_LEVEL%';
Tuesday, October 17, 2023
Find SQL Server version
Look at the first few lines of the Errorlog.n file for that instance. By default, the error log is located at
Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG
Monday, October 16, 2023
EBS R12.2 Clone Log files Location
The below-mentioned locations are more important to analyze the EBS cloning issues.
/u01/PROD/fs1/inst/apps/PROD_oracleap/admin/log/clone/
/u01/PROD/fs1/EBSapps/comn/clone/bin/
Saturday, October 14, 2023
Archive Log Deletion Policy in Oracle Database RMAN Configuration
How to find the archive log sequence from RMAN Backups
RAC Environment:
RMAN> list backup of archivelog sequence between 127 and 155 thread 1;
RMAN> list backup of archivelog sequence between 112 and 160 thread 2;
Tuesday, October 10, 2023
Java File Deployment Steps in EBS R12.2
After Java File deployment into an EBS Application. Please follow the below steps to take changes effect on the EBS application.
cd $AD_TOP/bin
adcgnjar
cd $ADMIN_SCRIPTS_HOME
admanagedsrvctl.sh stop oacore_server1
adapcctl.sh stop
adapcctl.sh start
admanagedsrvctl.sh start oacore_server1
Sunday, October 8, 2023
ETCC Failed in 19c Database - LsPatchesSession failed
First time running ETCC on newly cloned environment. While running ETCC script in database tier, it shows below error message in 19c Database
Error:
Identified database DST version: 32
Inventory load failed... LsPatchesSession::loadAndPrintInstalledPatch()
LsPatchesSession failed: RawInventory gets null OracleHomeInfo
Inventory load failed... LsPatchesSession::loadAndPrintInstalledPatch()
LsPatchesSession failed: RawInventory gets null OracleHomeInfo
Inventory load failed... LsPatchesSession::loadAndPrintInstalledPatch()
LsPatchesSession failed: RawInventory gets null OracleHomeInfo
Cause:
Database home entry is not registered in an central inventory. Checked the inventory.xml file from oraInventory location and it shows only application home entries.
Solution:
Use below command to register database home,
cd $ORACLE_HOME/oui/bin
./runInstaller -attachhome ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 ORACLE_HOME_NAME=OraDB19Home