When I tried to connect my remote database through tnsname.ora. In New/Select Database Connection screen, I choose connection type "TNS" and Role as "default" and I select one network from
"Network Alias" drop down list. And in the top put my connection name and correct username/password. But when I hit "Connect" button, it failed. Error:Status: Failure- Test failed: SO Eexception was generated. Could you help me to fix this? Thanks.
What version of SQL Developer are you using?
What does the relevant section of your TNSNAMES file?
Do you have other databases you can try to connecting to? Do they show the same error.
I can see hints elsewhere that this is a syntax error in the JDBC connection string. It isn't specific to SQL Developer or even Oracle JDBC. No one seemed to have an answer for any the questions that I found by googling.
As a workaround you could use a basic connection and extract the host, port , sid/service entries from the tnsnames.ora