That's interesting on OE. Here is an excerpt from my (pretty darn fast actually) Remedy Support response:
"ARSystem uses its own Table Space and Schema so none of the ones listed would apply, unless the previous install was put in one of them? which is doubtful considering the issues you would have. " We definitely didn't put the install in one of them, so it seems we are clear, except for the possible OE implications which I'm still reading. Thanks a lot for your help. On 12/8/06, patrick zandi <[EMAIL PROTECTED]> wrote:
** Actually, I am looking further into this.. I think OE is needed.. Oracle using this for security side.. if he is Hardening the server.. check this http://www.oracle.com/technology/deploy/security/pdf/twp_security_checklist_db_database.pdf I am looking around at the rest.. On 12/8/06, Mark Powell <[EMAIL PROTECTED]> wrote: > > Thanks, Zandi. I know ARS creates background schemas of its own like > ARSCHEMA and FILTERS... etc., and since it functions across several DB > platforms, I didn't think it would have total reliance on Oracle > default schemas. But, if it does make use of them, say to improve > performance when on Oracle, I didn't want to break it. > > We are using a testbed for the first pass, so we shouldn't do too much > damage either way. > > I've also asked Remedy Support, and will post an update on their > response. You were much quicker, and I know you've done installs many > times over the years! Thanks!! > > -Mark Powell > [EMAIL PROTECTED] > ------------------------------- > > On 12/8/06, patrick zandi <[EMAIL PROTECTED]> wrote: > > ** > > Mark, > > Not that I know of..Remedy using ARadmin tables, and any links that you > > need.. > > you could use remedy to access the scott / hr tables for testing purposes.. > > your choice.. > > like a Testbed of sorts.. This way you don't mess with your prod data.. who > > cares about scott's tables.. > > > > But there is additional functionality that you can use with some of these.. > > Like if you wanted an oracle application to access your remedy tables.. and > > build in some additinal View functionality or report's.. some of those > > below.. (if I remember correctly) will be needed.. > > > > > > On 12/8/06, Mark Powell <[EMAIL PROTECTED]> wrote: > > > > > > Hello list: > > > > > > We are in the process of upgrading Oracle to support an upgrade of > > > ARS. We are moving from Oracle 9i to Oracle 10gR2 and then will > > > upgrade ARS from 5.1.2 to 7.0.1. The question the DBA presented me > > > is... does ARS make use of any of the following Oracle default > > > schemas, or can they be removed to keep things clean? > > > > > > CTXSYS > > > HR > > > MDSYS > > > ODM > > > ODM_MTR > > > OE > > > OLAPSYS > > > ORDPLUGINS > > > ORDSYS > > > OUTLN > > > PM > > > QS > > > QS_ADM > > > QS_CBADM > > > QS_CS > > > QS_ES > > > QS_OS > > > QS_WS > > > SCOTT > > > SH > > > WKSYS > > > WMSYS > > > XDB > > > > > > Does ARS (5.1.2, 6.3 or 7.0.1) use any of these when residing on > > > Oracle?? We're on Solaris 9 if that makes any difference. > > > > > > Thanks for your help! > > > > > > -Mark Powell > > > [EMAIL PROTECTED] > > > > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > > the Answers Are" > > > > > > > > > > > -- > > Patrick Zandi __20060125_______________________This posting > > was submitted with HTML in it___ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > -- Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
