Oracle SQL*Net communicates on only 1521 or 1526 depending upon the version. 1521 is the one most used. There is no dynamic ip assignment. Make sure 1521 isn't only opened, but forwarded as well. I'm assuming that you've put the Access server on the same net and made sure sqlnet is properly configured in the first place (i.e. the tnsnames.ora file on the Access server works). If you did do this, make sure that you have the correct host name in the tnsnames file after you've moved it outside the leaf -- e.g. If the Oracle server is using a nat'd IP (192.168.x.x), then your Access tnsnames file should show the ip address of the eth0 of the leaf machine, and the port should be whatever is the forwarded port. I'd also suggest that you tunnel the SQL*Net connection through SSH if sensitive data is being transmitted. Net8 doesn't encrypt any of the data, so all information is easily visible. If you establish an ssh connection from the Access server to the LEAF, you can tunnel SQL*Net through SSH.
Good luck. mike. Todd Pearsall wrote: >You should be on the right path. port 1521 is the default Oracle listener >port. Once you connect to the listener it spawns processes on other ports >to continue the conversation. > >With Oracle inside the firewall you need to let 1521 in and then Oracle >starts communication on the other ports that LEAF should let out. > >Does the Oracle box have a routable IP or is it masquareded. If it's >masquareded be sure to open 1521 and then forward it to the Oracle box. I >would assume the dynamically assigned ports would be handled fine by the >normal masquarding logic. (maybe?) > >Sorry for the lack of specific suggestions. > >----- Original Message ----- >From: <[EMAIL PROTECTED]> >To: "Charles Steinkuehler" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Saturday, October 06, 2001 5:22 PM >Subject: [Leaf-user] Oracle 8 > > >>Hello All, >> >>I have an Oracle 8 server running behind my masquerading firewall and am >> >having > >>trouble connecting to it from my MS Access server on the outside. >> >>I have opened up port 1521 that I could find in the "dbstart" files from >>oracle, but I think that they might be using something like dynamic ports >> >as > >>well. >> >>Has anyonw had to deal with this problem? >> >>cheers, >>lonnie >> >> >>_______________________________________________ >>Leaf-user mailing list >>[EMAIL PROTECTED] >>https://lists.sourceforge.net/lists/listinfo/leaf-user >> > > >_______________________________________________ >Leaf-user mailing list >[EMAIL PROTECTED] >https://lists.sourceforge.net/lists/listinfo/leaf-user > >. > _______________________________________________ Leaf-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/leaf-user
