not able to connect with 10g

[Inder Kumar Rathore]

hi I am connecting oracle 10 g but I am not able to connect..
It gives exception java.sql.SQLException

import java.sql.*;
public class OracleConnectionUrl {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Load the Oracle JDBC driver
   Class.forName("oracle.jdbc.OracleDriver") ;
   System.out.println("Oracle JDBC driver loaded ok.");
   con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","mushi");
   System.out.println("Connected with @localhost:1521:orcl");
      

    } catch (Exception e) {
      System.err.println("Exception: "+e);
    }
  }
}

this is my consoles output

E:\Prgm\Rathore>java OracleConnectionUrl
Oracle JDBC driver loaded ok.
Exception: java.sql.SQLException: Listener refused the connection with the follo
wing error:
ORA-12505, TNS:listener does not currently know of SID given in connect descript
or
The Connection descriptor used by the client was:
localhost:1521: orcl

also I am not good in oracle...
please suggest some points.....
thanks

[Ninad Kulkarni]

Look for following file in your system
"AccordingToYourOracle10gPath"\network\admin\tnsnames.ora file
In that you will find service name which is your SID created by oracle configuration tool.
Depending on Oracle version and JDK version you will need appropriate JDBC driver if you don't have.

[Inder Kumar Rathore]

This is my tnsnames.ora file..

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCLE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcle)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Instead of using type 4 driver I used type 1 driver that is jdbc-odbc bridge, and the connection was established by crating a dsn ("mushi") and using same username and passowrd...

here I'll send my my source code...

 import java.sql.*;
public class OracleConnectionUrl {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Load the Oracle JDBC driver
   Class.forName("oracle.jdbc.OracleDriver") ;
   System.out.println("Oracle JDBC driver loaded ok.");
   con = DriverManager.getConnection("jdbc:odbc:mushi","system","mushi");
   System.out.println("Connected");
      

    } catch (Exception e) {
      System.err.println("Exception: "+e);
    }
  }
}
   

[Inder Kumar Rathore]

still not abel to connect...