Oracle SQL Developer Connection error (ORA-12505)
I had a problem with my Oracle database, and I finally got it done. Today I have created another DBA administrator connection method, and I will share my solution with you, I hope it will be useful to you. Connection error code: Listener refused the connection with following error: ORA-12505, TNS: listener ...... confirm that this is the SID error connecting to the database. Solution: 1. know your SID Name: You can search in the registry, or you can use the sqlplus tool of Oracle and run the command as an administrator to view: select instance_name from v $ instance; it must be an administrator; otherwise, the view does not exist ". 2. on the Oracle SQL Developer Connection Tool, modify the SID Name of your database, as shown in the following figure (Change "xe" to "orcl"): 3. select "Save command" and "role" and select database administrator. 4. Click "save" and "test" and connect. The connection is successful.
If not! You have to modify the listening file.