[Info-ingres] RE: Info-ingres digest, Vol 1 #374 - 1 msg



Hi,



With regards to installing ingres patches on windows I've had the same

issues but have resolved by doing the following :



- Make sure IVM is not running

- Make sure no ingres processes are running

- Shutdown the following services:

IIS

WMI

COM+

SNMP





The only one I couldn't get round recently was the slow_v4.mnx being

accessed by another program. I chose to ignore that warning and

everything was fine. The slow_v4.mnx file is read by IVM which was

shutdown so I didn't see it as a problem. The only other thing that I

could think of that was accessing this file was the ingres performance

counters. With this being the only problem the patch installed ok with

no reported issues.



The patching we've done is on Advantage Ingres 2.6 running windows 2000

server...we're at patch level 10797



Hope this helps...



Best Regards



Graham T Newlands

IT Consultant

Fujitsu Australia



Address:

Lvl 20, 222 Exhibition St, Melbourne, VIC 3000

Tel:

+61 3 9657 8705

Mobile:

0404 003 104

Fax:

+61 3 9664 6570

Email:

graham.newlands@xxxxxxxxxxxxxx

Web site:

http://au.fujitsu.com









-----Original Message-----

From: info-ingres-admin@xxxxxxxxxxxxxxx

[mailto:info-ingres-admin@xxxxxxxxxxxxxxx] On Behalf Of

info-ingres-request@xxxxxxxxxxxxxxx

Sent: Friday, 14 October 2005 3:00 AM

To: info-ingres@xxxxxxxxxxxxxxx

Subject: Info-ingres digest, Vol 1 #374 - 1 msg



Send Info-ingres mailing list submissions to

info-ingres@xxxxxxxxxxxxxxx



To subscribe or unsubscribe via the World Wide Web, visit

http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres

or, via email, send a message with subject or body 'help' to

info-ingres-request@xxxxxxxxxxxxxxx



You can reach the person managing the list at

info-ingres-admin@xxxxxxxxxxxxxxx



When replying, please edit your Subject line so it is more specific than

"Re: Contents of Info-ingres digest..."





Today's Topics:



1. FW: Patch install - DLLs in use (Paul White)



--__--__--



Message: 1

Date: Thu, 13 Oct 2005 23:40:15 +1000

From: "Paul White" <pwhite@xxxxxxxxxxxxxxxxx>

To: <info-ingres@xxxxxxxxxxxxxxx>

Reply-To: <pwhite_nospam@xxxxxxxxxxxxxxxxxxxxxxxx>

Subject: [Info-ingres] FW: Patch install - DLLs in use



Can anyone confirm if this happens in R3?





Paul writes....



Hi Justin,



I never did get to the bottom of it. The problem is not restricted to

Terminal server. It also happens on Win2K and WinXP occasionally. It

happened all the way back to Windows NT. I'm pretty sure it is in ingres

net somewhere. I've seen the problem particularly under this

circumstance:



OpenROAD sp1, OpenROAD sp2, Ingres 26sp2 net, OR patch. Then when

trying to upgrade to OpenROAD sp3 the errors display during the net

installation. Accidentally we found that pressing cancel allowed the OR

upgrade to proceed and the client seems stable.



I'm not a windows expert but I think that if the ingres service is

listed as automatic or manual the O/S loads the dlls - something about

"pre-fetch" - I'm not sure. Here's my formula for these sorts of cases:



Remove ivm from start up menu. (from all users) Stop OpenROAD appserver

and disable Stop ingres net services and set status to "disabled"

Reboot. Ensure no users log in until you are done.

Apply the patch.



If you get the error during an ingres dbms upgrade the results are bad.

Follow the steps below, then re-install everything from scratch.



By the way, I have been able to install/upgrade on a live terminal

server even when there were other sessions running. But if ivm had been

loaded at any time I think you will need to reboot first.



Paul





-----Original Message-----

From: justin.otto at orion.co.nz

Sent: Thursday, 13 October 2005 1:28 PM

To: Paul White

Subject: Re: Patch install - DLLs in use



Did you ever find the solution to this? I'm having the exact same

problem. Thanks.



Paul White wrote:

> Ingres 2.6/0305. Patch P10009. Win2000 - Terminal Server.

>

> I'm having trouble installing an ingres patch because the dlls are in

use.

> msinfo32 lists the dlls in the "Loaded Modules" section.

>

> I haven't had this problem on other machines. Normally, when I shut

> down ingres the DLLs are unloaded automatically. Is there a "autoload

> recently used DLLs" setting somewhere?

>

> The popup message says retry, skip or abort about 15 times. Examples

> are oiadfdata.dll oiadfnt.dll oiclfdata.dll ...

> slow_v4.mnx

>

> I set the Ingres Intelligent Database service to Manual, and removed

> ivm from the startup program group. Rebooted. I checked for iigcc,

> iigcn, dmfacp, dmfrcp, iidbms, rmcmd, iigwxxx, iijdbc, ivm. No other

> users are on the box. OpenROAD runtime is installed but not Appserver.

> No w4glrun processes.

>

> In the end, I renamed each dll one by one as the popup message

displayed.

> The only one I could not rename was slow_v4.mnx.

>

> Paul

> _______________________________________________

> Info-ingres mailing list









--__--__--



_______________________________________________

Info-ingres mailing list

Info-ingres@xxxxxxxxxxxxxxx

http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres





End of Info-ingres Digest





This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.



If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email unsubscribe@xxxxxxxxxxxxxx



.



Relevant Pages

  • RE: [Info-ingres] Re: Remote Command Does not Start
    ... According to the Getting Started manual GS.pdf the installing user must: ... Pre Ingres 2.6 we also needed "log on as a batch job" ... Is imadb owned by $ingres? ... Who owns the view remotecmdinview? ...
    (comp.databases.ingres)
  • Re: Embedded SQL
    ... What "tool" are you installing which also installs Ingres? ... environment with their embedded Ingres. ...
    (comp.databases.ingres)
  • [Info-ingres] FW: Patch install - DLLs in use
    ... installation. ... I'm not a windows expert but I think that if the ingres service is ... To: Paul White ... Subject: Re: Patch install - DLLs in use ...
    (comp.databases.ingres)