Can you please advise what are the requirements to set up OLEDB CONNECTION SUCCESSFULLY and which string should I use? --pls see the above suggested link.
Do we really nned to have ORACLE CLIENT ON QLIKVIEW SERVER MACHINE? -- Not required.
check ur ora.tns file is updated with ur oracle server data base details or not.
if required check ur system environment variable setup.