weblogic error ‘could not get the server file lock’
Down the Admin server console Clear AdminServer.lok file from tmp foleder under Admin server
Read MoreLsInventorySession failed: RawInventory gets null OracleHomeInfo
Description: In Oracle EBS Instance, recently I have faced the error as lsinventory session failed while try to run ./opatch lsinventory in our Instance.OPatch wasn’t able to find the database…
Read MoreInline External Tables
Overview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as…
Read MoreLoading CSV Files from External Tables
Overview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The…
Read More19C LISTAGG DISTINCT
Overview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to…
Read MoreOracle Analytical Functions
The easiest way to understand analytic functions is to start by looking at aggregate functions. An aggregate function aggregates data from several rows into a single result row. The aggregate…
Read MoreFacing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2
Scenario : Facing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2 Analysis : While analyzing we came across the parameter “_lm_res_hash_bucket” which inturn mentioned for…
Read MoreMissing Archive log error in Golden gate integrated capture.
Scenario: There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate. Error : ERROR OGG-00868 Error code 1291,…
Read MoreDB Node Crashes after upgrading to 19c
Scenario: DB node Crashes after upgrading from 12.0 to 19c. Error: 2021-02-04T12:00:15.450521+00:00 Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc: ORA-00600: internal error code, arguments: [3732], [33], [2], [], [], [], [], [], [],…
Read MoreTally Integration
Tally Data Integration & Data Migration Tally Integration : Comprehensive and medium-scale organizations use different applications to maintain their business and one of the important areas involved in these applications…
Read More