M.S.S.E wrote:
(...)
how set up such a connection
(...)
I need (...) a complete guide to setup (...)
It doesn't work like this! This is a place where you can get a quick answer, not complete guide.
Please, use Google with statements:
Oracle enable tcp/ip connections
How to setup Oracle server remote connections
.NET Oracle connection string
Try!