rhel7 安装 oracle 18c rac(01 grid软件安装)

简介: redhat7 18c安装。

rhel7 安装 oracle 18c rac(01 grid软件安装)
https://yq.aliyun.com/articles/627995
rhel7 安装 oracle 18c rac(02 database软件安装)
https://yq.aliyun.com/articles/628872
请参考rhel7 安装 oracle 18c rac(03 dbca 建立数据库)
https://yq.aliyun.com/articles/628876

系统版本:
Red Hat Enterprise Linux Server release 7.3 (Maipo)

数据库介质:
LINUX.X64_180000_db_home.zip
LINUX.X64_180000_grid_home.zip

主机配置:
192.168.0.200 prod04
192.168.0.201 prod04-vip
192.168.0.203 prod05
192.168.0.204 prod05-vip
192.168.0.205 scan

1 新建用户grid,oralce(prod04,prod05)

groupadd -g 1000 oinstall 
groupadd -g 1100 asmadmin 
groupadd -g 1200 dba 
groupadd -g 1201 oper 
groupadd -g 1300 asmdba 
groupadd -g 1301 asmoper 
useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper grid 
useradd -u 1101 -g oinstall -G dba,oper,asmdba,asmadmin oracle 
usermod oracle -g oinstall -G dba,oper,asmdba,asmadmin
echo oracle | passwd --stdin oracle
echo grid | passwd --stdin grid
chage -M 99999 oracle
chage -M 99999 grid
chage -l oracle
chage -l grid
echo grid001 | passwd  --stdin grid 
echo oracle001 | passwd --stdin oracle
mkdir /u01
chown grid:oinstall /u01/
mkdir -p /u01/app 
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle 
chown oracle:oinstall /u01/app/oracle 
chmod -R 775 /u01/ 

2,软件包安装(prod04,prod05)

yum install nfs-utils -y
yum install binutils-2*              -y
yum install compat-libstdc++*      -y
yum install glibc-2*                 -y
yum install ksh*                     -y
yum install libaio-0*                -y
yum install libgcc-4*                -y
yum install libstdc++-4*             -y
yum install make-3*                  -y
yum install compat-libcap1*          -y
yum install gcc-4*                   -y
yum install gcc-c++*                 -y
yum install glibc-devel-2*           -y
yum install libaio-devel-0*          -y
yum install libstdc++-devel-4*       -y
yum install sysstat-9*               -y
yum install elfutils-libelf-devel*   -y
yum install elfutils-libelf-devel*   -y
yum install elfutils-libelf-devel-0* -y
yum install sysstat -y
yum install -y smartmontools
yum install unzip -y 
yum install lrzsz -y
#fuser
yum install psmisc -y

#vnc Server
yum install -y tigervnc-server.x86_64
#安装图形终端
#yum groups install "Server with GUI" -y
#systemctl set-default graphical.target
# systemctl start graphical.target
yum install gnome-desktop* -y
yum install xterm -y

3,关闭防火墙和selinux(prod04,prod05)

setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
systemctl stop firewalld
systemctl disable firewalld
systemctl is-active firewalld
chkconfig iptables off
service iptables stop

4,配置主机名称和hosts文件(prod04,prod05)

[root@prod04 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.200    prod04
192.168.0.201    prod04-vip
192.168.0.203    prod05
192.168.0.204    prod05-vip
192.168.0.205    scan

5,重启2台操作主机系统(prod04,prod05)

# reboot

6,ams disk 配置(prod04,prod05)

# prod04 主机配置
[root@prod04 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Scan for Oracle ASM disks on boot (y/n) [y]: 
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@prod04 ~]# oracleasm createdisk disk01 /dev/sdb 
Device "/dev/sdb" is not a partition
[root@prod04 ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x4ab3201d.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): p
Partition number (1-4, default 1): 
First sector (2048-20971519, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519): 
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@prod04 ~]# fdisk /dev/sdc
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xdc0d68e9.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): p
Partition number (1-4, default 1): 
First sector (2048-104857599, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-104857599, default 104857599): 
Using default value 104857599
Partition 1 of type Linux and of size 50 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@prod04 ~]# 
[root@prod04 ~]# 
[root@prod04 ~]# oracleasm createdisk disk01 /dev/sdb1 
Writing disk header: done
Instantiating disk: done
[root@prod04 ~]# oracleasm createdisk disk02 /dev/sdc 
sdc   sdc1  
[root@prod04 ~]# oracleasm createdisk disk02 /dev/sdc1 
Writing disk header: done
Instantiating disk: done
[root@prod04 ~]# oracleasm listdisks
DISK01
DISK02

