Thursday, December 28, 2017
Automatic Memory Management (AMM) in Oracle Database 11g R2
Identify Memory Requirement.Following queries show you how to display the relevant memory information and how to combine with a single statement to calculate the required values.-- Individual values.COLUMN name FORMAT A30COLUMN value FORMAT A10SELECT name, valueFROM v$parameterWHERE name IN ('pga_aggregate_target', 'sga_target')UNIONSELECT...
Monday, December 18, 2017
Oracle FNDLOAD Scripts
By
Muqthiyar Pasha
6:42 AM
Online-Oracle-DBA
,
Oracle 12.1.x
,
Oracle 12.2.x
,
Oracle E-Business Suite
No comments

FNDLOADTips and Examples Using FNDLOAD (Doc ID 735338.1) Download Script Upload Script 1. LookupsFNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt...
Monday, December 4, 2017
Running ADOP Fails With Error "ETCC Not Run In The Database Node"
By
Muqthiyar Pasha
9:15 PM
ADOP
,
Online-Oracle-DBA
,
Oracle 12.2.x
,
Oracle E-Business Suite
No comments

Error: ETCC not run in the database node [Node Name] The EBS Technology Codelevel Checker needs to be run on the database node. It is available as...