Re: Oracle 7.3 & Windows NT

Philippe Lepot <philippe.lepot_at_eft.be> writes:

>We are using an Oracle 7.3 workgroup server on a Windows NT server. We
>are encountering a strange behaviour. When we logout from the server
>console there is either no way to connect to the database from the
>client or the client application goes GPF on exit. The only solution we
>found to fix this is to be logged in permenantly on the console. If we
>have to logout for any reasons then the solution is to log in again,
>stop then start the OracleTNSListener.
>Why does this happen ? Is this related to IPS/SPX protocol ? How can we
>avoid this ?

Your tnslistener and oracle services are configured as services, correct? From the above description it sounds almost as if they are being run as user processes, and terminating (as they should) when you are logging out. I don't know how you could have configured it that way, however, so I doubt that's really the problem...

Are the services configured to log in as a certain user when they are started? If so, does that user have permissions to create background jobs? (Sorry, I'm not on an NT box or I would check for teh exact perms necessary - I'm sure someone else will jump up and correct my misnaming. ;-) )

Protocol shouldn't have anything to do with it - any reason why you're not running sql*net over straight tcp/ip, however? NT server likes it better, but if you don't have it installed to the desktops, I could see it being a problem...

--

---
Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.