#prod05 配置


[root@prod05 tmp]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Scan for Oracle ASM disks on boot (y/n) [y]: 
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@prod05 tmp]# oracleasm scandisk
oracleasm: 'scandisk' is not an oracleasm command
Usage: oracleasm [--exec-path=<exec_path>] <command> [ <args> ]
       oracleasm --exec-path
       oracleasm -h
       oracleasm -V

The basic oracleasm commands are:
    configure        Configure the Oracle Linux ASMLib driver
    init             Load and initialize the ASMLib driver
    exit             Stop the ASMLib driver
    scandisks        Scan the system for Oracle ASMLib disks
    status           Display the status of the Oracle ASMLib driver
    listdisks        List known Oracle ASMLib disks
    querydisk        Determine if a disk belongs to Oracle ASMlib
    createdisk       Allocate a device for Oracle ASMLib use
    deletedisk       Return a device to the operating system
    renamedisk       Change the label of an Oracle ASMlib disk
    update-driver    Download the latest ASMLib driver
[root@prod05 tmp]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@prod05 tmp]# oracleasm listdisks
DISK01
DISK02

7,GRID 软件安装

01 ,grid用户解压软件到grid_home位置。

[grid@prod04 ~]$ unzip /soft/LINUX.X64_180000_grid_home.zip -d /u01/app/grid_home/

02.安装集群软件

[grid@prod04 ~]$ /u01/app/grid_home/gridSetup.sh

7.1 选择配置新的:

screenshot

7.2 选择standalone Cluster:

screenshot

7.3 scan配置:

screenshot

7.4 添加prod05节点,并配置ssh:

screenshot

7.5 网络配置:公有网络,心跳网络,asm网络

screenshot

7.6 存储配置,asm:

screenshot

7.7 gimr数据库配置:是否单独放置一个磁盘组,建议选择no.

screenshot

7.8 建立asm磁盘组:

asm外部模式,磁盘大小要求:
Cause-Insufficient space available in the selected Disks.

At least, 28.1 GB of free space is required. Action-Choose additional disks such that the total size should be at least 28.1 GB.
screenshot

7.9 设置asm密码:

screenshot

7.10 IPMI配置:

screenshot

7.11 EM配置:

screenshot

7.12 权限配置:

screenshot

7.13 BASE目录配置:

screenshot

7.14 Inventory目录配置:

screenshot

7.15 外部脚本配置:

screenshot

7.16 环境检预览

运行fix&check agin
screenshot
运行脚本,修复问题:
screenshot

PROD04

[root@prod04 ~]# 
[root@prod04 ~]# /tmp/GridSetupActions2018-08-23_09-37-11AM/CVU_18.0.0.0.0_grid/runfixup.sh 
All Fix-up operations were completed successfully.

PROD05

[root@prod05 tmp]# /tmp/GridSetupActions2018-08-23_09-37-11AM/CVU_18.0.0.0.0_grid/runfixup.sh 
All Fix-up operations were completed successfully.

缺少安装包Missing or Ignored package compat-libstdc++-33-3.2.3 causes Text Issues (文档 ID 2254198.1)

忽略部分错误:
screenshot

确认忽略错误:

screenshot

7.17 安装预览:

screenshot

7.18 安装进度预览:

screenshot

