Srini Chavali wrote:I think it also installs other things to like generic / test schemas / users. So what can I expect to see or have to do manually if I choose 'Install database software only'? Does this mean after the installation is complete I have to manually create a database using SQL statements? If I select the above mentioned option, can I not simply connect to my database instance and run 'startup' from SQL*Plus or because there's no empty database, I would have to do something manually before being able to run the 'startup' command in SQL*Plus?
If you choose 'Install database software only' then you are only installing the software. The 'Create / Configure database' option not only installs the software, but also creates an empty database.
All of this is documented, assuming you care to read the documentation - http://docs.oracle.com/cd/E11882_01/install.112/e24321/inst_task.htm#BABJGGJHThanks for the link above. I read the page and not knowing anything about Oracle software, I'm guessing if I select EE (Enterprise Edition), I can de-select EVERY option and still have a functioning / healthy RDBMS, correct? None of the options in the URL above seem to be madatory in order for me to create a database, schema, user, or put data into tables. correct me if I'm wrong please...
CarlosinFL wrote:To (hopefully) clarify, summarize, and add to previous comments
I'm installing Oracle 18.104.22.168 on RHEL 6 Linux and during the OUI, I am prompted with a section of the installer that asks if I would like to:
- Create / Configure database
- Install database software only
My question is what exactly am I omitting or will I encounter if I select 'Install database software only'? Is it recommended to select this option if I don't need the sample 'SCOTT' database and other stuff not necessary to run Oracle 11g R2?
Secondly my next question is also about the installer...under the 'Which database version do you want to install menu page or OUI', I'm selecting Enterprise Edition but I'm being told to make sure I don't load un-necessary components that we wont use. Assuming this is the most basic single instance database server ever to filter dust, what components can I remove and still have a minimal functioning Oracle 11g R2 database with?
- Oracle Partitioning
- Oracle OLAP
- Oracle Label Security
- Oracle Data Mining RDBMS Files
- Oracle Real Application Testing
I've so far deselected them all because I don't think I need any of those. I'm just not sure if I can install a healthy database software if I omit all of the above...