If Oracle is not connecting from remote machine then in listener.ora file add one more listener apart from localhost (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<HOST NAME or NIC IP>)(PORT=1521))) If it is not connected after this then check firewall.