pn] Just a couple of clarifications. Net8 (Oracle8 replacement for SQL*Net) is not restricted to ports 1521 and 1526; they are just the most commonly used (installation defaults). Pick your desired port in both the listener.ora on the server and in the tnsnames.ora on the client(s). Net8 does have options for encrypting data transmitted between the server and clients, but it requires special configuration settings on both the server and client(s). Any misconfigured client could send account userids and passwords in clear text to the server.
> -----Original Message----- > 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. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _______________________________________________ Leaf-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/leaf-user
