Hi,

I am able to sort this issue. We need to add connection string in tnsnames.ora files.

sample is as below:

TEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = "hostname(eg. http://www.test.biz)")(PORT = "port(eg. 1520)"))

)

(CONNECT_DATA =

(SERVICE_NAME = TEST)

)

)

Thanks,

Abhas