ORACLE TWO NODE RAC INSTALLATION ON VMWARE WORKSTATION (PART-6)

Share via:

Post Views: 0

Dear Readers,

In this article we will see How to install Oracle software and creation of database. on RAC Environment .

Please check the below link :

How to install Oracle software on RAC Environment

To Install Oracle software we need download Oracle binaries for oracle.com

otherwise below link to download

File 1

https://drive.google.com/open?id=1B7zdsW-mAygSgfB6m1p4vyz3W_WyPIjG

File 2

https://drive.google.com/open?id=1dQLrvBFwy_tb0tEBb4B9veVi0KMQcN_B

After downloading copy the files into RAC1 Node and unzip the binaries

It will create database directory

Goto database directory and run ./runInstaller file

Unclick on Oracle support

Click on Next

select Skip software updates

Click on Next

Choose Install database software only

Click on Next

Choose Real Application Cluster database installation

SSH connectivity should setup

Click on Next

Select English Language

Click on Next

Choose Enterprise Edition

Click on Next

Specify Oracle Base and Software location

Click on Next

Group will be selected as DBA

Click on Next

Click on install

Installation process will be started

Automatically binaries will be copied from RAC1 to RAC2 node.

Run the Root scripts as Root user from both the nodes (RAC1& RAC2).

[oracle@RAC1 ~]$ su -
Password: 
[root@RAC1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

[oracle@RAC1 ~]$ su -

Password:

[root@RAC1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

From RAC2

[oracle@RAC2 ~]$ su -
Password: 
[root@RAC2 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

[oracle@RAC2 ~]$ su -

Password:

[root@RAC2 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

Finally Oracle Software was successfully installed

Create diskgroups in ASM for database :

Create two disk groups DATA and FRA connecting to ASM instance.

[oracle@RAC1 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[oracle@RAC1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 22 19:00:04 2019

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options
SQL>>

[oracle@RAC1 ~]$ . oraenv

ORACLE_SID = [oracle] ? +ASM1

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

[oracle@RAC1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 22 19:00:04 2019

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Real Application Clusters and Automatic Storage Management options

SQL>>

SQL> create diskgroup DATA external redundancy disk 'ORCL:DATA1','ORCL:DATA2';
Diskgroup created.

SQL> create diskgroup FRA external redundancy disk 'ORCL:FRA1','ORCL:FRA2';

Diskgroup created.