Tuesday, August 6, 2024

Find SCN Timestamp in Oracle Database

 SELECT SCN_TO_TIMESTAMP(13232543131) from dual;

Database version on SQL Server Management Studio


SELECT @@VERSION AS FullVersion;

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

RMAN> Show all;   --> use this command to view the RMAN configuration settings

1. Eligible to delete archivelog files applied on all standby databases (required for DR setup) and those files should be backed up 1 time on the database (primary/production).

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;


2. No Deletion policy. Eligible to delete all available archivelog files from the database.

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;


3. Eligible to delete all archivelog files applied on all standby databases (DR environment).

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;


4. Eligible to delete archivelog files which are already backed up 1 time by the database.

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

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