|Oracle Linux Configuration for Database Installation
|Note: Oracle has changed the nature of how they released this version and have made available at MyOracleSupport 7 zip files. Here are their descriptions:
|Operating System||Oracle Enterprise Linux ??? Kernel|
|Operating System Configuration|
|As root: Install missing RPMs||--mount DVD as root
|As root: Create DBA Group and Oracle User||
|As root: Create Installation Directories||
|As root: Set Appropriate Kernel Parameters||
|As root: Set Shell Limits||
|As root: Change Default Profile for the BASH shell||
|Optimize TCP/IP Stack Handling||TBD|
|As root: Modify .bashrc||
|Oracle Universal Installer (OUI)|
|NETwork Configuration Assistant (NETCA)|
|DataBase Configuration Assistant (DBCA)|
Note that under Cause and Action they list "Fast Recovery Area" ... that has been renamed for the third time in my immediate memory but DBCA, it appears, didn't get that information. The new name is "Recovery Area."
I really wish Oracle's Senior VP of Product and Feature Renaming would retire.
Note under status the listener is down. It is down because I didn't start it after creating it in NetCA. I did so intentionally so this would happen as it causes an issue for DBCA.
Started the listener in the command shell with LSNRCTL start
Having select this checkbox you might expect to find SCOTT, PM, SH, and other sample schemas from past versions, and you would be incorrect. What you get is HR and some new sample schemas not available in previous versions.
If you want the tried and true, and think it insulting to the memory of Bruce Scott that they dropped SCOTT/TIGER you can find what you are looking for at github.
Make sure that you provide an audit_file_dest and that the db_block_size is 8192.
Want to change the common_user_prefix from C## to something else ... do it here. Note that the control_management_pack_pack_access is set to DIAGNOSTIC+TUNING. This does not give you permission to use these options or run ASH and AWR reports if you have not purchased the appropriate licenses.
Do not change db_writer_processes, or other processes, unless you have run tests in an QA environment, on similar infrastructure, and know the change will make things better: not worse.
|Always save a database template an always generate database creation scripts. There has been value for 50 years in have documented repeatable processes and Oracle has been making it easy for those of us that can check a box and push a button.|
Then click [Finish]
|Dynamic Performance Views|
|Redo Log Files|
|What's New In 12cR1|
|What's New In 12cR2|
|This site is maintained by Dan Morgan. Last Updated:||This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved|