Re:FW: So you are stable?

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


Other related posts: