I can connect to remote oracle database using sqlplus but using the same tsnnames.ora file and the same username and password and all information as with sqlplus, I cannot connect using sql developer. Is there some special thing I should be doing that I am missing? When I connect using sqlplus I followed username@ORCL and password@SID and that worked. Using same tnsnames.ora and credentials did not work with SQL Developer, neither did leaving off the @ORCL and/or @SID. Is there something else I am missing? I haven't yet found anything, but it took me some time to realize I needed to use @ORCL and @SID to connect using sqlplus.
I get a Test failed: Listener refused ORA-12505 TNS:listener does not know of SID give.