Run DBCA utility from oracle user. You have to set ORACLE_HOME AND ORACLE_SID
[oracle@exadb01 dbhome]$ . oraenv ORACLE_SID = [oracle] ? ORCL ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome/ The Oracle base has been set to /u01/app/oracle [oracle@exadb01 dbhome]$ dbca
Select Database Type and Click Next..
Click Next..
Select Template based on your requirement. Click Next…
Provide Configuration Type and Database Name. For RAC database, must select all available Nodes and Click Next…
Deselect the Configure Enterprise Manager option (better to install agent for OEM later). Click Next…
Click on ‘Automatic Maintenance Tasks and Choose ‘Enable automatic Maintenance tasks’ option. Click Next..
Provide the password for sys and system users. Click Next.
Enter DiskGroup Name for Database Datafile. Click Next..
Click ‘Multiplex Redo Logs and Control Files’ Button and provide DiskGroup name for multiplexing. This is highly recommended to multiplex the Redo Logs and Control Files as these are mission critical files in database.
Select ASM Diskgroup for Fast Recovery Area where archive file will be saved. Choose Enable Archiving option based on your requirement. Click Next.
For real life DB (company’s Database), not recommended to create sample schemas. But your personal use, you may choose sample Schemas. Click Next.
From Memory Tab, Set memory for SGA and PGA. Check “Use Automatic Memory Management” and Click Next.
Click on Character Sets Tab and Choose right Character Set for your database. Click Next..
Recheck all database file configuration and Click Next
Select Create Database Option and Click Finish.
Database configuration progressing.
Click Exit. You can change password for default schema later. Installation completed successfully.
[grid@exadb01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
ora.FRA.dg
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
ora.LISTENER.lsnr
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
ora.OCR.dg
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
ora.asm
ONLINE ONLINE exadb01 Started
ONLINE ONLINE exadb02 Started
ora.gsd
OFFLINE OFFLINE exadb01
OFFLINE OFFLINE exadb02
ora.net1.network
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
ora.ons
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
ora.registry.acfs
ONLINE ONLINE exadb01
ONLINE ONLINE exadb02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE exadb01
ora.cvu
1 ONLINE ONLINE exadb01
ora.exadb01.vip
1 ONLINE ONLINE exadb01
ora.exadb02.vip
1 ONLINE ONLINE exadb02
ora.oc4j
1 ONLINE ONLINE exadb01
ora.orcl.db
1 ONLINE ONLINE exadb01 Open
2 ONLINE ONLINE exadb02 Open
ora.scan1.vip
1 ONLINE ONLINE exadb01
