Home Discussions Questions & Answers ORA-12154: TNS:could not resolve the connect identifier specified

ORA-12154: TNS:could not resolve the connect identifier specified

Avatar photoCustomer April 17, 2022 at 7:45 pm

I’m encountering issues during the forms compilation step in Oracle EBS, where it fails with the error ORA-12154: TNS:could not resolve the connect identifier specified. This seems related to the TNS_ADMIN variable configuration. Could you provide detailed steps to resolve this issue, including how to prevent it from recurring in cloned environments and any adjustments needed for associated scripts or templates in EBS R12.2?

Viewing 0 reply threads
  • Author
    Replies
    • Support April 18, 2022 at 1:47 am  

      Hi,

      Check and correct the TNS_ADMIN variable setting in frmcmp_batch.sh as per Oracle note 431324.1. Replace:

      TNS_ADMIN=$ORACLE_HOME/network/admin

      with:

      TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}

      Update the template file at $ORACLE_HOME/inventory/Templates/bin/frmcmp_batch.sh to make the change persistent for cloned environments. If needed, apply similar corrections to other scripts (frmbld.sh, frmcmp.sh, etc.) and their templates. For EBS R12.2, repeat this for both run and patch file systems.
      Please check https://www.enginatics.com/installation-guide/#ORA-12154 for more details.

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

Login with: