Overview

In this practice you will create an Oracle RAC database were you already you have Oracle software installed. you can use VNC or GUI console of the node for doing database creation.

1.       Using the same oracle terminal session from the previous practice, change directory to /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/ and execute dbca.

      Perform below steps in vnc viewer

[oracle@node1]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/bin

[oracle@node1 bin]$ ./dbca

2.       On the Database Operation screen, click Next to accept the default selection (Create Database).

3.       On the Creation Mode screen, click Next to accept the default selection (Advanced Mode).

4.       On the Database Template screen, change Confguration Type to Admin-Managed

Admin - Managed RAC Database using the General Purpose template).

5.       On the Database Identification screen, specify orcl as the Global Database Name and click Next.

6.       On the Select Nodes screen,  click on “>>” button to select all nodes on which nodes your database instances should run. Click Next to proceed.

7.    On the Management Options screen, click Next to accept the default selections 

(Configure EM Database Express and Run CVU Checks Periodically).

8.       On the Database Credentials screen, select "Use the Same Administrative Passwords for All Accounts‟ and enter "oracle_4U" as password, then click next.

9.       On the Storage Locations screen, make sure storage Type is ASM and make the following adjustments:

·         Database File Locations: +DATA

·         Fast Recovery Area: +FRA

·         Fast Recovery Area Size: 4785

Due to Space constraints in our Lab environment, Ignore the warning regarding the size of the Fast Recovery Area. Once your values match the values above, Click Next to continue.

10.   On the Database Options screen just click  on Next.

11.   On the Memory tab, in the Initialization Parameters screen, set Memory Size (SGA and PGA) to 800, Uncheck Automatic Memory Management(AMM) and click on the Character Sets tab.

12.   On the Character Sets tab, in the Initialization Parameters screen, select Use Unicode (AL32UTF8) and click Next.

13.   On the Creation Options screen, click Next to accept the default selection (Create Database).

14.   Wait while a series of prerequisite checks are performed.

15.   Examine the Summary screen. When you are ready, click Finish to start the database creation process.

16.   Follow the database creation process on the Progress Page.

17.   Examine the dialog which indicates that the database creation process is completed. Take note of theEM Database Express URL. When you are ready, click Exit continue.

18.   Click Close to quit the Database Configuration Assistant.

19.   Open /etc/oratab file add instance entries (perform the step on both the nodes orcl1 on node1 and orcl2 on node2)

[oracle@node1]$ vi /etc/oratab

orcl1:/u01/app/oracle/product/12.1.0.2/dbhome_1:N

:wq

20.   Back in the oracle user terminal, configure the environment using the oraenv script. Enter orcl1 when you are prompted for an ORACLE_SID value, and configure  remote_listener  parameter.

[oracle@node1]$ . oraenv

ORACLE_SID = [oracle] ? orcl1

[oracle@node1]$ sqlplus / as sysdba

SQL> alter system set remote_listener='scan-clust1.aks.com:1521' scope=both sid='*';

System altered.

21.   Use the srvctl command to check on which cluster nodes the database instances are running.

[oracle@node1]$ su - root

[root@node1]# . oraenv

ORACLE_SID = [root] ? +ASM1

The Oracle base has been set to /u01/app/grid

[root@node1]# srvctl status database -d orcl

Instance orcl1 is running on node node1

Instance orcl2 is running on node node2