Oracle Database Discussions

Hi,

If there are two databases running on the server, Is it opt to configure unique listener port for the two databases? and what happens if a unique listener port configured?

Thanks
KSG

Edited by: KSG on Oct 16, 2011 11:53 PM
Hi Jgarry/Hemant

For client-server data transfer.

I understand like

First, the client send the request to the db server, the listener listens the connection and creates a database server process to handle the request (may be a query..

I just want to understand how the processed data information passes to the client.. i meant.. what are the ports involded to transfer the data back from db server to the client?

From Jgarry, I understand the data flow actually happens through a seperate data port (say it may be any port 1599 or someting).. So Do all the further traffic happens between client-server or server-client uses the same Data-port?

Im trying to understand the architectural flow of connectivity between clien-server and vice-versa. which will help to understand better.

My concern is..

we are establishing connectivity from client through TNS names. The server listenes the connectivity and creates a server session to execute the connectivity. Simply like.. a request made from client to database to listen service_name 'orcl', host=abc.com protocol=TCP port=1521. which is listen on the server side and the server recoganize the connectivity...

Here I'm trying to understand.. once the connectivity is established then there is no need of listener anymore. Even we can stop the listener. How the TCP portocol in the Oracle Net is going to establish the data flow between the servers (how the sequence of request and response happens).
If the TCP network layer is used to interact between the servers then how the data flows between the servers; like is it uses a seperate port number to send/receive the data.

Thanks
KSG


Thanks in advance
KSG

Edited by: KSG on Oct 16, 2011 11:55 PM
(added further required clarifications regarding data flow between client-server)