All,

I have fixed it using "Allow in Process" Setting of "Oracle.oledb" provider.

1. Unchecked "Allow In Process" setting for provider.

2. Created Linked Server.

3. Checked "Allow In process" setting for provider.

I could n't created Linked server when above setting is enabled, So I had to uncheck the option and create the linked server.

But I don't really understand why.

If anyone has same experience and know the reason, Please post here.

Thanks

Madhu Pradeep