Re:FW: So you are stable?
- From: "Alessandro Vercelli" <alever@xxxxxxxxx>
- To: "Bernard\.Polarski" <Bernard.Polarski@xxxxxxxxxxxxxx>
- Date: Thu, 31 Aug 2006 14:49:07 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
