| JDBC Connection to RAC [message #270600] |
Thu, 27 September 2007 11:18  |
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 #270618 is a reply to message #270616] |
Thu, 27 September 2007 11:56  |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
