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

I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following 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
    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.jlcindia.jdbc.JDBCUtil.geOracleConnection(JDBCUtil.java:28)
    at Lab3O.main(Lab3O.java:15)
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
    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
    ... 8 more

Related Posts:

  1. No more data to read from socket error
  2. SQL error “ORA-01722: invalid number”
  3. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  4. QL Error: ORA-00933: SQL command not properly ended
  5. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  6. ORA-28040: No matching authentication protocol exception
  7. SQL Error: ORA-00942 table or view does not exist
  8. ORA-00984: column not allowed here [duplicate]
  9. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  10. How to resolve ORA 00936 Missing Expression Error?
  11. SQL not a single-group group function
  12. PLS-00201 – identifier must be declared
  13. issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
  14. ORA-30926: unable to get a stable set of rows in the source tables
  15. PLS-00103: Encountered the symbol “CREATE”
  16. Oracle client ORA-12541: TNS:no listener
  17. SQL error “ORA-01722: invalid number”
  18. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  19. ORA-12899: value too large for column
  20. Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
  21. Oracle date format picture ends before converting entire input string
  22. SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  23. SQL Error: ORA-00913: too many values
  24. UTL_FILE.FOPEN() procedure not accepting path for directory?
  25. ORA-01653: unable to extend table by in tablespace ORA-06512
  26. SQL Error: ORA-01861: literal does not match format string 01861
  27. ORA-28001: The password has expired
  28. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  29. Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
  30. sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
  31. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  32. ORA-01747: invalid user.table.column, table.column, or column specification
  33. SQL Queries “00904. 00000 – “%s: invalid identifier”
  34. How to display databases in Oracle 11g using SQL*Plus
  35. grant select on view
  36. Hibernate dialect for Oracle Database 11g?
  37. Query to display all tablespaces in a database and datafiles
  38. ‘NOT LIKE’ in an SQL query
  39. ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
  40. How can I set a custom date time format in Oracle SQL Developer?
  41. How to copy files into a virtual box oracle box
  42. Find out the history of SQL queries
  43. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  44. how to fix oracle ORA-01722 invalid number error
  45. ORA-00979 not a group by expression
  46. error: ORA-65096: invalid common user or role name in oracle
  47. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  48. ORA-00918: column ambiguously defined in SELECT *
  49. Oracle error : ORA-00905: Missing keyword
  50. What does SQL Select symbol || mean?
  51. How do I limit the number of rows returned by an Oracle query after ordering?
  52. Can a foreign key be NULL and/or duplicate?
  53. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  54. ORA-12560: TNS:protocol adaptor error
  55. ORA-00972 identifier is too long alias column name
  56. What does the following Oracle error mean: invalid column index
  57. java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
  58. PLS-00103: Encountered the symbol when expecting one of the following:
  59. DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704
  60. ORA-00918: column ambiguously defined in SELECT *
  61. ORA-00918: column ambiguously defined in SELECT *
  62. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  63. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  64. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  65. Is there a combination of “LIKE” and “IN” in SQL?
  66. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  67. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  68. How do you create a temporary table in an Oracle database?
  69. Oracle “Partition By” Keyword
  70. ResultSet exception – before start of result set
  71. Oracle SQL: Update a table with data from another table
  72. PCI\VEN_10EC&DEV_522A&SUBSYS_837D103C&REV_01
  73. Oracle SQL query for Date format
  74. How to execute an oracle stored procedure?
  75. What is the Oracle equivalent of SQL Server’s IsNull() function?
  76. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  77. IO Error: The Network Adapter could not establish the connection
  78. ClassNotFoundException – com.microsoft.jdbc.sqlserver.SQLServerDriver
  79. How SID is different from Service name in Oracle tnsnames.ora
  80. java.sql.SQLException: No database selected – why?
  81. SQL selecting rows by most recent date with two unique columns
  82. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  83. Comparing Dates in Oracle SQL
  84. Convert timestamp to date in Oracle SQL
  85. How do I reset a sequence in Oracle?
  86. How do I get the size of a java.sql.ResultSet?
  87. SQL Error: 0, SQLState: 08S01 Communications link failure
  88. Cannot issue data manipulation statements with executeQuery()
  89. Update statement with inner join on Oracle
  90. What kind of Java type is “[B”?
  91. What does java:comp/env/ do?
  92. JPA or JDBC, how are they different?
  93. How do I use CREATE OR REPLACE?
  94. Oracle: If Table Exists
  95. DATEDIFF function in Oracle
  96. How to create id with AUTO_INCREMENT on Oracle?
  97. What is the difference between Views and Materialized Views in Oracle?
  98. ORA-01735: invalid ALTER TABLE option – Toad
  99. PLS-00049 bad bind variable While using :OLD
  100. Run Oracle SQL script and exit from sqlplus.exe via command prompt

Leave a Comment

tech