Home » Server Options » RAC & Failsafe » JDBC Connection to RAC
JDBC Connection to RAC [message #270600] Thu, 27 September 2007 11:18 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
I have a 2 node RAC configuration. The instances are called test1 and test2 and the service name is testdb

Issues in connection is

jdbc:oracle:thin:@//test101:1521/test1

jdbc:oracle:thin:@//test102:1521/test2

Following string works...
jdbc:oracle:thin:@//test101:1521/testdb

What is the difference and they claim first 2 also use to work..
Re: JDBC Connection to RAC [message #270612 is a reply to message #270600] Thu, 27 September 2007 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first 2 connect to a specific instance.
The latter one connects to a service so to one instance or the other one depending on load (if you configure load balancing) and/or availability (if you configure fail over).
In this case you don't choose the instance, Oracle does it for you.

Regards
Michel
Re: JDBC Connection to RAC [message #270614 is a reply to message #270612] Thu, 27 September 2007 11:47 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
Why the first 2 is not working??

Re: JDBC Connection to RAC [message #270616 is a reply to message #270614] Thu, 27 September 2007 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Listener is not configure to work with SID just SERVICE_NAME.

Regards
Michel
Re: JDBC Connection to RAC [message #270618 is a reply to message #270616] Thu, 27 September 2007 11:56 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
Following is my listener entry.

It was working 4 days back.. and suddenly stopped working

LISTENER_TEST1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test101)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = test1)
(ORACLE_HOME = /test/app/oracle/product/9.2)
)
)

LISTENER_TEST2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test102)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = test2)
(ORACLE_HOME = /test/app/oracle/product/9.2)
)
)

Re: JDBC Connection to RAC [message #270634 is a reply to message #270618] Thu, 27 September 2007 12:45 Go to previous message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Something surely changes as you don't have a listener listening on service name, you should not be able to connect with it.
Check "lsnrctl services" and "lsnrctl status" for all listeners.
Check "tnsping" for all targets.
Post tnsnames.ora.

Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.


Regards
Michel

[Updated on: Thu, 27 September 2007 12:46]

Report message to a moderator

Previous Topic: best storage
Next Topic: installing Oracle database 10.2 on RHEL AS/ES 4
Goto Forum:
  


Current Time: Mon Oct 20 05:20:40 CDT 2014

Total time taken to generate the page: 0.08206 seconds