XPost: comp.database.oracle, comp.database.oracle.misc, comp.dat   
   base.oracle.server   
   XPost: comp.database.oracle.tools   
   From: pbfvern@bellsouth.net   
      
   Hello All,   
      
   I have the above DSL modem on my network along with a variety of machines   
   and several different operating systems. One of the operating systems I have   
   is Novell 5.1 and on that server I am using the five user versions of Oracle   
   that ships with Novell. The Oracle version I am using is 8i. The server   
   bundle works great and I do all of my business on this platform.   
      
   I also have DSL, Novell (v5.0 and Oracle 8), running at home where I have   
   several databases that I rely upon heavily and it works great as well. My   
   dilemma is that I want to be able to access my work Oracle instance from   
   home. Incidentally, I have the identical Westell at home as I do at work.   
      
   I have opened up ports 1521-1526 with a base port of 1521 on the Westell at   
   work, (both udp and tcp), and managed to get a login prompt from sqlplus but   
   I'm never able to get logged in. It seems that Oracle is using a different   
   port each time I try to connect for communications. I could open up all   
   ports on my Westell but you know what that will do to my security.   
      
   Does anyone know what I need to do to have the ability to control this? Is   
   there special software I need to install to install on my Westell or is   
   there a way to instruct Oracle to use specific ports?   
      
   Thank you in advance for any help you may be able to provide,   
      
   Vern   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)