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
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
Without ".sh" worked for me. I mean, just try the syntax with "frmcmp_batch" and not "frmcmp_batch.sh".
ReplyDeleteJust wanted to share so that it might be helpful to someone.