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

by

I fixed this issue by correcting my jdbc string.

For example, the correct jdbc string should be…

jdbc:oracle:thin:@myserver:1521/XE

But the jdbs string I was using is …

jdbc:oracle:thin:@myserver:1521:XE

(Note: between 1521 and XE should be a /)

This bad jdbc string give me a ORA-12505 error too.

More Related Contents:

  1. No more data to read from socket error
  2. Oracle JDBC ojdbc6 Jar as a Maven Dependency
  3. ORA-01882: timezone region not found
  4. Fetch Oracle table type from stored procedure using JDBC
  5. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  6. Oracle JDBC and Oracle CHAR data type
  7. Default Schema in Oracle Connection URL
  8. URL string format for connecting to Oracle database with JDBC
  9. NLS_LANG setting for JDBC thin driver?
  10. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  11. How to change default nls_date_format for oracle jdbc client
  12. What is the difference between varchar and varchar2 in Oracle?
  13. How to enable logging for SQL statements when using JDBC
  14. Passing an array of data as an input parameter to an Oracle procedure
  15. Difference between Oracle jdbc driver classes?
  16. Split function in oracle to comma separated values with automatic sequence
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. How to handle to_date exceptions in a SELECT statment to ignore those rows?
  19. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  20. Call an Oracle function from Java
  21. Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)
  22. HIbernate issue with Oracle Trigger for generating id from a sequence
  23. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  24. error: ORA-65096: invalid common user or role name in Oracle database
  25. Using Alias in query resulting in “command not properly ended”
  26. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  27. How to insert a column in a specific position in oracle without dropping and recreating the table?
  28. Get the LENGTH of a LONG RAW
  29. MySQL equivalent of ORACLES rank()
  30. Oracle: Days between two date and Exclude weekdays how to handle negative numbers

Leave a Comment