Fix ORA-12505 in SQL Developer
- Open Net Manager. In Oracle Net Configuration, open Local, and then, open Listeners.
- Select your Listener.
- In the upper right Combo Box, select Database Services.
- Click Add Database.
- 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)
- File > Save Network Configuration.
- Restart the OracleOraDb11g_home1TNSListener service.
Comment below if you face any issues.
No comments :
Post a Comment