7.19 运行脚本

image

prod04

[root@prod04 ~]# 
[root@prod04 ~]# /u01/app/oraInventory/orainstRoot.sh 
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@prod04 ~]# /u01/grid_home/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/grid_home

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.


Creating /etc/oratab file...
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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/grid_home/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid_base/crsdata/prod04/crsconfig/rootcrs_prod04_2018-08-23_10-17-35PM.log
2018/08/23 22:17:59 CLSRSC-594: Executing installation step 1 of 20: 'SetupTFA'.
2018/08/23 22:18:00 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2018/08/23 22:18:32 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2018/08/23 22:18:32 CLSRSC-594: Executing installation step 2 of 20: 'ValidateEnv'.
2018/08/23 22:18:32 CLSRSC-363: User ignored prerequisites during installation
2018/08/23 22:18:32 CLSRSC-594: Executing installation step 3 of 20: 'CheckFirstNode'.
2018/08/23 22:18:36 CLSRSC-594: Executing installation step 4 of 20: 'GenSiteGUIDs'.
2018/08/23 22:18:42 CLSRSC-594: Executing installation step 5 of 20: 'SaveParamFile'.
2018/08/23 22:19:03 CLSRSC-594: Executing installation step 6 of 20: 'SetupOSD'.
2018/08/23 22:19:03 CLSRSC-594: Executing installation step 7 of 20: 'CheckCRSConfig'.
2018/08/23 22:19:03 CLSRSC-594: Executing installation step 8 of 20: 'SetupLocalGPNP'.
2018/08/23 22:19:45 CLSRSC-594: Executing installation step 9 of 20: 'CreateRootCert'.
2018/08/23 22:19:57 CLSRSC-594: Executing installation step 10 of 20: 'ConfigOLR'.
2018/08/23 22:20:23 CLSRSC-594: Executing installation step 11 of 20: 'ConfigCHMOS'.
2018/08/23 22:20:23 CLSRSC-594: Executing installation step 12 of 20: 'CreateOHASD'.
2018/08/23 22:20:40 CLSRSC-594: Executing installation step 13 of 20: 'ConfigOHASD'.
2018/08/23 22:20:41 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2018/08/23 22:21:24 CLSRSC-594: Executing installation step 14 of 20: 'InstallAFD'.
2018/08/23 22:21:42 CLSRSC-594: Executing installation step 15 of 20: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod04'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod04' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2018/08/23 22:22:40 CLSRSC-594: Executing installation step 16 of 20: 'InstallKA'.
2018/08/23 22:22:54 CLSRSC-594: Executing installation step 17 of 20: 'InitConfig'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod04'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod04' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'prod04'
CRS-2672: Attempting to start 'ora.mdnsd' on 'prod04'
CRS-2676: Start of 'ora.mdnsd' on 'prod04' succeeded
CRS-2676: Start of 'ora.evmd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'prod04'
CRS-2676: Start of 'ora.gpnpd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prod04'
CRS-2672: Attempting to start 'ora.gipcd' on 'prod04'
CRS-2676: Start of 'ora.cssdmonitor' on 'prod04' succeeded
CRS-2676: Start of 'ora.gipcd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'prod04'
CRS-2672: Attempting to start 'ora.diskmon' on 'prod04'
CRS-2676: Start of 'ora.diskmon' on 'prod04' succeeded
CRS-2676: Start of 'ora.cssd' on 'prod04' succeeded

[INFO] [DBT-30001] Disk groups created successfully. Check /u01/app/grid_base/cfgtoollogs/asmca/asmca-180823PM102340.log for details.


