<<Back to Oracle RAC Main Page
Creating Oracle RAC Database Post Oracle Clusterware Installation
Once you are done with Oracle Grid Infrastructure Installation and Oracle Database Software Installation you are ready create your first RAC database.
STEP1: Launch DBCA
login as oracle user and set ORACLE_HOME
$export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db1
Execute dbca from ORACLE_HOME/bin and follow the GUI instruction as shown below
$cd /u01/app/oracle/product/12.2.0.1/db1
./dbca
choose create database and click Next
Choose advanced Configuration and click Next
Click Next
Select all the nodes on which you want to create the database and click Next
Choose appropriate (As per your requirement)Value for each field and Click Next
Choose the Appropriate Disk Group (in my case it is DATA) and click Next
You can enable the archivelog and specify the FRA (Flash Recovery Area) Location and Size. In this example I kept the archiving disabled. If left disabled you can enable it later
Choose appropriate Memory Options and define the required characterset from Character Set Tab and click Next
if you do not want to configure EM Express then untick it and click Next
Enter the Password and click Next
Click Next
Click finish to create the database
STEP2: Verify the Installation log
Post successful database creation validate the log files under $ORACLE_BASE/ cfgtoollogs/dbca/ (in my case /u01/app/oracle/cfgtoollogs/dbca/orcl) and ensure there is no error.
STEP3: Check the availability of the database
$ srvctl status database -d orcl
Instance orcl1 is running on node node1
Instance orcl2 is running on node node2
STEP4: check the configuration of the database
[oracle@node1 orcl]$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/12.2.0.1/db1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.947351843
Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.947351319
Domain: oracle.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: ORCL1,ORCL2
Configured nodes: node1,node2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Comments
Post a Comment