Step:-1 Check invalid Invalid Component:- SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’; COMP_NAME ——————————————————————————– Oracle XML Database Step:-2 execute the below packages and triggers ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE BODY ;…
Read MorePatch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015 Step: -1 Environment Details export ORACLE_HOME=/u01/app/19c/grid export PATH=/u01/app/19c/grid/bin: $PATH [oracle@rac1 ~]$ srvctl config database -verbose oradb /u01/app/oracle/product/19c/dbhome_1 19.0.0.0.0…
Read MoreThis blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle database.…
Read More1. Overview This document talks about how to send report with excel file automatically to Finance Team every month of 21st. This report for employee referred the candidate who will complete the 90 days and above for the current month of 21st. 2. Technologies and Tools Used The following technologies has been used to automatically send report to Finance Team. Ø MS SQL Server Ø DotNet & Angular 3. Use Case Assume that there is a requirement to automatically send report to Finance Team. 4. Architecture Following steps explains in detail, Step 1: First we have to check whether joined candidates reach 90 days for current month of 21st. To select Current Year, Month , Date and calculate candidate cross 90 days. DATEDIFF(DAY, DateofJoin, GETDATE())>=90 AND DATEDIFF (DAY, DateofJoin, GETDATE())<=Datedifference BEGIN DECLARE @DateDifference int=0; DECLARE @LastMonth int=0; DECLARE @CurrentYear int=0; DECLARE @CurrentMonth int=0; DECLARE @PreviousYear int=0; SELECT @CurrentMonth =DATEPART(mm,DATEADD(mm,0,GETDATE()); SELECT @LastMonth =DATEPART(mm,DATEADD(mm,-1,GETDATE()); SELECT @CurrentYear =DATEPART(mm,DATEADD(yyyy,0,GETDATE()); set @PreviousYear=@CurrentYear; if(@LastMonth=12) BEGIN SELECT @CurrentYear =DATEPART(mm,DATEADD(yyyy,-1,GETDATE()); END DECLARE @FromDate varchar(10), @ToDate varchar(10); set @FromDate=convert(varchar,@LastMonth) +’/’+’21’+’/’+convert(varchar,@PreviousYear);…
Read MoreRunning Oracle Database on Amazon Web Services (AWS) Relational Database Service (RDS) provides a variety of advantages, including scalability, flexibility, and managed services. However, in order to secure your sensitive…
Read MoreHardware monitoring commands: – Display information about the environment and hardware:- odaadmcli show env_hw Display information about the filesystem:- odaadmcli show fs Display information about the Memory:- odaadmcli show memory…
Read MoreORA-07445 – exception encountered: core dump Issue :- DB was down due to the ORA – 07445 error in the alert log Cause:- ORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV]…
Read MoreSERVER CONTROL UTILITY (SRVCTL) Server Control Utility (SRVCTL): It is used to administer Oracle Real Application Clusters (Oracle RAC) databases and instances. Use SRVCTL to manage Oracle supplied resources such as:…
Read MoreIntroduction: Do you know there is malware in Linux that impacts your Oracle Database and Oracle Applications environment? This malware impacting critical Linux/Oracle systems is by Kinsing. The Malware’s primary…
Read MoreBelow message keeps repeating in Alert-log. Warning: VKTM detected a time drift. Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.…
Read More