2018/08/23 22:24:34 CLSRSC-482: Running command: '/u01/grid_home/bin/ocrconfig -upgrade grid oinstall'
CRS-2672: Attempting to start 'ora.crf' on 'prod04'
CRS-2672: Attempting to start 'ora.storage' on 'prod04'
CRS-2676: Start of 'ora.storage' on 'prod04' succeeded
CRS-2676: Start of 'ora.crf' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'prod04'
CRS-2676: Start of 'ora.crsd' on 'prod04' succeeded
CRS-4256: Updating the profile
Successful addition of voting disk fb075f801e274f2bbf1f92d59e3304b2.
Successfully replaced voting disk group with +DATA.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   fb075f801e274f2bbf1f92d59e3304b2 (/dev/oracleasm/disks/DISK01) [DATA]
Located 1 voting disk(s).
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod04'
CRS-2673: Attempting to stop 'ora.crsd' on 'prod04'
CRS-2677: Stop of 'ora.crsd' on 'prod04' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'prod04'
CRS-2673: Attempting to stop 'ora.crf' on 'prod04'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prod04'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'prod04'
CRS-2677: Stop of 'ora.crf' on 'prod04' succeeded
CRS-2677: Stop of 'ora.storage' on 'prod04' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'prod04'
CRS-2677: Stop of 'ora.drivers.acfs' on 'prod04' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'prod04' succeeded
CRS-2677: Stop of 'ora.asm' on 'prod04' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'prod04'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'prod04' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'prod04'
CRS-2673: Attempting to stop 'ora.evmd' on 'prod04'
CRS-2677: Stop of 'ora.evmd' on 'prod04' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'prod04' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'prod04'
CRS-2677: Stop of 'ora.cssd' on 'prod04' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'prod04'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'prod04'
CRS-2677: Stop of 'ora.gpnpd' on 'prod04' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'prod04' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod04' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2018/08/23 22:27:42 CLSRSC-594: Executing installation step 18 of 20: 'StartCluster'.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'prod04'
CRS-2672: Attempting to start 'ora.evmd' on 'prod04'
CRS-2676: Start of 'ora.mdnsd' on 'prod04' succeeded
CRS-2676: Start of 'ora.evmd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'prod04'
CRS-2676: Start of 'ora.gpnpd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'prod04'
CRS-2676: Start of 'ora.gipcd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'prod04'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prod04'
CRS-2676: Start of 'ora.cssdmonitor' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'prod04'
CRS-2672: Attempting to start 'ora.diskmon' on 'prod04'
CRS-2676: Start of 'ora.diskmon' on 'prod04' succeeded
CRS-2676: Start of 'ora.crf' on 'prod04' succeeded
CRS-2676: Start of 'ora.cssd' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'prod04'
CRS-2672: Attempting to start 'ora.ctssd' on 'prod04'
CRS-2676: Start of 'ora.ctssd' on 'prod04' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'prod04'
CRS-2676: Start of 'ora.asm' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'prod04'
CRS-2676: Start of 'ora.storage' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'prod04'
CRS-2676: Start of 'ora.crsd' on 'prod04' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: prod04
CRS-6016: Resource auto-start has completed for server prod04
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2018/08/23 22:29:20 CLSRSC-343: Successfully started Oracle Clusterware stack
2018/08/23 22:29:21 CLSRSC-594: Executing installation step 19 of 20: 'ConfigNode'.
CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod04'
CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'prod04'
CRS-2676: Start of 'ora.asm' on 'prod04' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'prod04'
CRS-2676: Start of 'ora.DATA.dg' on 'prod04' succeeded
2018/08/23 22:31:46 CLSRSC-594: Executing installation step 20 of 20: 'PostConfig'.
2018/08/23 22:33:36 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

prod05

[root@prod05 ~]# /u01/app/oraInventory/orainstRoot.sh 
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@prod05 ~]# /u01/grid_home/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/grid_home

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.


Creating /etc/oratab file...
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.
Relinking oracle with rac_on option


