Introduction Need for want of lock statistics in a oracle table in some cases, for example 1. Don’t want a table to be analyzed by schedule statistics job but want…
Read MoreError: FRM-30087: Unable to create form file $ORACLE_HOME/forms/WOENTRY.fmx Cause: Non-oracle user cannot write in the “output” directory or the mentioned fmx exists but user cannot overwrite it. Workaround: 1. By…
Read MoreError: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory Solution: 1. As a workaround, make sure the following 64 bits openmotif packages…
Read MoreError: =========== We came across below ORA error during import of Schema ORA-39083: Object type TYPE:”FMSDEV”.”SAMPLE_TYPE_TABLE” failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE…
Read MoreWe have to check the below details before reorganize the table TABLE DETAILS SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES/1024/1024/1024 FROM DBA_SEGMENTS WHERE SEGMENT_NAME IN (‘WF_ITEM_ACTIVITY_STATUSES_H’); OWNER …
Read MoreUpdate Database Tier to Latest Code Call env from APPS NOde Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out. $ perl <AD_TOP>/bin/admkappsutil.pl mv…
Read Moreadop patch process cycle steps: 1) Run FSCLONE 2) PREPARE 3) APPLY 4) FINALIZE 5) CUTOVER 6) CLEANUP Before start to apply the patches we have to run fsclone to…
Read MoreAs a new feature of EBS 12.2.5 , we have adopmon(adop monitor, Online Patching Monitoring utility) utility for monitoring the online patching cycles. It provides a readable output, letting us…
Read MoreWe might some time get into below issue after clone or after installing AD and TXK patches. Error: ETCC not run in the database node [Node Name]…
Read MoreOn Application Tier: Source the Applications environment file as the owner of the application tier file system and run: $ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl \ -script=$FND_TOP/patch/115/bin/txkInventory.pl \ -txktop=$APPLTMP \ -contextfile=$CONTEXT_FILE…
Read More