Re:FW: So you are stable?

From: Alessandro Vercelli <alever_at_libero.it>
Date: Thu, 31 Aug 2006 14:49:07 +0200
Message-Id: <J4V4XV$AB9C2669EB3D43E90988D1646B338FF2@libero.it>

About Remedy (ARSYS) my experience is the following:

- needed to recreate aradmin schema on an Oracle 8.1.7.3 database for Remedy on Win2k
- all Remedy clients and Remedy server are cleanly closed but aradmin schema cannot be dropped due to multiple database sessions by aradmin itself;
- database was on production so could not be closed: ALTER SYSTEM KILL SESSION did not release locks so needed to use ORAKILL (Metalink note 100859.1).

So, on my opinion Remedy is even too much stable....

Regards,

Alessandro

>
> > While investigating these old processes:
> >
> > clarify 9440 1 0 Mar 29 ? 113:22 rmworkerprocess 9331_1
> > stop
> > clarify 10407 1 0 Sep 30 ? 224:15 rmworkerprocess
> > 10406_1 start
> > clarify 26115 1 0 Dec 24 ? 218:23 rmworkerprocess
> > 26114_1 start
> > clarify 5534 1 0 Sep 30 ? 161:22 rmworkerprocess 5532_1
> > start
> >
> > I found a DB on the box:
> >
> > /export/home> sqlplus
> > SQL*Plus: Release 8.0.6.0.0 - Production on Thu Aug 31 11:18:08 2006
> >
> > SQL> select to_char(startup_time, ' HH24:MI:SS DD-MM-YYYY') startup,
> > status from v$instance ;
> >
> > STARTUP STATUS
> > -------------------- -------
> > 14:01:05 27-11-2002 OPEN
> >
> >
> > Got this nice session also :
> >
> >
> > Sid Osuser Osuser Program
> > LOGON_TIME
> > ---- ------------------ ------------ ------------------------------
> > -----------------
> > 18 SA clarify rmworkerprocess (TNS V1-V3)
> > 30-sep-2004 17:09
> >
> > Sound like Remedy is a stable application.
> >
> >
> > B. Polarski
> >
>

Mutui a tassi scontati da 30 banche. Richiedi online e risparmia. Servizio gratuito. http://click.libero.it/mutuionline

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 31 2006 - 07:49:07 CDT