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 -> JDBC Connection problem ORA-12505 SID does not exist

JDBC Connection problem ORA-12505 SID does not exist

From: <brent.ryan_at_gmail.com>
Date: 8 May 2006 13:02:57 -0700
Message-ID: <1147118577.608410.90030@i40g2000cwc.googlegroups.com>


I have a problem with a java application connecting to a test Oracle DB and everything works fine. However, once we were ready to move to production I changed the database URL and SID to connect to the new database and I get an error. Below are the configurations that I changed in my properties file and the error that was received from the TNS listener.

OLD
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@host:1521:h8sontst

NEW
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@new_host:1521:h8sontst

Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS=(HOST=new_host)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=h8sontst)))

I can connect using sqlplus with no issues from that server. Please help if you have any ideas? Both the test server and production server are running the same version of Oracle. Received on Mon May 08 2006 - 15:02:57 CDT

Original text of this message

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