Re: Connecting to Oracle Server after workstation loses power

From: Jerry <america_at_usa.com>
Date: Mon, 2 Oct 2000 19:08:24 -0500
Message-ID: <Lr9C5.4066$Jf1.28471@news4.atl>

What do you mean by "it cannot connect "; The user who logged on thru the Application or any user trying to connect thru the app. from this worksation. Can you connect with instance manager or sql plus. What is the Workstation OS -- Win95 or NT. Can the user who station went down connect from another workstation. More info.

Mark Grover <mark.grover at sequistperfect.com> wrote in message news:39d8f910$0$23417_at_wodc7nh1.news.uu.net...
> We currently have Oracle 8.0.4.0.0 running on WinNT 4.0 SP5.
> Our shop has occasional power problems and when power goes out on a
> workstation that has a transaction open, after the workstation reboots, it
> cannot connect to the Oracle server. The only thing I can do to
> re-establish the connection is reboot the server (or start and stop all
> oracles services). Of course, this is inconveniant because I must have
all
> remaining users log out.
>
> Is there something else I can do?
>
> Is there a patch that takes care of this?
> Would loading service pack 6 on Winnt do anything?
> (Is a current maintenance contract with Oracle required to download
> patches?)
>
>
>
>
Received on Mon Oct 02 2000 - 19:08:24 CDT