AWS Administration - 100% Lab - Online Training | AKSWAVE
21
Nov

Oracle 12c RAC Database Creation

  • 4.5
  • Reviews : 1,030

DBCA enables you to create both policy-managed and administrator-managed databases. With DBCA, you can create site-specific tablespaces as part of database creation. If you have data file requirements that differ from those offered by DBCA templates, then create your database with DBCA and modify the data files later. You can also run user-specified scripts as part of your database creation process.


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

[[email protected]]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/bin

[[email protected] 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)

[[email protected]]$ 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.

[[email protected]]$ . oraenv

ORACLE_SID = [oracle] ? orcl1

 

[[email protected]]$ 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.

[[email protected]]$ su - root

[[email protected]]# . oraenv

ORACLE_SID = [root] ? +ASM1

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

[[email protected]]# srvctl status database -d orcl

Instance orcl1 is running on node node1

Instance orcl2 is running on node node2


Close all terminal windows opened for these practices. Congratulations! You have successfully configured an Oracle Database 12c Standard Cluster with ASM and a RAC database.
Akal Singh
Oracle Certified Master, 20+ yrs exp
Akal Singh stands at the forefront of the fastest moving technologies in IT Industry. He spent his past 20 years as Oracle DBA with skills into DBA Support, High Availability Design & Implementations, Technical Solutions, Automation using Scripting, Database Designing & as a Corporate Trainer too. With deep technical industry knowledge, Akal Singh has implemented many real time projects on advance Database areas.

His certification list includes many OCP, Oracle Certified Expert/Specialist (OCE) and Oracle Certified Master (OCM). He is an expertise in OS Administrations, Virtualizations/VMWare and Oracle Database 8i/9i/10g/11g & 12c, RAC, Data Guard, ASM, Oracle Exadata, Oracle Performance Tuning, Golden Gate, Streams, Oracle Security & many more advance technologies.

Akal Singh is also recognized as Senior Corporate Instructor and worked with Oracle University training division providing more than 300 corporate trainings into database advance concepts.

Certifications include :
  • Oracle Certified Professional (OCP) 9i
  • Oracle Certified Professional (OCP) 10g
  • Oracle Certified Professional (OCP) 11g
  • Oracle 10g Certified RAC Expert (OCE)
  • Oracle 11g Certified Expert (RAC) and Grid Infrastructure (OCE)
  • Oracle 10g Certified Master (OCM)
  • Oracle 11g Exadata Certified Implementation Specialist
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle Exadata X5 Administration
  • Oracle RAC 11g Release 2 and Grid Infrastructure Administration
  • Foundation Certificate in IT Service Management  ( ITIL Certificate ) 

Related Course

RAC Administration

( 5)
Reviews : 2,734

Classroom

 12,000

 14,000

14% Off

Online

 20,000

 22,000

9% Off

Related Documents

Oracle 12c Standard Cluster Installation

This chapter describes the operating system tasks you must complete on your servers before you install Oracle Grid Infrastructure for a cluster and Oracle Real Application Clusters (Oracle RAC). The values provided in this chapter are installation minimum only. Oracle recommends that you configure production systems in accordance with planned system loads.

Working with CLUVFY utility

The Cluster Verification Utility (CVU) performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation steps so that your Oracle Grid Infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation completes successfully.

Oracle 12c RAC Database Creation

DBCA enables you to create both policy-managed and administrator-managed databases. With DBCA, you can create site-specific tablespaces as part of database creation. If you have data file requirements that differ from those offered by DBCA templates, then create your database with DBCA and modify the data files later. You can also run user-specified scripts as part of your database creation process.

0 Comments

Post a Comment