I am going to explain some points about Oracle EBS technology.
Recently I was working on Oracle EBS R12 Forms customization. During customization, I faced many issues in which some was very difficult like this issue.
ORA-12154: TNS:could not resolve the connect identifier specified
This issue was coming on Compilation of Oracle Form using frmcmp_batch.sh command. Below is the command which used to compile Oracle Forms in R12:
Syntax of Form Compiler:
frmcmp_batch.sh Module=<*.fmb file name with full path> Userid=<userid/password@instance_name> Output_File=<*.fmx expected output file name> module_type=form
Example of Form Compiler:
frmcmp_batch.sh Module=/u01/install/VISION/fs2/EBSapps/appl/au/12.0.0/forms/US/sudoku.fmb Userid=APPS/APPS@EBSDB Output_File=/u01/install/VISION/fs2/EBSapps/appl/au/12.0.0/forms/US/sudoku.fmx module_type=form
In my case, the above error was coming because ORACLE_HOME was pointing to wrong directory. So I changed the path of TNS_ADMIN in “frmcmp_batch.sh”. and ran again. Now started to run.
The value of TNS_ADMIN before changed:
Changed value of TNS_ADMIN:
*I hardcoded the path of “tnsnames.ora” file in TNS_ADMIN value(in above path).