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