ORA-12505 Errors and solutions when JDBC connects to Oracle databases

Oracle Problem Description: The following error occurred while using JDBC to connect to the Oracle database: Connection refused (description= (tmp=) (vsnnum=153093120) (err=12505) (Error _stack= (Error= (code=12505) (emfi=4)))

and directly through the Sqlplus or Toad can connect the database, after the debug and find the relevant data to find the cause of the problem is as follows:

When JDBC connects to the database, it needs to use the sid_name of the database rather than the services_name of the database and use Plsql to connect the database, only the services_name of the database is required, so modify the Services_ in the connection string Name is Sid_name

View the current sid:sql> Select instance_name from v$instance in the database;

Turn from: http://www.blogjava.net/itspy/archive/2007/12/20/169072.html