listener as bottleneck on RAC?

[ckiltz]

Hello *,

global topic: configuration connection load balancing on Oracle RAC with two nodes

Oracle 10.2.0.1 RAC with two nodes

the service is configured as "prefered" on node 2/instance 2 and "available" on node 1/instance1

the listener on node 2 is set offline (for testing)
the listener on node 1 is running
both instances on node 1 and two are running

when I try to connect via the service, I got the response that the listener is not running

is this the normal behavior?

can I configure the first listener on node 1 to connect to instance 2 as well?
and the first second listener on node 2 to connect to instance 1 as well?

Thank you reading an anwering!

Christian

[jhmartin]

What does your tnsnames.ora entry look like for that setup?

[ckiltz]

What does your tnsnames.ora entry look like for that setup?

# Error message while listener of node two is offline

An error occured while establishing the connection.
Type: java.sql.SQLException Error Code: 0
Message:
Listener refused the connection with the following error:
ORA-12520, TNS:listener could not find available handler for requested
type of server
The Connection descriptor used by the client was:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.65)(PORT =
1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.66)(PORT = 1521))
(LOAD_BALANCE = off) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= a_user)))

# lsnrctl services (node 1)

Service "a_user" has 1 instance(s).
Instance "inst2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:137 refused:0 state:ready
LOCAL SERVER

# tnsnames.ora

A_USER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.65)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.66)(PORT = 1521))
(LOAD_BALANCE = OFF)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = a_user)
(failover_mode =
(type=session)
(method=basic)
(retries=7)
(delay=2)
)
)
)

[ixion]

I think you need to set up taf for this to work. IE your testing an outage scenario, where you've configured load ballancing.