• Thanks for the reply.

    The oracle client tools have been installed on the server only from where I am attempting linked server connection.

    The oracle OLEDB provider is working fine but for the microsoft oledb provider for oracle, I am receiving the above given error.