**
Thats true - but I think there is a way to configure dependencies on services across servers too.. Not too sure on that one though.. Might be worth checking it out with MicroSoft if that is the case and you have Oracle installed on a remote server..

Regards

Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.

Michiel Beijen wrote:

** This would work obviously - but only if the DB is on the same box as the AR Server....

Regards,
Michiel


On 3/14/06, Joe DeSouza < joeremedy@yahoo.com > wrote:

**
If this is a windows problem, why dont you create a dependency between the ARS Server and the Oracle database wherein the ARS Server service would depend on the Oracle service and would not start without the Oracle services being up.. that way the Oracle database admins wont able to stop the Oracle server without first killing the ARS Server...

These dependencies can be created via the registry - if you do not know how let me know and I can guide you through it...

Regards

Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.



Yahoo! Mail
Use Photomail to share photos without annoying attachments. 20060125This posting was submitted with HTML in it

**

James:

Please let us know the results of your testing. This appears to be a common problem.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of James Pifer
Sent: Tuesday, March 14, 2006 9:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: Should Remedy reconnect to the database if the connection
is lost and then restored?


On Tue, 2006-03-14 at 09:01 -0700, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
> **
>
> James:
>
> Sadly, this sounds like a Windows problem. I can, and have, HUP'd the
> arserverd process which caused all of the other processes to fail with
> a TERM and this brought backup the Remedy server and reconnected it
> with an Oracle database on another server. Sadly, I think that this
> might be solved by stopping the Remedy service and waiting a few
> minutes for all of the communications to die down (I've had to do this
> with other products) and then restart the service. Have you tried
> this?
>
> James McKenzie

No, I have not tried stopping the service and waiting a few minutes and
then restarting. I have a test box that I could try this on and see if
it works. If it does then I could possibly write something that:
watches the connection
if it fails, keep rechecking for it to come back up
when connectivity to Oracle returns:
stop services for some period of time (to be determined)
then restart the services

If I can get it to work in some automated way that would be a workable
solution. If not, restarting the box is just as easy.

In response to Joe DeSouza, Remedy and Oracle are on different servers.

James


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

20060125This posting was submitted with HTML in it

Yeah, on UNIX it would be easy to put a listener in the Remedy startup script to ensure that Oracle is running, wherever it is. Not sure how you'd do that in Windows, unless you wrote a Java or Perl script or something, but even then, I'm not sure what the calls would be.

Maybe if you did a simple SQL call against the DB, and only let the Remedy startup begin when you got a return value (as opposed to a timeout)?


Rick



From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza
Sent: Tue 3/14/2006 8:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Should Remedy reconnect to the database if the connection is lost and then restored?




**
Thats true - but I think there is a way to configure dependencies on services across servers too.. Not too sure on that one though.. Might be worth checking it out with MicroSoft if that is the case and you have Oracle installed on a remote server..

Regards

Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.

Michiel Beijen wrote:

** This would work obviously - but only if the DB is on the same box as the AR Server....

Regards,
Michiel


On 3/14/06, Joe DeSouza < joeremedy@yahoo.com > wrote:

**
If this is a windows problem, why dont you create a dependency between the ARS Server and the Oracle database wherein the ARS Server service would depend on the Oracle service and would not start without the Oracle services being up.. that way the Oracle database admins wont able to stop the Oracle server without first killing the ARS Server...

These dependencies can be created via the registry - if you do not know how let me know and I can guide you through it...

Regards

Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.



Yahoo! Mail
Use Photomail to share photos without annoying attachments. 20060125This posting was submitted with HTML in it


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

James,

I am wondering whether you have tried also tried stopping and
restart the "AR System Portmapper" service?

Here are two simple windows CMD files I use to stop or restart
remedy.

To Stop Remedy...

Filename: RemedyStop.cmd

::Begin Batch file
::NET STOP "service Remedy Mail Server"
::NET STOP "service Remedy Application Server"
NET STOP "Remedy Action Request System Server"
NET STOP "AR System Portmapper"
::End Batch file


To Start Remedy...

Filename: RemedyStartup.cmd

::Begin Batch file

NET START "AR System Portmapper"
NET START "Remedy Action Request System Server"

::NET START "Remedy Application Server"
::NET START "Remedy Mail Server"
::End Batch file

I don't know whether restarting the portmapper service will
resolve your specific issue or not but it most certainly is worth
a try. The order that the services are stopped/started is very
important. If a service is already stopped or started a slight
delay will occur while Windows tries to perform the requested
action. You can also perform this manually via the services
management console.

Obviously this is a "Windows only" solution but I'm sure the same
can be accomplished in other environments.

I'm hopeful that this resolves your issue without your having to
reboot the machine to accomplish the same. Please do let me know
the result good or bad should you give this a try.


Regards,

tom

Thomas J. Mutaffis
Simplexity Inc.

