©2015 -
Information Technology
How To Create An Oracle 12c Database -
STEP 5. You may specify which browser based database management you would like to configure.
The first option is the Database Express (formerly known as Database Control). A web server will be configured local to your database server. Database management can be done via the URL provided after the database creation.
The second option is an Oracle Enterprise Manager (also known as Cloud Control). This is a centralized database management and monitoring system hosted by another server. If you wish your database management to be controlled by the Oracle Enterprise manager, just simply provide the connection details as prompted below.
In my case, I just wanted it to be localized, so I chose the default Database Express.
Keep in mind you have the option not to choose both which brings the database management to solely SQL*Plus command line, or Oracle Client SQL Developer, and third party GUI tools such as TOAD and DB Artisan.
STEP 6. I have set the password for all privilege accounts to be the same to keep everything simple.
STEP 7. Select the Oracle Net Listener you wish the database to be associated.
STEP 8. For storage location, I have chosen the default paths for the database files and recovery files.
STEP 9a -
STEP 9b. Unless you wanted the Database vault or the Label Security feature, you may skip this also.
STEP 10a. By default the memory settings is set at 40% of the total memory. If you have a much larger memory, you can set this at the minimum level of 4gb. Keep in mind that your settings would cause the database to immediately consume that much of memory upon startup.
STEP 10b. Leave the default setting of processes to 300 unless you anticipate more user connections beyond this value.