Using configuration parameter file: /u01/grid_home/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid_base/crsdata/prod05/crsconfig/rootcrs_prod05_2018-08-23_10-34-01PM.log
2018/08/23 22:34:07 CLSRSC-594: Executing installation step 1 of 20: 'SetupTFA'.
2018/08/23 22:34:07 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2018/08/23 22:34:41 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2018/08/23 22:34:41 CLSRSC-594: Executing installation step 2 of 20: 'ValidateEnv'.
2018/08/23 22:34:41 CLSRSC-363: User ignored prerequisites during installation
2018/08/23 22:34:41 CLSRSC-594: Executing installation step 3 of 20: 'CheckFirstNode'.
2018/08/23 22:34:42 CLSRSC-594: Executing installation step 4 of 20: 'GenSiteGUIDs'.
2018/08/23 22:34:42 CLSRSC-594: Executing installation step 5 of 20: 'SaveParamFile'.
2018/08/23 22:34:46 CLSRSC-594: Executing installation step 6 of 20: 'SetupOSD'.
2018/08/23 22:34:46 CLSRSC-594: Executing installation step 7 of 20: 'CheckCRSConfig'.
2018/08/23 22:34:47 CLSRSC-594: Executing installation step 8 of 20: 'SetupLocalGPNP'.
2018/08/23 22:34:49 CLSRSC-594: Executing installation step 9 of 20: 'CreateRootCert'.
2018/08/23 22:34:49 CLSRSC-594: Executing installation step 10 of 20: 'ConfigOLR'.
2018/08/23 22:34:53 CLSRSC-594: Executing installation step 11 of 20: 'ConfigCHMOS'.
2018/08/23 22:34:53 CLSRSC-594: Executing installation step 12 of 20: 'CreateOHASD'.
2018/08/23 22:34:55 CLSRSC-594: Executing installation step 13 of 20: 'ConfigOHASD'.
2018/08/23 22:34:55 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2018/08/23 22:35:26 CLSRSC-594: Executing installation step 14 of 20: 'InstallAFD'.
2018/08/23 22:35:29 CLSRSC-594: Executing installation step 15 of 20: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod05'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod05' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2018/08/23 22:36:12 CLSRSC-594: Executing installation step 16 of 20: 'InstallKA'.
2018/08/23 22:36:14 CLSRSC-594: Executing installation step 17 of 20: 'InitConfig'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod05'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod05' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod05'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'prod05'
CRS-2677: Stop of 'ora.drivers.acfs' on 'prod05' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod05' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2018/08/23 22:36:25 CLSRSC-594: Executing installation step 18 of 20: 'StartCluster'.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.evmd' on 'prod05'
CRS-2672: Attempting to start 'ora.mdnsd' on 'prod05'
CRS-2676: Start of 'ora.evmd' on 'prod05' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'prod05'
CRS-2676: Start of 'ora.gpnpd' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'prod05'
CRS-2676: Start of 'ora.gipcd' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'prod05'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'prod05'
CRS-2676: Start of 'ora.cssdmonitor' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'prod05'
CRS-2672: Attempting to start 'ora.diskmon' on 'prod05'
CRS-2676: Start of 'ora.diskmon' on 'prod05' succeeded
CRS-2676: Start of 'ora.crf' on 'prod05' succeeded
CRS-2676: Start of 'ora.cssd' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'prod05'
CRS-2672: Attempting to start 'ora.ctssd' on 'prod05'
CRS-2676: Start of 'ora.ctssd' on 'prod05' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'prod05'
CRS-2676: Start of 'ora.asm' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'prod05'
CRS-2676: Start of 'ora.storage' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'prod05'
CRS-2676: Start of 'ora.crsd' on 'prod05' succeeded
CRS-6017: Processing resource auto-start for servers: prod05
CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod05'
CRS-2672: Attempting to start 'ora.ons' on 'prod05'
CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'prod05'
CRS-2676: Start of 'ora.ons' on 'prod05' succeeded
CRS-2676: Start of 'ora.asm' on 'prod05' succeeded
CRS-2672: Attempting to start 'ora.proxy_advm' on 'prod04'
CRS-2672: Attempting to start 'ora.proxy_advm' on 'prod05'
CRS-2676: Start of 'ora.proxy_advm' on 'prod04' succeeded
CRS-2676: Start of 'ora.proxy_advm' on 'prod05' succeeded
CRS-6016: Resource auto-start has completed for server prod05
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2018/08/23 22:38:21 CLSRSC-343: Successfully started Oracle Clusterware stack
2018/08/23 22:38:22 CLSRSC-594: Executing installation step 19 of 20: 'ConfigNode'.
2018/08/23 22:38:46 CLSRSC-594: Executing installation step 20 of 20: 'PostConfig'.
2018/08/23 22:38:54 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

