Thursday, April 19, 2012

frmplsqlconv.sh unable to connect to database

frmplsqlconv.sh  to upgrade forms from 6i to 10g forms ..getting error to connect database .


 Solution :
frmcmp.sh or frmcmp_batch.sh , frmplsqlconv.sh is executed it resets the TNS_ADMIN to $ORACLE_HOME/network/admin
go to $ORACLE_HOME/bin (10.1.2 )
See the following from the scripts:
...
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
...
and change to
...
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN


Ref: 431324.1

No comments:

Post a Comment