It's not clear, actually, if this involves a TCP/IP "Mystery". What it
may involve is a simple lack of ability to communicate. Or something.
I got this question:
"Request help w/ finding a reference or you can post a blog about how you can you have 2 oracle servers or for that matter any 2 servers listening in on different sockets on the same unix box."
And this background. Such as it is.
"They are going to ask, how can this work? My lame explanation is that on a unix box you can have multiple servers listening in on different ports. I tried Googling around but couldn’t find anything good."
It appears that the DBA provided a TNSNAMES.ORA. And some desktop tool
user was not happy with the TNSNAMES.ORA that was provided.
The saga is long and sad.
It amounts to something like this.
DBA: Here's the TNSNAMES.ORA.
User: That didn't work.
DBA: Yes, it did.
User: No, it didn't. You're an idiot.
DBA: I know you are but what am I?
And it devolved from there into a request to help use Google to locate
a tutorial on TCP/IP address and port numbers.
I'll repeat that: a request to help use Google.
Apparently, the desktop user had done something in database A and
couldn't find the results in database B. And didn't understand what
was going on.
And this lead to the DBA asking me to help with Google to prove that
the DBA's TNSNAMES.ORA worked.
How does that help the user?