Monday 3 August 2015

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

Fix ORA-12505 in SQL Developer

  1. Open Net Manager. In Oracle Net Configuration, open Local, and then, open Listeners.
  2. Select your Listener.
  3. In the upper right Combo Box, select Database Services.
  4. Click Add Database.
  5. Fill the 3 fields: Global Database Name (i.e. ORACLE8. In SQL Plus type SELECT * FROM GLOBAL_NAME), Oracle Home Directory (i.e. C:\app\User\product\11.2.0\dbhome_1) and SID (i.e. orcl)
  6. File > Save Network Configuration.
  7. Restart the OracleOraDb11g_home1TNSListener service.
Comment below if you face any issues.

No comments :

Post a Comment