Solution to Oracle10G ORA-12505 Problems

Today, when I am developing a project about **, I am using PLSQL to connect to Oracle. However, in Myeclipse DB's attempt, the url I have been using is the following code:

1. Jdbc: oracle: thin:127. 0.0.1:1521: Jdbh

The following error message always appears:

1. Java. SQL. SQLException: Listener refused the connection with the following error:
3. <Span style ="Color: # ff0000 ;"> ORA-12505, TNS: listener does not currently know of SID given in connect descriptor
5. TheConnection descriptor used by the client was:
7. Localhost:1521: Jdbh
8. </Span>
9. Atoracle. jdbc. driver. DatabaseError. throwSqlException (DatabaseError. java:124)
11. Atoracle. jdbc. driver. DatabaseError. throwSqlException (DatabaseError. java:279)
13. Atoracle. jdbc. driver. T4CConnection. logon (T4CConnection. java:318)
15. Atoracle. jdbc. driver. PhysicalConnection. <init> (PhysicalConnection. java:343)
17. Atoracle. jdbc. driver. T4CConnection. <init> (T4CConnection. java:147)
19. At oracle. jdbc. driver. T4CDriverExtension. getConnection (T4CDriverExtension. java:31)
21. Atoracle. jdbc. driver. OracleDriver. connect (OracleDriver. java:545)
23. Atjava. SQL. DriverManager. getConnection (Unknown Source)
25. Atjava. SQL. DriverManager. getConnection (Unknown Source)
27. At cn.com. db. DBAccess. getConnection (DBAccess. java:33)
29. At cn.com. db. DBAccess. main (DBAccess. java:95)

I have read some materials on the Internet and have not mentioned the specific solution. My personal summary is as follows:

Solution:

Open the tnsnames. ora file in the path D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN to view the following code:

1. # Tnsnames. ora Network Configuration File: D: \ oracle \ product \10.2.0\ Db_1 \ network \ admin \ tnsnames. ora
2. # Generated by Oracle configuration tools.
4. ORCL =
5. (DESCRIPTION =
6. (ADDRESS = (PROTOCOL = TCP) (HOST = RedArmychen-PC) (PORT =1521))
7. (CONNECT_DATA =
8. (SERVER = DEDICATED)
9. <Span style ="Color: # ff0000 ;"> (SERVICE_NAME = orcl)
10. </Span>)
11. )
13. EXTPROC_CONNECTION_DATA =
14. (DESCRIPTION =
15. (ADDRESS_LIST =
16. (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
17. )
18. (CONNECT_DATA =
19. (SID = PLSExtProc)
20. (PRESENTATION = RO)
21. )
22. )

Do you see my standard red font?(SERVICE_NAME = orcl)Then you only need to modify the connection URL:

1. Jdbc: oracle: thin:127. 0.0.1:1521: Orcl

The problem can be solved. This is only a solution for personal errors! If there are any exceptions, please be patient.