Home › Discussions › Questions & Answers › Forms Compilation Failure: TNS Identifier Not Resolved

Forms Compilation Failure: TNS Identifier Not Resolved

Avatar photoCustomer Questions & Answers 5 replies

Our forms compilation step failed during the install with the error ORA-12154: TNS:could not resolve the connect identifier specified. I believe this is related to TNS configuration, but where in the Blitz Report setup should I look?

5 replies

  • Support Enginatics

    This specific error is known to occur because the `TNS_ADMIN` variable is incorrectly set within the Oracle compilation scripts itself. You must modify the `frmcmp_batch.sh` script, located in `$ORACLE_HOME/bin/`.

  • Avatar photoCustomer

    Which line needs fixing in `frmcmp_batch.sh`?

  • Support Enginatics

    You need to replace the line `TNS_ADMIN=$ORACLE_HOME/network/admin` with `TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}`. This ensures that the existing environment variable for `TNS_ADMIN` is honored if set.

  • Avatar photoCustomer

    Since we clone environments frequently, how do I ensure this fix persists and doesn’t get overwritten in future copies?

  • Support Enginatics

    For persistence, you must also apply the identical correction to the associated template file located at `$ORACLE_HOME/inventory/Templates/bin/frmcmp_batch.sh`. If you are on EBS R12.2, you must repeat both actions on both the run and patch file systems.

  • You must be logged in to reply to this post.