In this post we will be discussing over Database Installation on ASM (which is discussed in my previous posts – follow my old posts for ASM Disk Groups and other related information).
Note: Before we start installing, we must complete all our perquisites for sure.
Go to the the location where oracle database software has been download and extracted. Execute runInstaller from the same folder:
For ASM Configuration, it is always recommended that you only install the software first and create the database later.
As this is for Single Database Installation, we will select the option accordingly.
We will go for Enterprise Edition to get the full fledged features with free license.
Before we go ahead and select the directories, make sure these directories really exist physically.
Select the OS Groups for the required Roles.
As this one is just Test Machine, we can ignore SWAP Memory check for now.
Press Yes for the confirmation.
Verify the detail below and Click on Install.
Execute the script from root user.
Make sure, whenever you execute root.sh it will ask you to replace the file from /usr/local/bin directory if you have Oracle Installed on your machine previously. So if there are no custom changes made by you or your team in oraenv, coraenv or dnhome then you can replace it with the new on or else type “n” to ignore it.
Installation is successful click Close.
Creating the database:
Now we have the Software Installed, we will be creating a database using dbca:
Select the required option and Press Next…
Select the required Template and Press Next…
Select the name for your database, you can keep Global Database Name and SID same, however i always recommend to keep Global Name with Domain and SIS as it is. Press Next…
For now we will not be using EM in our environment, so i just unchecked the option. As this blog whole purpose to create database using ASM. Press Next..
Configure the password, as this is just a Test Environment, we can keep the same password.
Here we go, this is the location where we actually have to select, ASM Location using ASM from Storage Type. Select the required one from the list, we created DATA for datafiles so we will be using the same.
So we selected DATA, for ASMs all file system starts from “+”
Below we are selecting LOG to keep Archive Log and Backup Pieces.
Press Next after you verify everything has been setup correctly:
Select the SGA and PGA Size, it is recommended that we always check the “Use Automatic Memory Management” to handle SGA and PGA memory share automatically by Oracle.
Normally i prefer to use AL32UTF8 character sets for my database because it supports global language as well. Press Next..
So finally we are proceeding with – Creating a Database. Click Finish…
Verify everything and Press OK.
So database installation has been started..
Once its done, you will get the below with basic detail of your database like SPFILE Location of our database. Click EXIT.
UI will be closed once we click on EXIT button. Now we can verify our database status from back end and front end too.
Check out the database files location. If you see below its +DATA.
Fast Recovery Area is +LOG.
That’s all Guys.
Hope it helps…