Operating System - HP-UX
1748166 Members
3848 Online
108758 Solutions
New Discussion юеВ

Re: Oracle Listener and multi-homing query

 
SOLVED
Go to solution
KapilRaj
Honored Contributor

Oracle Listener and multi-homing query

Guys,

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
Nothing is impossible
18 REPLIES 18
Joseph Loo
Honored Contributor

Re: Oracle Listener and multi-homing query

hi,

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_ = 0 among others.

hope that explains.

regards.
what you do not see does not mean you should not believe
Rita C Workman
Honored Contributor

Re: Oracle Listener and multi-homing query

Well I'm no Oracle guru, so hopefully some Oracle whiz will correct me if I err-too far.

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
Joseph Loo
Honored Contributor

Re: Oracle Listener and multi-homing query

rita, guess you say the magic word, 'big' which is why it should be run during a lull (non-peak) period. if the batch job gets too 'big', there may be a need to re-look the script and see if any improvement may be make to tune the statement/s or whether the table structure need modification, i.e. indexes.

regards.
what you do not see does not mean you should not believe
KapilRaj
Honored Contributor

Re: Oracle Listener and multi-homing query

Joseph Loo,
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
Nothing is impossible
Jean-Luc Oudart
Honored Contributor

Re: Oracle Listener and multi-homing query

Kaps,

if your batch processing and database are on same node you should use the BEQ protocol and bypass the TCP overhead.

Regards,
Jean-Luc
fiat lux
KapilRaj
Honored Contributor

Re: Oracle Listener and multi-homing query

Is it diffrent from tns ?. If yes , I can not go for it as my standards says I should always use tns !

Regds,

Kaps
Nothing is impossible
Nicolas Dumeige
Esteemed Contributor

Re: Oracle Listener and multi-homing query

Same tnsnames.ora just change the PROTOCOL.

Cheers

Nicolas
All different, all Unix
KapilRaj
Honored Contributor

Re: Oracle Listener and multi-homing query

Can u explain why and how it is better than TCP in my scenario ?

Kaps
Nothing is impossible
Jean-Luc Oudart
Honored Contributor

Re: Oracle Listener and multi-homing query

Kaps

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 = )(PORT = 1521))
)
)
)

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
fiat lux