Geeks With Blogs

Blue Probe It’s the parting gift when you host an alien abduction

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

    1. Posted on Saturday, November 26, 2016 9:29 AM | Back to top


      Comments on this post: Can’t connect to Oracle XE on Windows 7

      No comments posted yet.
      Your comment:
       (will show your gravatar)


      Copyright © Ken Hortsch | Powered by: GeeksWithBlogs.net