Q
Problem solve Get help with specific problems with your technologies, process and projects.

Configure two listeners without RAC in Oracle

Is it possible (without application of RAC or parallel servers) in Oracle 9i database to configure two listeners?

Hi Bill. Is it possible (without application of RAC or parallel servers) in Oracle 9i database to configure two listeners, say listner1 and listner2, with different port numbers say, 1521 and 1526, and connect one group of end users via listner1 and others via listner2?
Yes, you may have multiple listeners for the same instance listening on different ports. You can define them in the same listener.ora file. You will have to create different connection strings for the same instance in the tnsnames.ora file and use this as the reference to have your clients connect to the instance you prefer.

Here is some detail on configuration.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close