Tuesday, September 25, 2012

compile a form using frmcmp_batch.sh ORA-12154: TNS:could not resolve the connect identifier specified


When attempting to compile a form using frmcmp_batch.sh or frmcmp.sh

The following errors occurs

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


Solution: 

Cause

The TNS_ADMIN set in the scrip frmcmp_batch.sh or frmcmp.sh is pointing to the wrong location.
When the script frmcmp.sh or frmcmp_batch.sh is executed it resets the TNS_ADMIN to $ORACLE_HOME/network/admin

See the following from the scripts:
...
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
...
While it should be:
...
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN

...


Reference : 431324.1

No comments:

Post a Comment