The install went fine. I can connect when I use Start>Oracle XE>Run SQL Command Line, however, I cannot connect when using a third party client.
Running tnsping xe or lsnrctl status also shows things in a failed state.
I think the solution has to do with some funky networking stuff where sometimes I’m VPN-ed into a work network and sometimes not. If I execute the hostname command I see MyMachine. If I ping localhost I see the full dns name, MyMachine.region.mycorp.net. But If I ping the full dns name, it is not found.
Solution:
Update the network/ADMIN/tnsnames.ora and replace the full dns name with localhost Ditto for/ADMIN/listener.ora Update drivers\etc\hosts and end entries for 127.0.0.1 to localhost, MyMachine and MyMachine.region.mycorp.net Reboot