Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

sandeep.cNov 5 2013 — edited Nov 5 2013

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.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 3 2013
Added on Nov 5 2013
13 comments
14,677 views