RE: Removing OLAP/ODM/XDB/UltraSearch

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 21 May 2007 15:34:44 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08E05@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon May 21 2007 - 14:34:44 CDT