----- Original Message -----
Sent: Wednesday, September 18, 2002 11:48
AM
Subject: Re: Listener load balance
I do not know if you can know which connection
the user use.
However, these changes apply only to the initial
connection.
After the user connect he gets a new port number that
connect
directly to his thread, so I would not worry about the
load
on the listener.
You can use a different tnsnames for each half of you
company,
One that use the current IP address and one that use the
new one.
This way you can be sure that the load is spread through
both cards.
Yechiel Adar
Mehish
----- Original Message -----
Sent: Wednesday, September 18, 2002
5:33 PM
Subject: Re: Listener load
balance
TKS Yechiel for your help,
Two more questions.
Is there any way I can find out which one of the 2
addresses I am using ?
Which is better solution this method or add another
listener ?
Tks for your help
TIA
Ramon
----- Original Message -----
Sent: Wednesday, September 18, 2002
4:09 AM
Subject: Re: Listener load
balance
Hello Ramon
I think that you have an error in your
parameters.
As far as I know (not much) the second network card
have a different TCP/IP address.
You have to put this address in the added line in
listener.ora and add (load_balance=on).
(ADDRESS_LIST
=
(load_balance=on)
(ADDRESS =
(PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
---> Original
(ADDRESS = (PROTOCOL = TCP)(HOST = new network card address)(PORT =
1526)) ---> Added
)
In the tnsnames you have to use load_balance=on
and put both addresses and ports in the address
list:
(description=
(address list=
(load_balance=on)
(address=(protocol=TCP,host=225.125.110.5,port=1521))
(address=(protocol=TCP,host=new network
card address,port=1526))
This way the clients will use both address.
Yechiel Adar
Mehish
----- Original Message -----
Sent: Tuesday, September 17, 2002
10:19 PM
Subject: Re: Listener load
balance
Tks Kevin,
I didn't setup the DNS to do that. I ping
myserver and is using the new address. Don't know how to do it
either.
What I am planning to do is to set the manually
the ip address to the both port. I am using local
names.
(ADDRESS =
(PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521))
---> Original
(ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT =
1526)) ---> Added
Ramon
----- Original Message -----
Sent: Tuesday, September 17, 2002
12:03 PM
Subject: RE: Listener load
balance
Your HOSTNAME of 'myserver' would tell you
which.
Since you have the same hostname on the listener, both ports
would currently be using the same IP address.
Did you setup DNS so that the cards share a Hostname
?
Hi list,
Scenario Win2000 server, 8.1.7.
I added a network card to my DB Server.
I want the listener to accept connections for the 2 IP address to
make load balance. I just added a line to the listener file
with a different port.
How can I assure that the port 1521 is listening
for the net address 01 and the port 1526 in the address 02
?
Is that correct ?
-----------------------
LISTENER =
(DESCRIPTION_LIST
=
(DESCRIPTION
=
(ADDRESS_LIST
=
(ADDRESS = (PROTOCOL
= IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST
=
(ADDRESS = (PROTOCOL
= TCP)(HOST = myserver)(PORT = 1521))
---> Original
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT =
1526)) ---> Added
)
)
(DESCRIPTION
=
(PROTOCOL_STACK
=
(PRESENTATION =
GIOP)
(SESSION =
RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST
= myserver)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST
=
(SID_DESC
=
(SID_NAME =
PLSExtProc)
(ORACLE_HOME =
C:\Oracle\Ora8I)
(PROGRAM =
extproc)
)
(SID_DESC
=
(GLOBAL_DBNAME =
ORCL)
(ORACLE_HOME =
C:\Oracle\Ora8I)
(SID_NAME =
ORCL)
)
)
----------------------------
TIA,