Hello Everybody,.
I would like to know,what am I missing here...
I have the following Java code
/**
* Connect to Oracle Database.
*/
private static void oracleConnect() {
Connection conn = null;
try {
//Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "scott",
"Scott123");
System.out.println("Connected to the Oracle database...");
} /*catch (ClassNotFoundException e) {
e.printStackTrace();
} */catch (SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
System.out.println("Connection closed...");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Exception:
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
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.facebook.www.javagroup.GenericTaskInterpreter.oracleConnect(GenericTaskInterpreter.java:53)
at com.facebook.www.javagroup.GenericTaskInterpreter.main(GenericTaskInterpreter.java:27)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
All my oracle services are running fine and I am also able to login as user scott.My Oracle version is: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Any help would be appreciated.Thanks in advance.