RE: Removing OLAP/ODM/XDB/UltraSearch
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <don@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 May 2007 15:34:44 -0400
Don,
You can and should lock all of these accounts.
Secondly, if you want to remove these options, they should be
de-installed - not simply dropped. A lot of these things have objects
stored under the SYS user - so dropping those accounts will not clean
things up properly.
You can probably use DBCA to de-install these objects (I have *never*
used DBCA - always manually created databases just for this reason).
Otherwise, you can find manual de-installation instructions on Metalink.
Tom
--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity to
whom it is addressed. If you are not the intended recipient, you are hereby
notified that any disclosure, dissemination, copying or distribution of this
transmission or its attachments is strictly prohibited. In addition,
unauthorized access to this transmission may violate federal or State law,
including the Electronic Communications Privacy Act of 1985. If you have
received this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Don Seiler
Sent: Monday, May 21, 2007 3:03 PM
To: oracle-l
Subject: Removing OLAP/ODM/XDB/UltraSearch
Running Oracle 10.2.0.2. This database was created via DBCA on Oracle
9.2.0.1, via DBCA and some things were enabled that we don't have
plans to use, namely OLAP, ODM, and XDB.
Is there anything more to removing these features than dropping the
users OLAPSYS, ODM, ODM_MTR and XDB and the tablespaces CWMLITE, ODM,
and XDB?
Now that I look, can WKSYS and WKPROXY be given the same treatment?
We don't use "UltraSearch" as far as I know ...
Or can I at least lock these user accounts?
--
Don Seiler
oracle blog: http://ora.seiler.us
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
