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

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:
TNS_ADMIN=$ORACLE_HOME/network/admin

Changed value of TNS_ADMIN:
TNS_ADMIN=/u01/install/VISION/11.2.0/network/admin

*I hardcoded the path of “tnsnames.ora” file in TNS_ADMIN value(in above path).

Now working…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s