Be careful to read the command completely.
The sync is for $APPLPTMP and not $APPLTMP
[oracle@celprovm024 START51]$ echo $APPLPTMP
[oracle@celprovm024 START51]$ echo $APPLTMP
Please verify that your $APPLPTMP is set to /usr/tmp
I am confused.
/usr/tmp at apps server is not the same as /usr/tmp at db server because they are different machines and do not share disks.
In actuality this parameter is set on the apps tier so that when the PLSQL code is run as a concurrent request, the output is placed in /usr/tmp of the database tier. This is why they need to be in sync.
APPLPTMP is a special directory used only for PLSQL temporary files. When a concurrent program uses the FND_FILE package, the concurrent manager uses APPLPTMP as the directory to which it writes temporary files. FND_FILE uses the UTL_FILE package, which can only write to directories specified in init.ora. Thus, APPLPTMP must be one of the directories listed in init.ora in order for FND_FILE to work.
So what I do is to check below:
[applmgr@oraapps-2 ~]$ echo $APPLPTMP
Then I am good to go?
Yes - correct. You got it!