Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC Connection problem ORA-12505 SID does not exist

Re: JDBC Connection problem ORA-12505 SID does not exist

From: brent <brent.ryan_at_gmail.com>
Date: 9 May 2006 11:04:04 -0700
Message-ID: <1147197844.069589.222610@v46g2000cwv.googlegroups.com> 





I actually just found out that they're running a Oracle RAC environment
so my JDBC url needs to look like this for it to work.



url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=myhost1.edu)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=myhost2.edu)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=h8sontst)))



Thanks for everyones help.
Received on Tue May 09 2006 - 13:04:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US