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

Forms Compilation Failure: TNS Identifier Not Resolved

Avatar photoCustomer March 15, 2022 at 9:25 pm

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support March 16, 2022 at 2:07 am  

      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 March 16, 2022 at 7:50 pm  

      Which line needs fixing in `frmcmp_batch.sh`?

    • Support March 17, 2022 at 4:16 pm  

      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 March 18, 2022 at 8:34 am  

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

    • Support March 19, 2022 at 9:14 am  

      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.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: