Phani - Please find the oracle connection in tableau all you need to do is provide the necessary Server name ,port -1521 most cases ,Service name ,Username and password .
Just you like normally configure these detail in a Oracle SQL Developer.
It should be pretty straight forward.
Thanks for your reply. password is not shared to us. Is there any way to connect oracle using java api or any other way using encrypted password.
You don't need to know the password as the workbook author will be the one who will embed the credentials during publication.