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

by

You need to add the SID entry for XE in order to register the instance with the listener.

After installation of Oracle XE, everything looks good, but when you issue 

C:\>sqlplus / as sysdba
SQL>shutdown immediate
SQL>startup

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

the instance will not register with the listener.

So please edit your listener.ora like this: 

SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
       (SID_NAME = XE)
       (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
     )
     (SID_DESC =
        (SID_NAME = PLSExtProc)
        (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
        (PROGRAM = extproc)
     )
     (SID_DESC =
       (SID_NAME = CLRExtProc)
       (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
       (PROGRAM = extproc)
     )
  )

This issue came up when I installed Oracle XE on Windows 7. I did not face this problem on Windows XP. In general, this entry should not be necessary, because the instance should register with the listener automatically. Running Oracle XE on Linux (Fedora), there is no need to add XE to the sid-list.

More Related Contents:

  1. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  2. No more data to read from socket error
  3. Oracle JDBC ojdbc6 Jar as a Maven Dependency
  4. ORA-01882: timezone region not found
  5. Fetch Oracle table type from stored procedure using JDBC
  6. Oracle client ORA-12541: TNS:no listener [closed]
  7. Oracle JDBC and Oracle CHAR data type
  8. Default Schema in Oracle Connection URL
  9. URL string format for connecting to Oracle database with JDBC
  10. NLS_LANG setting for JDBC thin driver?
  11. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  12. How to change default nls_date_format for oracle jdbc client
  13. How to Register Pluggable Database(PDB) with new created LISTENER
  14. Printing the value of a variable in SQL Developer
  15. Passing an array of data as an input parameter to an Oracle procedure
  16. What is the difference between “AS” and “IS” in an Oracle stored procedure?
  17. Boolean Field in Oracle
  18. Split function in oracle to comma separated values with automatic sequence
  19. ORA-06508: PL/SQL: could not find program unit being called
  20. How to handle to_date exceptions in a SELECT statment to ignore those rows?
  21. Call an Oracle function from Java
  22. Using Alias in query resulting in “command not properly ended”
  23. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  24. How to insert a column in a specific position in oracle without dropping and recreating the table?
  25. Is it possible to kill a single query in oracle without killing the session?
  26. Get the LENGTH of a LONG RAW
  27. Reading clob line by line with pl\sql
  28. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  29. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  30. Grant Select on all Tables Owned By Specific User

Leave a Comment