7.20点击ok,确认运行脚本完成

这一步骤需要等待一段时间,需要配置GIMR数据库

image

7.21 ins-20802 报错

最后一个步骤验证集群(verification utility),可能出现报错。

image

确认忽略错误信息,点击OK,忽略该报错。

image

7.22 完成安装

点击next,继续下一步完成安装。

image

确认忽略错误信息:

image

退出安装程序,结束安装

image

8 配置环境变量,检查集群软件状态

PROD04

[grid@prod04 ~]$ cat .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
    . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export ORACLE_HOME=/u01/grid_home
export ORACLE_SID=+ASM1
export PATH=$PATH:$ORACLE_HOME/bin
[grid@prod04 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.DATA.GHCHKPT.advm
               OFFLINE OFFLINE      prod04                   STABLE
               OFFLINE OFFLINE      prod05                   STABLE
ora.DATA.dg
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.data.ghchkpt.acfs
               OFFLINE OFFLINE      prod04                   volume /opt/oracle/r
                                                             hp_images/chkbase is
                                                             unmounted,STABLE
               OFFLINE OFFLINE      prod05                   STABLE
ora.helper
               OFFLINE OFFLINE      prod04                   STABLE
               OFFLINE OFFLINE      prod05                   IDLE,STABLE
ora.net1.network
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.ons
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.proxy_advm
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       prod04                   STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       prod04                   Started,STABLE
      2        ONLINE  ONLINE       prod05                   Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       prod04                   STABLE
ora.mgmtdb
      1        OFFLINE OFFLINE                               Restricted Access,ST
                                                             ABLE
ora.prod04.vip
      1        ONLINE  ONLINE       prod04                   STABLE
ora.prod05.vip
      1        ONLINE  ONLINE       prod05                   STABLE
ora.qosmserver
      1        ONLINE  ONLINE       prod04                   STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       prod04                   STABLE
--------------------------------------------------------------------------------

PROD05

[grid@prod05 ~]$ cat .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
    . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export ORACLE_HOME=/u01/grid_home
export ORACLE_SID=+ASM2
export PATH=$PATH:$ORACLE_HOME/bin

[grid@prod05 ~]$ crsctl stat res -t 
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.DATA.GHCHKPT.advm
               OFFLINE OFFLINE      prod04                   STABLE
               OFFLINE OFFLINE      prod05                   STABLE
ora.DATA.dg
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.data.ghchkpt.acfs
               OFFLINE OFFLINE      prod04                   volume /opt/oracle/r
                                                             hp_images/chkbase is
                                                             unmounted,STABLE
               OFFLINE OFFLINE      prod05                   STABLE
ora.helper
               OFFLINE OFFLINE      prod04                   STABLE
               OFFLINE OFFLINE      prod05                   IDLE,STABLE
ora.net1.network
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.ons
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
ora.proxy_advm
               ONLINE  ONLINE       prod04                   STABLE
               ONLINE  ONLINE       prod05                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       prod04                   STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       prod04                   Started,STABLE
      2        ONLINE  ONLINE       prod05                   Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       prod04                   STABLE
ora.mgmtdb
      1        OFFLINE OFFLINE                               Restricted Access,ST
                                                             ABLE
ora.prod04.vip
      1        ONLINE  ONLINE       prod04                   STABLE
ora.prod05.vip
      1        ONLINE  ONLINE       prod05                   STABLE
ora.qosmserver
      1        ONLINE  ONLINE       prod04                   STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       prod04                   STABLE
--------------------------------------------------------------------------------
[grid@prod05 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@prod05 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@prod05 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@prod05 ~]$ 
相关文章
|
3月前
|
存储 Oracle 关系型数据库
|
3月前
|
Oracle 关系型数据库 网络安全
Oracle 19c 安装教程学习
Oracle 19c 安装教程学习
101 2
|
5月前
|
机器学习/深度学习 Oracle 关系型数据库
Oracle 19c单机一键安装脚本分享
Oracle 19c单机一键安装脚本分享
253 2
|
6月前
|
SQL Oracle 关系型数据库
MySQL、SQL Server和Oracle数据库安装部署教程
数据库的安装部署教程因不同的数据库管理系统(DBMS)而异,以下将以MySQL、SQL Server和Oracle为例,分别概述其安装部署的基本步骤。请注意,由于软件版本和操作系统的不同,具体步骤可能会有所变化。
409 3
|
3月前
|
存储 Oracle 关系型数据库
Oracle数据库的应用场景有哪些?
【10月更文挑战第15天】Oracle数据库的应用场景有哪些?
211 64
|
5月前
|
存储 自然语言处理 Oracle
Oracle数据库字符集概述及修改方式
【8月更文挑战第15天】Oracle 数据库字符集定义了数据的编码方案,决定可存储的字符类型及其表示方式。主要作用包括数据存储、检索及跨系统传输时的正确表示。常见字符集如 AL32UTF8 支持多语言,而 WE8MSWIN1252 主用于西欧语言。修改字符集风险高,可能导致数据问题,需事先备份并评估兼容性。可通过 ALTER DATABASE 语句直接修改或采用导出-导入数据的方式进行。完成后应验证数据完整性。此操作复杂,须谨慎处理。
124 5
|
23天前
|
存储 Oracle 关系型数据库
数据库数据恢复—ORACLE常见故障的数据恢复方案
Oracle数据库常见故障表现: 1、ORACLE数据库无法启动或无法正常工作。 2、ORACLE ASM存储破坏。 3、ORACLE数据文件丢失。 4、ORACLE数据文件部分损坏。 5、ORACLE DUMP文件损坏。
72 11
|
5月前
|
数据采集 Oracle 关系型数据库
实时计算 Flink版产品使用问题之怎么实现从Oracle数据库读取多个表并将数据写入到Iceberg表
实时计算Flink版作为一种强大的流处理和批处理统一的计算框架,广泛应用于各种需要实时数据处理和分析的场景。实时计算Flink版通常结合SQL接口、DataStream API、以及与上下游数据源和存储系统的丰富连接器,提供了一套全面的解决方案,以应对各种实时计算需求。其低延迟、高吞吐、容错性强的特点,使其成为众多企业和组织实时数据处理首选的技术平台。以下是实时计算Flink版的一些典型使用合集。
|
2月前
|
Oracle 关系型数据库 数据库
Oracle数据恢复—Oracle数据库文件有坏快损坏的数据恢复案例
一台Oracle数据库打开报错,报错信息: “system01.dbf需要更多的恢复来保持一致性,数据库无法打开”。管理员联系我们数据恢复中心寻求帮助,并提供了Oracle_Home目录的所有文件。用户方要求恢复zxfg用户下的数据。 由于数据库没有备份,无法通过备份去恢复数据库。
|
2月前
|
存储 Oracle 关系型数据库
oracle数据恢复—Oracle数据库文件大小变为0kb的数据恢复案例
存储掉盘超过上限,lun无法识别。管理员重组存储的位图信息并导出lun,发现linux操作系统上部署的oracle数据库中有上百个数据文件的大小变为0kb。数据库的大小缩水了80%以上。 取出&并分析oracle数据库的控制文件。重组存储位图信息,重新导出控制文件中记录的数据文件,发现这些文件的大小依然为0kb。