- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Listener and multi-homing query
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2004 11:32 PM
тАО04-28-2004 11:32 PM
I have a multihomed Node which currently hosts the Database as well as runs it's batch processing.
There are three listeners configured on 3 diffrent adapters.
ETH-1 10 Mbps listener_a
ETH-2 100 Mbps listener_b
ETH-3 1000 Mbps listener_c
The batch processing jobs use TNS to connect to the database. And they are currently using listener_a i.e. the 10 Mbps one.
Is there any advantage of making a tnsnames.ora change so that connections are going through listener_c i.e. 1000 Mbps ?.
If I do this, Am I gonna get a better response for oracle sessions ?.
Regds,
Kaps
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 12:30 AM
тАО04-29-2004 12:30 AM
Re: Oracle Listener and multi-homing query
What is the network backbone, i.e. gigabits at your environment and the network point you are connecting for the gigabits card?
If the network point is on gigabit, the throughput would most definitely be higher than what the 10Mbps could reach. However if your network point is a 10Mbps, the gigabit card would only reach that much.
As for Oracle sessions, there are too many varied on better response. Establishing faster oracle connections may also be set at the listener.ora, STARTUP_WAIT_TIME_
hope that explains.
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 12:34 AM
тАО04-29-2004 12:34 AM
Re: Oracle Listener and multi-homing query
We run Oracle, and we only have 1 listener running last time I checked. We run the big batch jobs at night and only do small things during the day so as to leave the major resources to the end user (we're a biger on read only/querries).
With that said...I guess the obvious is what comes to mind....will you get better response on a 1000Mb connection from a 10Mb connection ?..Yeah you should! Otherwise we'd all still be using 10Mb cards. As long as your ports & lan cards are configured accordingly...Yeah...
Rgrds,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 12:49 AM
тАО04-29-2004 12:49 AM
Re: Oracle Listener and multi-homing query
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 01:04 AM
тАО04-29-2004 01:04 AM
Re: Oracle Listener and multi-homing query
We have diffrent Networks for diff functions,
1. The internal N/W which runs at 10Mbps we use for node-node system check scripts etc.
2. External N/W runs at 100 Mbps used for online access for users.
3. Backend N/W == 1000 Mbps, we use for oracle connections , NFS mounts etc.
If the batch processing and database was running on diffrent nodes, I would have choosen the eth-3 which gives me a better speed, but here every thing is on the same node. And I have a doubt.
Rita,
Nice to see you after a long time (?!). I can understand ur statement 10 Mbps would get a better response but I have batch processing and database on the same node !.
Is it that a TCP packet size depends on the interface speed ?. (Wild guess)
Mates ... I need more info !
Regds,
Kaps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 01:10 AM
тАО04-29-2004 01:10 AM
Re: Oracle Listener and multi-homing query
if your batch processing and database are on same node you should use the BEQ protocol and bypass the TCP overhead.
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 01:20 AM
тАО04-29-2004 01:20 AM
Re: Oracle Listener and multi-homing query
Regds,
Kaps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 01:22 AM
тАО04-29-2004 01:22 AM
Re: Oracle Listener and multi-homing query
Cheers
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 01:26 AM
тАО04-29-2004 01:26 AM
Re: Oracle Listener and multi-homing query
Kaps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 01:33 AM
тАО04-29-2004 01:33 AM
Re: Oracle Listener and multi-homing query
your listener.ora should look like :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = TCP)(HOST =
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME =
(ORACLE_HOME = /oracle/product/8.1.7)
)
)
the connection should be done as connect user/passwd and not user/passwd@
unset TWO_TASK variable if set
Regards,
Jean-Luc