I am trying to replace the text "*url" with the value "jdbc:oracle://localhost:1521;SID=dbinst".

The script I am using to replace the "*url" string is as below

`sed -e "s/$URL_UNIQ_TAG/$URL/" $ACT_FILE_NAME > $TEMP_FILE_NAME`

Here

$URL_UNIQ_TAG =*url

$URL=jdbc:oracle://localhost:1521;SID=dbinst

$ACT_FILE_NAME is the source file.

When I execute this, I am getting the following error

sed: command garbled: s/*URL/jdbc:oracle://localhost:1521;SID=dbinst/

Please help me..

Thanks in advance.

I'm not understanding what your final output should look like, but maybe I can get you started. You have two issues (I'm using ksh):

1) To embed shell variables in a sed script you have to surround them with quotes:

sed 's/'"${URL_UNIQ_TAG}"'/'"${URL}"'/g' act_file_name

2) You have special characters in your data
that probably have to be escaped:
URL="jdbc:oracle:\/\/localhost:1521;SID=dbinst"

I can not edit the input as I don't know which format it is coming from. so I get the "jdbc:oracle:\\localhost:1521;SID=dbinst" value dynamically.

I even used the sed 's/'"${URL_UNIQ_TAG}"'/'"${URL}"'/g' act_file_name..

but no luck