Wednesday 15 October 2014

frmcmp_batch.sh fails with ORA-12154: TNS:could not resolve the connect identifier specified R12

While trying to compile a form with frmcmp_batch.sh got ORA-12154
Example:

[appebs@hom3 PTB]$ frmcmp_batch.sh module=$AU_TOP/forms/US/LISTDEL.fmb userid=APPS/rajhiapps output_file=$GMD_TOP/forms/US/LISTDEL.fmx module_type=form compile_all=special > LISTDEL1.log

Forms 10.1 (Form Compiler): Release - Production

Copyright (c) 1982, 2005, Oracle. All rights reserved.

PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.5.0 Production
ORA-12154: TNS:could not resolve the connect identifier specified


Workaround:
Change TNS_ADMIN on frmcmp_batch.sh like bellow:

--OLD VALUE
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN

--NEW VALUE
# TNS_ADMIN=$ORACLE_HOME/network/admin
# export TNS_ADMIN


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



OR Apply patch 5456500 as per NOTE 431324.1

1 comment:

  1. Without ".sh" worked for me. I mean, just try the syntax with "frmcmp_batch" and not "frmcmp_batch.sh".

    Just wanted to share so that it might be helpful to someone.

    ReplyDelete