----- Original Message -----
From: "James Pifer"
Newsgroups: public.remedy.arsystem.general
To:
Sent: Tuesday, March 14, 2006 11:18 AM
Subject: Re: Should Remedy reconnect to the database if the
connection is lost and then restored?


> On Tue, 2006-03-14 at 09:01 -0700, McKenzie, James J C-E LCMC
> HQISEC/L3
> wrote:
>> **
>>
>> James:
>>
>> Sadly, this sounds like a Windows problem. I can, and have,
>> HUP'd the
>> arserverd process which caused all of the other processes to
>> fail with
>> a TERM and this brought backup the Remedy server and
>> reconnected it
>> with an Oracle database on another server. Sadly, I think
>> that this
>> might be solved by stopping the Remedy service and waiting a
>> few
>> minutes for all of the communications to die down (I've had to
>> do this
>> with other products) and then restart the service. Have you
>> tried
>> this?
>>
>> James McKenzie
>
> No, I have not tried stopping the service and waiting a few
> minutes and
> then restarting. I have a test box that I could try this on and
> see if
> it works. If it does then I could possibly write something
> that:
> watches the connection
> if it fails, keep rechecking for it to come back up
> when connectivity to Oracle returns:
> stop services for some period of time (to be determined)
> then restart the services
>
> If I can get it to work in some automated way that would be a
> workable
> solution. If not, restarting the box is just as easy.
>
> In response to Joe DeSouza, Remedy and Oracle are on different
> servers.
>
> James
>
>
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.ARSLIST.org
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

In theory this is already in place (4 times, 15 seconds between).
Although I haven't seen it work properly in our situation. It's likely
just not enough time.
It would also be useful to know the specific recovery attempts that
armonitor.exe makes vs. arserver.exe.

There is also an ar.cfg parameter that I've tried, but still hasn't
seemed to do what I wanted:

Db-Connection-Retries: 22

Currently there is no way to change the interval between retries.

-Brian Luke




From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen
Sent: Tuesday, March 14, 2006 5:34 AM
To: arslist@ARSLIST.ORG
Subject: Re: Should Remedy reconnect to the database if the connection
is lost and then restored?


** Of course it would be far better that the AR System service would try
to reconnect to the database every x minutes when it can not connect to
the database. But I guess this would be an enhancement request.
Shal we all submit this enhancement request?

Regards,
Michiel


On 3/14/06, Krishnakumar wrote:

Hi James,
Like Brian has mentioned, the ideal thing to do would
be to
monitor the DB and stop the ARS service if the DB is down.

However, if this turns out to be a bit out of reach, you could
atleast
make sure that ARS is stopped before the DB is brought up again.
This
would ensure that ARS is not using the old connection to the DB.
ARS can
then be started once the SQL Listeners are up and running. This
should
ensure that ARS works fine.


Regards,
Krishnakumar

On Tue, 14 Mar 2006 05:44:21 +0530, Luke, Brian <
Brian.Luke@SCHWAB.COM >
wrote:

> James,
> We ran in to this situation as well. Our specific
config was
> running Windows app server and Linux DB server.
>
> The best thing to do is to stop ARS on the remote machine
(from the DB
> machine) as part of the script stopping the database.
Likewise starting
> ARS just after starting the DB. If they're on the same
platform it's a
> bit simpler. If it's not on the same platform, you'll need to
figure
> out how to issue commands remotely across platforms.
>
> What platforms are your respective systems on?
> Do you have Tivoli, NetIQ, or any other monitoring systems in
place the
> systems?
>
> In our case, we installed a cygwin/SSH server on the Windows
app server,
> and can issue commands from the Linux box that way.
>
> Another approach that works is to create a monitor to test the
return
> code from TNSPING on the app server to your DB Instance. When
it fails,
> stop ARS. When it works (and didn't last time it checked),
start ARS.
>
> Hope this helps,
> -Brian
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of James Pifer
> Sent: Monday, March 13, 2006 1:43 PM
> To: arslist@ARSLIST.ORG
> Subject: Should Remedy reconnect to the database if the
connection is
> lost and then restored?
>
> We're running ARS 6.x with Helpdesk 4.0.3 on Windows 2000
Server. Our DB
> is Oracle 9i running on another server. We've had problems
quite a few
> times on the database server where it either has rebooted or
been taken
> down for maintenance. In these instances I have to completely
restart
> the Remedy server. I can't even just stop and start the
service.
>
> Is this normal or should the Remedy service reconnect to the
database
> once it is back up?
>
> Thanks,
> James
>
>

>
> UNSUBSCRIBE or access ARSlist Archives at
http://www.ARSLIST.org
>
>


> UNSUBSCRIBE or access ARSlist Archives at
http://www.ARSLIST.org




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org



20060125This posting was submitted with HTML in
it


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org