Prepare phase failed With Error “ETCC Not Run In The Database Node”
We 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 MoreScript To Find the Versions of all the Oracle E Business Suite R12.2 technology stack components utility
On 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 MoreSQL Wise CPU Usage
SQL Wise CPU Usage select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID…
Read MoreASM files db wise
ASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read MoreHow to resolve ERROR: FRM-18108 while compiling the form in R12
FRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. We…
Read MoreFetching particular concurrent request out file remotely
This script fetch & transfer the specific concurrent request log file to remote location. $ vi Connout.sh cat /dev/null > /usr/tmp/ftp.log cat /dev/null > /usr/tmp/ftp1.log echo “Enter Concurrent program Request…
Read MoreORA-12547: TNS :lost contact when try to connect to Oracle
ERROR: ORA-12547: TNS :lost contact when try to connect to Oracle There could be many reasons for the above error, but one of the common issue is due to incorrect…
Read MoreGet any Apps User Password from Backend
In this steps we can find any user name’s password in oracle apps. STEP 1: login to Database through Command Prompt #sqlplus / as sysdba STEP 2 : Create Function…
Read MoreORA-00245: control file backup failed in Rman backup
A snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. The snapshot controlfile must be on a location shared…
Read More11i: “APP-FND-01542” Error When Logging Directly Into Forms Via the f60cgi in 11.5.10
Applies to: Oracle E-Business Suite Technology Stack – Version 11.5.10.0 to 11.5.10.0 [Release 11.5] Information in this document applies to any platform. Checked for relevance on 25-SEP-2013 Goal How to…
Read More