Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 522 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 490 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 128 Programming Languages
- 289.9K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 260 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Each schema on separate listener
Answers
-
So it is possible and how would you do that? Is there official oracle documentation for this?
-
Catinredboots wrote:Application team would like to have different application server connect to a different port number per schema, it is for some kind of testing. Thanks everyone for you explanation, it looks like it is not possible and I will tell them know that they will need a separate database for each one.
There is ZERO relationship between listener port# and any particular schema!
It is 100% daft to try to relate port# & schema name!
-
Catinredboots wrote:So it is possible and how would you do that? Is there official oracle documentation for this?
create as many listener you need. each one on different port. then on each application connection string put a different port in order to contact the desired listener.
-
Well, that's a strange requirement, as it really does not make any sense, because LOGICALLY you are still working with the same database etc.
The behaviour you WISH to have I think is
https://docs.oracle.com/cd/B28359_01/server.111/b28310/create007.htm#ADMIN11125
If you really wish to have different ports, just specify different listeners in the listener.ora:
LISTENER_1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
)
LISTENER_2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1522))
)
)
LISTENER_3 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1523))
)
)
and start them separately
lsnrctl start listener_1
lsnrctl start listener_2
lsnrctl start listener_3
-
JuanM wrote:Catinredboots wrote:So it is possible and how would you do that? Is there official oracle documentation for this? create as many listener you need. each one on different port. then on each application connection string put a different port in order to contact the desired listener.
JuanM,
Why are you trying to teach the OP how to run with scissors? And what you suggest still does not achieve her objective.
Your proposed multiple listeners all service the same database. There is nothing, zero, zilch, nada, null to prevent any user from using any of the listeners (on their individual ports) to connect to any schema in that database. This is even worse, and more pointless than simply trying to have a different listener for each of multiple databases.
============================================================================
Please stay after school and write the following sentence 100 times:
One single listener, using the default name of LISTENER and the default port of 1521, is quite capable of -- indeed, WAS DESIGNED TO -- service multiple databases of multiple versions running from multiple homes. Multiple listeners simply adds complications, and for no gain whatsoever.
============================================================================
And since I expected better of you, after you have finished, clean the blackboard and do it again.
-
Why would you run all those listeners? Just do this,
listener=(description=(address_list=(
(address=(protocol=tcp)(host=qwe)(port=1521))
(address=(protocol=tcp)(host=qwe)(port=1522))
(address=(protocol=tcp)(host=qwe)(port=1523))))
-
Catinredboots wrote:So it is possible and how would you do that? Is there official oracle documentation for this?
In spite of what JuanM said, it is not possible.
Why are you avoiding the obvious and repeated question of why you want to do this and what you think it will achieve?
-
JohnWatson2 wrote:Why would you run all those listeners? Just do this,listener=(description=(address_list=((address=(protocol=tcp)(host=qwe)(port=1521))(address=(protocol=tcp)(host=qwe)(port=1522))(address=(protocol=tcp)(host=qwe)(port=1523))))
how does above meet OP's requirement below for separate schema on each port?
>Is it possible to have each schema on separate listener so each schema will be accessed from different port?
-
Catinredboots, what your developers seem to want is not actually possible nor would it be beneficial. Normally, the listener is only used to make the initial connection to Oracle and every session is assigned its own port for communication with Oracle.
- -
What platform are you on (OS version) and what full version of Oracle is in use?
- -
HTH -- Mark D Powell --
-
Linux Red Hat 7, Oracle 12.1
