HuberBlog ::Jason Huber

Wow this was far too difficult. Here is the situation: I have Oracle 9i installed on a Windows 2003 Virtual Machine running on Virtual PC with a host machine with 784 M Ram and a 1.4Ghz Ahtlon processor. The whole thing is hosted by adelphi.com and is behind a router/firewall combo.

Keeping in mind I always access this hostmachine using remote desktop, I got the virtual up and running, I gave it access to the network and I could connect from my laptop (on the same network).

Now I wanted to access it externally. I opened up the port on the firewall that I had oracle listening on and I though I was good to go. I VPN’d into work and updated my TNS names with the new host and I was off. But the tnsping timed out.

I tried and tried. I installed a new listener thinking that my ISP was preventing traffic on port 1521, but it turns out it wasnt so. When I came into work I asked Todd Harrison if he had any ideas. We talked back and forth for a while did some work and let it settle.

He messaged me 30 minutes later with another port number. He had checked his listener and verified it was using two ports (as we suspected). I added the port and all is well. I was able to connect etc and get access remotely.

The ports needed for a default installation are:

1521
2481

Now I am off to add users.
http://www.cs.ucsb.edu/~wenye/oracledba.html

CREATE USER username
IDENTIFIED BY password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 50M ON users;

GRANT connect TO username;
GRANT resource TO username;