Try to do tnsping and see if you can hit your destination if not then there is something wrong with your tnsname.ora file. Remove db service entry from tnsname.ora file and recreate using Net8 assistant GUI tool and also make sure that you don’t have more then one oracle home.