Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Basic Question about connecting client to box with multiple oracle instance

mohitanchliaJun 8 2009 — edited Jun 10 2009

Oracle 11:

I just have a basic question about how does client/listener detemine which oracle instance to connect to:

1. tnsnames.ora and listener defines the host configuration and port is that how it comes to know? I am just trying to understand if request A comes to listener how would listener know which Oracle instance to route the traffic to?

2. When I do sqlplus / as sysdba how does it know which Oracle instance to connect to?

This post has been answered by Marco Gralike on Jun 8 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2009

Added on Jun 8 2009

#general-database-discussions

36 comments

1,861 views