ORA-12154: TNS:could not resolve the connect identifier specified
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?
1 reply
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.
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.