One thing I would Really look at as well.. would be the implications on your ability to Patch these boxes.. Afterward. Test that good.. for example.. Take an oracle 10.2 box Stock, and Rip those above out.. then Patch with the April and Oct CPU Security patches.. see how that works.. The last thing you want is a secure box that you cannot even patch. then it is only secure to the date you made it. Consider the following information as well for security Hardening.. http://www.ngssoftware.com/papers I just found this today..
XDB is the HTMLDB stuff.. (which I would consider for future use.. it give you the ability to on the fly create a data view. WKSYS WMSYS These are used for auditing.. from what I can tell. (depends on what your DBA needs ) ---- Just ensure you are ripping out what you do not ever want. On 12/8/06, Mark Powell <[EMAIL PROTECTED]> wrote:
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.orgARSlist:"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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
