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 :)
You are doing a fantastic job.
ReplyDeleteKeep up the good work.
Tunde from London
Thank you for an excellent overview.
ReplyDeleteAmazin, this is exactly what I was looking for ^_^ Thank you very much.
ReplyDeleteThanks a lot, it has been very usefull.
ReplyDeleteThank you also for your expedient work !!!
ReplyDeleteBest regards from Berlin.
Oracle JVM
ReplyDelete------------
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)
Excellent post as per usual, many thanks
ReplyDeleteAdam - London
hey man good job, very useful info ,
ReplyDeleteit could have been better if oracle notes are linked ,but that would be asking too much I know :) good job keep it up
Hi, some additional note IDs.
ReplyDeleteData 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)
Great article, totally what I was looking for.
ReplyDeletemy web-site; web page - ,