Set proper Oracle environment variables and execute dbca command to create new database.
Once dbca is executed Click on Next to continue.
Select Create a Database and Click on Next to continue.
Select appropriate template and Click on Next to continue.
Type Global Database name and SID value. Click on Next to continue.
Select configure Enterprise Manager option and Click on Next to continue.
Type Password for User Sys, System and other Admin users. Click on Next to continue.
Select Automatic Storage Management (ASM) on Storage Type Click on Browse to select the appropriate Disk Group.
Select the Disk Group and Click on OK to continue.
Once Disk group is select click on Next to continue.
Admin password for the ASM instance will be prompted. Type Administrative password of ASM instance and Click on OK to continue.
Select Specify Fast Recovery Area and Click on Browse to select the disk group for the FRA.
Once disk group for FRA is selected Click on Next to continue.
Select Sample Schema, It will contains the hr schema and its objects. Click on Next to continue.
Select the required memory size and Click on Next to continue.
Type the number of processes required and Click on Next to continue.
Select required character set and Click on Connection Mode to select required connection Mode.
Select required connection mode and click on Next to continue.
We can modify the location of the redo log file and controlfile. Click on Next to continue.
Confirmation window will be displayed Click on Save as an HTML file to save the summary as the html file.
Provide the summary file name and location an click on save to save the response file.
Database creation will begin.
Warning message will be displayed Click on OK to continue.
Finally Summary will be displayed. Click on Exit to finish database creation. For password and user management Click on Password Management.
Nice! This tutorial is really detailed and helpful.
ReplyDelete