Shulou(Shulou.com)06/01 Report--

Environmental preparation

Oracle VM:3.4.2

Node 1:

-CPU&MEM: 4C8GB-HOSTNAME: pnode01-IP: 10.20.1.130-VIP: 10.20.1.132-PRIV-IP: 192.168.1.100-OS: Oracle Linux 7.5

Node 2:

-CPU&MEM: 4C8GB-HOSTNAME: pnode02-IP: 10.20.1.131-VIP: 10.20.1.133-PRIV-IP: 192.168.1.101-OS: Oracle Linux 7.5

Oracle Database: 12.2.0.1

In order to achieve shared storage, you need to create disks of type shareable:

Then mount the shared disk to two nodes:

System software package

The following software packages are required to install grid and database:

Bcbinutils-2.23.52.0.1-12.el7 (x86 / 64) compat-libcap1-1.10-3.el7 (x86 / 64) compat-libstdc++-33-3.2.3-71.el7 (i686) compat-libstdc++-33-3.2.3-71.el7 (x86 / 64) glibc-2.17-36.el7 (i686) glibc-2.17-36.el7 (x86 / 64) glibc-devel-2.17-36.el7 (i686) glibc-devel-2. 17-36.el7 (x86 / 64) kshlibaio-0.3.109-9.el7 (i686) libaio-0.3.109-9.el7 (x86 / 64) libaio-devel-0.3.109-9.el7 (i686) libaio-devel-0.3.109-9.el7 (x86 / 64) libX11-1.6.0-2.1.el7 (i686) libX11-1.6.0-2.1.el7 (x86 / 64) libXau-1.0.8-2.1. El7 (i686) libXau-1.0.8-2.1.el7 (x86'64) libXi-1.7.2-1.el7 (i686) libXi-1.7.2-1.el7 (x86'64) libXtst-1.2.2-1.el7 (i686) libXtst-1.2.2-1.el7 (x86'64) libgcc-4.8.2-3.el7 (i686) libgcc-4.8.2-3.el7 (x86'64) libstdc++-4.8.2- 3.el7 (i686) libstdc++-4.8.2-3.el7 (x86'64) libstdc++-devel-4.8.2-3.el7 (i686) libstdc++-devel-4.8.2-3.el7 (x86'64) libxcb-1.9-5.el7 (i686) libxcb-1.9-5.el7 (x86'64) make-3.82-19.el7 (x86'64) nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS) Net-tools-2.0-0.17.20131004git.el7 (x86 / 64) (for Oracle RACand Oracle Clusterware) smartmontools-6.2-4.el7 (x86 / 64) sysstat-10.1.5-1.el7 (x86 / 64)

Starting with Oracle Linux 6, Oracle provides a RPM to easily install the software packages needed by the system, as long as you execute:

Yum install oracle-database-server-12cR2-preinstall

The system will automatically install all the required software packages and set the system parameters required at the time of installation.

Installation of GRID

Copy the installation package for grid to the installation path of Node 1, and then extract it (see another article, "how to install Oracle 12.2 GRID") and run gridSetup.sh:

Select to configure the new cluster, the next step:

Oracle Domain Service Cluster and Oracle Member Cluster are added, and these two types of Cluster are mainly for database cloud services. What we are creating here is a stand-alone cluster, and this type of cluster is not needed for the time being, so choose Standalone Cluster.

Oracle introduced the concept of SCAN from 11g. Since we do not use DNS here, warnings and errors about SCAN may occur later, just ignore it and do not affect normal use.

Configure basic information for Node 1 and Node 2, ensure SSH connectivity, and then configure the network card:

Prior to the installation, the eth0 segment 10.20.1 was planned as a public network, while the eth2 segment 192.168.1 was used as an ASM and private network. Then configure ASM:

NFS can be used directly at the beginning, but we choose block devices here. And then the next step:

12.2 adds the concept of GIMR. The so-called GIMR is actually a database used to store cluster information, which can be deployed in a single disk group or share a disk group with OCR. It should be noted here that if you choose to share a disk group with OCR, the capacity of the disk group needs to be more than 40G (prepared to say 3850MB), otherwise there will be an error of insufficient space. We choose to share disk groups with OCR here. The next step is to create an OCR disk group:

The next installer will check whether the capacity of the disk group meets the requirements, and an error will be reported if the capacity is not met, and no further steps can be taken. So OCR's disks should be allocated larger at the beginning of the planning.

Then set the SYS and ASMSNMP passwords, here to facilitate the two accounts' passwords to be the same and use a relatively simple password. In actual production, it is recommended to set it separately for security reasons, and use a complex password (the installer checks to see if the password meets the requirements).

Configure IPMI, using the default options, not IPMI. And then the next step:

Configure EM. If the organization uses EM for management can be configured. Then the next step is to configure user groups and software paths:

All you have to do here is configure the path of Oracle base. Then configure the path to inventory:

After the final check is clear, start the installation:

It still takes some time to install the configuration, and it took more than an hour to install it on the virtual machine of this configuration.

Installation of Database

There is basically not much change compared to the installation of grid,database. Here we only install the database software, and the operation of building the database will be carried out later. Perhaps the only change is the choice of the system user group, with several more:

In other words, permissions are divided into more details: backups, high availability, clusters, and so on, are all assigned groups separately. Here they are all set to dba for convenience. In practice, it still needs to be set up according to their actual situation.

Finally, complete the installation.

Create a cluster database

Use the dbca tool to create a cluster database.

We use advanced mode to create the database. During the creation process, you need to pay attention to the following points:

1. Database deployment type, which needs to be RAC.

2. You need to select all the nodes (here are pnode01 and pnode02)

3. The type of database, CDB or non-CDB, needs to be selected according to the actual needs. Select the CDB type here and create a PDB

Then it is to configure various parameters of the database, including data file path and size, online log path and size, archive path, memory size, number of processes, passwords, and so on, which need to be done in the early planning. Finally, the creation is completed:

Finally, we verify the status of the following databases:

You can see that the database is running properly on pnode01 and pnode02.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.