Monday, November 12, 2007

Manually Install/De-Install Database Options in Oracle Database 10gR2

Hi,

When a new database is created using DBCA, by default some of the common database options are installed like Oracle JVM and Oracle Text. But, when you manually create the database none of them get installed. You need to manually install them.

I thought of sharing Metalink Note Id’s for some of the Common Database Options which you can manually install/de-install once database has been created:

Oracle JVM
Note:276554.1 How to Reload the JVM in 10.1.0.X and 10.2.0.X

Oracle Text
Note:280713.1 Manual installation, deinstallation of Oracle Text 10gR1 and 10gR2

Oracle XML DB
Note:243554.1 How to Deinstall and Reinstall XML Database (XDB)

Oracle Multimedia
Installation, Upgrade and Downgrade information can be found in the following Manual: Oracle® interMedia
User's Guide 10g Release 2 (10.2) Appendix B Installing and Upgrading Oracle interMedia

Oracle OLAP
Note:296187.1 How To Manually Install Oracle OLAP into a 9i or 10g Database After the DB Has Been Created

Oracle Spatial
Note:270588.1 Steps for Manual Installation / Verification of Spatial 10g

Note:1070647.1 How to Deinstall Oracle Spatial keeping Oracle Locator

Oracle Ultra Search
Note:337992.1 How to Manually Install and Uninstall Ultra Search 10gR2 Server Components


Oracle Label Security
Note:171155.1 How to Install / Deinstall Oracle Label Security Oracle9i/10g

Sample Schemas
Note:340112.1 How To Install Sample Schemas in 10g?

Enterprise Manager Repository
Note:114763.1 How to Create Enterprise Manager 2.1 Repository Using EMCA

Oracle Application Express
Note:445205.1 How to download and install Application Express / HTMLDB

Oracle Warehouse Builder
Note:459961.1 How to Install Warehouse Builder Repository(10.2.0.1.31) on a RAC Database on Windows and UNIX

Oracle Database Vault
Note:445092.1 How to Install Database Vault Patches on top of 10.2.0.3

Oracle Database Extensions for .NET
Note:374820.1 How to Install the Oracle Database Extensions for .NET (ODE.NET)


Oracle Data Mining
Note:297551.1 How to remove the Data Mining Option from the database




Thanks Gerrit for Oracle Data Mining & Oracle Spatial MOS document id's.


Hope you find this document helpful :)

10 comments:

Anonymous said...

You are doing a fantastic job.
Keep up the good work.
Tunde from London

Sten said...

Thank you for an excellent overview.

Guillermo Alan Bort said...

Amazin, this is exactly what I was looking for ^_^ Thank you very much.

Fernando Contreras said...

Thanks a lot, it has been very usefull.

Anonymous said...

Thank you also for your expedient work !!!
Best regards from Berlin.

Nyckelpiga said...

Oracle JVM
------------
Note:276554.1 How to Reload the JVM in 10.1.0.X and 10.2.0.X
Master Note for Oracle JVM [ID 1098505.1]
The following notes are available for each Database version that cover the steps needed to either Remove or Install the Database JVM.

Database Version 8.1.7:

Note.175472.1 - How to Reload the JVM in 8.1.7.X

Database Version 9.0.1:

Note.202914.1 - How to Reload the JVM in 9.0.1.X

Database Version 9.2.0:

Note.209870.1 - How to Reload the JVM in 9.2.0.X

Database Version 10.2.0:

Note.276554.1 How to Reload the JVM in 10.1.0.X and 10.2.0.X

Database Version 11.1.0:

Note 457279.1 How to Reload the JVM in 11.1.0.x

Database Version 11.2.0:

Note 1112983.1 How to Reload the JVM in 11.2.0.x



Oracle Text
------------
Note:280713.1 Manual installation, deinstallation of Oracle Text 10gR1
10gR2 [ID 979705.1]
11gR2 [ID 970473.1]

Oracle XML DB
------------
Note:243554.1 How to Deinstall and Reinstall XML Database (XDB) 10.2

Oracle Multimedia
------------
Installation, Upgrade and Downgrade information can be found in the following Manual: Oracle® interMedia User's Guide 10g Release 2 (10.2) Appendix B Installing and Upgrading Oracle interMedia

Oracle OLAP
------------
Note:296187.1 How To Manually Install Oracle OLAP into a 9i, 10g or 11g Database After the DB Has Been Created

Oracle Spatial
------------
Note:270588.1 Steps for Manual Installation / Verification of Spatial 10g / 11g

Oracle Ultra Search
------------
Note:337992.1 How to Manually Install and Uninstall Ultra Search 10gR2 Server Components
11gR1 [ID 601411.1]
Where is 11gR2 ???

Oracle Label Security
------------
Note:171155.1 How to Install / Deinstall Oracle Label Security Oracle9i/10g

Sample Schemas
------------
Note:340112.1 How To Install Sample Schemas in 10g?

Enterprise Manager Repository
------------
Note:114763.1 How to Create Enterprise Manager 2.1 Repository Using EMCA

Oracle Application Express
------------
Note:445205.1 How to download and install Application Express / HTMLDB

Oracle Warehouse Builder
------------
Note:459961.1 How to Install Warehouse Builder Repository(10.2.0.1.31) on a RAC Database on Windows and UNIX

Oracle Database Vault
------------
Note:445092.1 How to Install Database Vault Patches on top of 10.2.0.3

Oracle Database Extensions for .NET
------------
Note:374820.1 How to Install the Oracle Database Extensions for .NET (ODE.NET)

Anonymous said...

Excellent post as per usual, many thanks
Adam - London

Anonymous said...

hey man good job, very useful info ,
it could have been better if oracle notes are linked ,but that would be asking too much I know :) good job keep it up

Nyckelpiga said...

Hi, some additional note IDs.

Data Mining
Note: 297551.1 How To Remove the Data Mining Option from the Database

Spatial
Note:1070647.1 How To Deinstall Oracle Spatial Keeping Oracle Locator

And somehow all the links and information above made it to MOS, nice collection about the same theme with much more links and information:

Note:472937.1 Information On Installed Database Components and Schemas [ID 472937.1]

Regards, Gerrit (alias Nyckelpiga)

Anonymous said...

Great article, totally what I was looking for.


my web-site; web page - ,