Oracle SQL Developer Connection error (ORA-12505), developerora-12505

Oracle SQL Developer Connection error (ORA-12505), developerora-12505

 

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 ......

Are you sure 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. Modify the SID Name of your database on the Oracle SQL Developer Connection Tool, 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! Then you have to modify the listening file, see: http://blog.csdn.net/yangwenxue_admin/article/details/44501365