Forms Compilation Failure: ORA-12154 TNS error

I am experiencing ORA-12154: TNS:could not resolve the connect identifier specified when the installation tries to compile forms.

7 replies

Support Enginatics December 27, 2019
This error is typically due to the TNS_ADMIN variable being incorrectly set in the forms compilation script, preventing it from finding your tnsnames.ora file.
Customer December 28, 2019
Which specific script needs fixing?
Support Enginatics December 28, 2019
You need to edit the $ORACLE_HOME/bin/frmcmp_batch.sh script. Replace the line TNS_ADMIN=$ORACLE_HOME/network/admin with TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}.
Customer December 30, 2019
Since this is a common issue, should I fix it elsewhere too?
Support Enginatics December 31, 2019
Yes, to ensure the change persists across cloned environments, you should also apply the same correction to the associated template file: $ORACLE_HOME/inventory/Templates/bin/frmcmp_batch.sh.
Customer January 2, 2020
I’m on R12.2. Does that change anything?
Support Enginatics January 4, 2020
For R12.2, you must repeat the modifications on both the run and patch file systems to ensure consistency.