oracle connection

[Former Member]

Hi,

I'm using ojdbc14.jar to connect oracle 10g database with parameters below:

JDBC Driver --> oracle.jdbc.driver.OracleDriver

ServerURL --> jdbc:oracle:thin:@10.242.10.11:1521:orcl

It does not connect.

I tryed to coonect with java code using ojdbc14.jar it generates error below

error

java.sql.SQLException: 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:

10.242.10.11:1521:orcl

Is it necessary to install oracle client on MII server?

Thanks

[Former Member · Accepted solution]

Cemil,

I hope you have copied the required driver.You used 10.242.10.11:1521:orcl

Check lsnrctl status on your database server, if SID registered by listener is really orcl,I think it is alias not SID.

Check the below link

-Suresh

Edited by: Suresh Hiremath on Jul 17, 2009 7:52 AM

[Former Member]

To Identify the problem - Download the java based SQL Client. (Squirrel-SQL).

Try to connect with same driver and parameters... that will give you the answer... where is the issue.

- Vikas

[Former Member]

Oracle client is not a requirement.(Both 11.5 & 12.0)

Is this 12.0?

Assuming you uploaded and deployed the driver successfully , instead of using java why don't you look at the Netweaver logs and that would give you a clearer picture as to why the connection is erring out.

Goodluck!