• 单实例asm,修改主机名和ip地址后的重配置+集群重新配置GI


    修改主机名和ip地址之后的reconfigure asm

    参考资料:How to Reconfigure Oracle Restart (文档 ID 986740.1)

    [root@lxtrac04 bin]# ./crsctl stop has
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'lxtrac04'
    CRS-2673: Attempting to stop 'ora.cdb.db' on 'lxtrac04'
    CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'lxtrac04'
    CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'lxtrac04' succeeded
    CRS-2677: Stop of 'ora.cdb.db' on 'lxtrac04' succeeded
    CRS-2673: Attempting to stop 'ora.TEST.dg' on 'lxtrac04'
    CRS-2677: Stop of 'ora.TEST.dg' on 'lxtrac04' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'lxtrac04'
    CRS-2677: Stop of 'ora.asm' on 'lxtrac04' succeeded
    CRS-2673: Attempting to stop 'ora.evmd' on 'lxtrac04'
    CRS-2677: Stop of 'ora.evmd' on 'lxtrac04' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'lxtrac04'
    CRS-2677: Stop of 'ora.cssd' on 'lxtrac04' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'lxtrac04' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    [root@lxtrac04 bin]#
    1.修改主机名:
    [root@lxtrac04 bin]# hostnamectl --static set-hostname erwadba.co.com
    2.修改ip地址 将ip地址有172.32.231.235修改到10.10.10.10
    [root@erwadba ~]# cat /etc/sysconfig/network-scripts/ifcfg-ens32
    TYPE=Ethernet
    BOOTPROTO=no
    DEFROUTE=yes
    IPV4_FAILURE_FATAL=no
    NAME=ens32
    UUID=5d220321-604c-4d09-b30f-78fc7d088fca
    DEVICE=ens32
    ONBOOT=yes
    #IPADDR=172.32.231.235
    IPADDR=10.10.10.10
    NETMASK=255.255.255.0
    GATEWAY=172.32.231.193
    [root@erwadba ~]#
    3.执行deconfig
    # $GRID_HOME/crs/install/roothas.pl -deconfig -force
    在执行roothas.pl的时候报如下错误,说明环境参数不对
    [root@erwadba ~]# /u01/app/12.2.0.1/grid/crs/install/roothas.pl -deconfig -force
    Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . /u01/app/12.2.0.1/grid/crs/install /u01/app/12.2.0.1/grid/crs/install/../../perl/lib) at /u01/app/12.2.0.1/grid/crs/install/crsinstall.pm line 286.
    BEGIN failed--compilation aborted at /u01/app/12.2.0.1/grid/crs/install/crsinstall.pm line 286.
    Compilation failed in require at /u01/app/12.2.0.1/grid/crs/install/roothas.pl line 97.
    BEGIN failed--compilation aborted at /u01/app/12.2.0.1/grid/crs/install/roothas.pl line 97.
    [root@erwadba ~]#
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++
    查询mos。需要使用GI自己的perl
    rootcrs.pl/roothas.pl Fails With Can't locate Env.pm (文档 ID 2019784.1)
    The fix is included in 12.1.0.2, the workaround is to use the perl in GI home.

    Example :

    /u01/app/oracle/product/11.2.0.4/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.4/grid/crs/install/roothas.pl -deconfig -force
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++
    [root@erwadba ~]# /u01/app/12.2.0.1/grid/perl/bin/perl /u01/app/12.2.0.1/grid/crs/install/roothas.pl -deconfig -force
    Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba/crsconfig/hadeconfig.log
    PRCR-1070 : Failed to check if resource ora.ons is registered
    CRS-0184 : Cannot communicate with the CRS daemon.
    2018/04/27 17:05:38 CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0.1/grid/bin/srvctl config ons'
    2018/04/27 17:05:52 CLSRSC-337: Successfully deconfigured Oracle Restart stack
    [root@erwadba ~]#
    4.重新配置crs
    # $GRID_HOME/crs/install/roothas.pl
    [root@erwadba ~]# /u01/app/12.2.0.1/grid/perl/bin/perl /u01/app/12.2.0.1/grid/crs/install/roothas.pl
    Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba/crsconfig/roothas_2018-04-28_08-10-05AM.log
    Oracle Clusterware infrastructure error in OCRCONFIG (OS PID 24897): CLSD/ADR initialization failed with return value -1
    1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
    DIA-49802: missing read, write, or execute permission on specified ADR home directory [/u01/app/grid/diag/crs/erwadba/crs/log]
    DIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]
    DIA-48188: user missing read, write, or exec permission on specified directory
    Linux-x86_64 Error: 13: Permission denied <<<<<<<<<<权限不对
    Additional information: 2
    Additional information: 511
    Additional information: 16888
    ([all diagnostic data retrieved from ADR])]
    2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/u01/app/grid] Product Type: [CRS] Host Name: [erwadba] Instance ID: [crs] User Name: [grid]]

    Oracle Clusterware infrastructure error in CLSCFG (OS PID 24907): CLSD/ADR initialization failed with return value -1
    1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
    DIA-49802: missing read, write, or execute permission on specified ADR home directory [/u01/app/grid/diag/crs/erwadba/crs/log]
    DIA-49801: actual permissions [rwxrwx---], expected minimum permissions [rwxrwxrwx] for effective user [grid]
    DIA-48188: user missing read, write, or exec permission on specified directory
    Linux-x86_64 Error: 13: Permission denied <<<<<<<<<<权限不对
    Additional information: 2
    Additional information: 511
    Additional information: 16888
    ([all diagnostic data retrieved from ADR])]
    2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/u01/app/grid] Product Type: [CRS] Host Name: [erwadba] Instance ID: [crs] User Name: [grid]]

    LOCAL ADD MODE
    Creating OCR keys for user 'grid', privgrp 'oinstall'..
    Operation successful.
    LOCAL ONLY MODE
    Successfully accumulated necessary OCR keys.
    Creating OCR keys for user 'root', privgrp 'root'..
    Operation successful.
    CRS-4664: Node erwadba successfully pinned.
    2018/04/28 08:10:16 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
    2018/04/28 08:12:21 CLSRSC-214: Failed to start the resource 'ohasd'
    Failed to start the Clusterware. Last 20 lines of the alert log follow:
    2018-04-28 08:10:59.407
    [client(26857)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 26857
    2018-04-28 08:10:59.418
    [client(26857)]CRS-2112:The OLR service started on node erwadba.
    2018-04-28 08:11:01.003
    [client(26949)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 26949
    2018-04-28 08:11:01.014
    [client(26949)]CRS-2112:The OLR service started on node erwadba.
    2018-04-28 08:11:02.613
    [client(27040)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 27040
    2018-04-28 08:11:02.623
    [client(27040)]CRS-2112:The OLR service started on node erwadba.
    2018-04-28 08:11:04.208
    [client(27132)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 27132
    2018-04-28 08:11:04.219
    [client(27132)]CRS-2112:The OLR service started on node erwadba.
    2018-04-28 08:11:05.849
    [client(27229)]CRS-8500:Oracle Clusterware OHASD process is starting with operating system process ID 27229
    2018-04-28 08:11:05.861
    [client(27229)]CRS-2112:The OLR service started on node erwadba.

    2018/04/28 08:12:22 CLSRSC-318: Failed to start Oracle OHASD service
    Died at /u01/app/12.2.0.1/grid/crs/install/crsinstall.pm line 2775.
    [root@erwadba ~]#

    从上面输出的结果,发现文件目录的权限不对。修改为正确的属主。再次执行roothas.pl。配置成功
    [root@erwadba crs]# ll
    total 12
    drwxrwx--- 2 root root 20 Apr 27 16:30 alert
    drwxrwx--- 2 root root 6 Apr 27 14:59 cdump
    drwxrwx--- 2 root root 6 Apr 27 14:59 incident
    drwxrwx--- 2 root root 6 Apr 27 14:59 incpkg
    drwxrwx--- 2 root root 4096 Apr 27 14:59 lck
    drwxrwx--- 4 root root 29 Apr 27 14:59 log
    drwxrwx--- 2 root root 4096 Apr 27 14:59 metadata
    drwxrwx--- 2 root root 6 Apr 27 14:59 metadata_dgif
    drwxrwx--- 2 root root 6 Apr 27 14:59 metadata_pv
    drwxrwx--- 2 root root 6 Apr 27 14:59 stage
    drwxrwx--- 2 root root 6 Apr 27 14:59 sweep
    drwxrwx--- 2 root root 4096 Apr 28 08:10 trace
    [root@erwadba crs]# chown grid:oinstall * -R
    [root@erwadba ~]# /u01/app/12.2.0.1/grid/perl/bin/perl /u01/app/12.2.0.1/grid/crs/install/roothas.pl
    Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba/crsconfig/roothas_2018-04-28_08-17-32AM.log
    LOCAL ADD MODE
    Creating OCR keys for user 'grid', privgrp 'oinstall'..
    Operation successful.
    LOCAL ONLY MODE
    Successfully accumulated necessary OCR keys.
    Creating OCR keys for user 'root', privgrp 'root'..
    Operation successful.
    CRS-4664: Node erwadba successfully pinned.
    2018/04/28 08:17:43 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba'
    CRS-2673: Attempting to stop 'ora.evmd' on 'erwadba'
    CRS-2677: Stop of 'ora.evmd' on 'erwadba' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    CRS-4123: Oracle High Availability Services has been started.

    erwadba 2018/04/28 08:18:54 /u01/app/12.2.0.1/grid/cdata/erwadba/backup_20180428_081854.olr 0
    2018/04/28 08:18:55 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
    [root@erwadba ~]#
    5.添加asm资源
    $ srvctl add asm
    [grid@erwadba ~]$ srvctl add asm
    6.启动asm资源
    $ srvctl start asm
    [grid@erwadba ~]$ srvctl start asm
    [grid@erwadba ~]$
    7.创建asm的spfile
    [grid@erwadba ~]$ sqlplus / as sysasm
    SQL*Plus: Release 12.2.0.1.0 Production on Sat Apr 28 08:24:37 2018
    Copyright (c) 1982, 2016, Oracle. All rights reserved.
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    SQL> select name,state from v$asm_diskgroup;
    NAME STATE
    ------------------------------ -----------
    TEST DISMOUNTED
    SQL> alter diskgroup test mount;
    Diskgroup altered.
    SQL> ho cat asm.txt
    +ASM.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
    *.asm_diskstring='/dev/sd*'
    *.asm_power_limit=1
    *.large_pool_size=12M
    *.remote_login_passwordfile='EXCLUSIVE'
    SQL> create spfile='+TEST' from pfile='/home/grid/asm.txt';
    File created.
    SQL>
    8.重启has stack
    [root@erwadba ~]# /u01/app/12.2.0.1/grid/bin/crsctl stop has
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba'
    CRS-2673: Attempting to stop 'ora.evmd' on 'erwadba'
    CRS-2673: Attempting to stop 'ora.TEST.dg' on 'erwadba'
    CRS-2677: Stop of 'ora.TEST.dg' on 'erwadba' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'erwadba'
    CRS-2677: Stop of 'ora.evmd' on 'erwadba' succeeded
    CRS-2677: Stop of 'ora.asm' on 'erwadba' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'erwadba'
    CRS-2677: Stop of 'ora.cssd' on 'erwadba' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    [root@erwadba ~]# /u01/app/12.2.0.1/grid/bin/crsctl start has
    CRS-4123: Oracle High Availability Services has been started.
    [root@erwadba ~]#
    9.添加数据库资源,并启动
    [oracle@erwadba ~]$ srvctl add database -db CDB -oraclehome $ORACLE_HOME -spfile +TEST/CDB/PARAMETERFILE/spfile.274.974547727
    [oracle@erwadba ~]$ srvctl start database -db cdb
    10.添加listener,并启动
    [grid@erwadba admin]$ srvctl add listener
    [grid@erwadba admin]$ srvctl start listener
    [grid@erwadba admin]$

    ========================================================================================================================================================== 

    集群重新配置GI。

    参考资料:如何(Deconfigure)解除配置/(Reconfigure)重新配置(重建 OCR)或卸载 GI (文档 ID 2016852.1)

    根据mos文档的步骤,重新配置gi
    1.在节点2上deconfig GI
    [root@erwadba2 install]# ./rootcrs.pl -deconfig -force -verbose
    Using configuration parameter file: ./crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba2/crsconfig/crsdeconfig_erwadba2_2018-07-23_02-40-13PM.log
    PRCR-1070 : Failed to check if resource ora.net1.network is registered
    CRS-0184 : Cannot communicate with the CRS daemon.
    PRCR-1070 : Failed to check if resource ora.helper is registered
    CRS-0184 : Cannot communicate with the CRS daemon.
    PRCR-1070 : Failed to check if resource ora.ons is registered
    CRS-0184 : Cannot communicate with the CRS daemon.

    2018/07/23 14:40:24 CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0.1/grid/bin/srvctl config nodeapps'
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.evmd' on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.driver.afd' on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.gipcd' on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'erwadba2'
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'erwadba2'
    CRS-2677: Stop of 'ora.drivers.acfs' on 'erwadba2' succeeded
    CRS-2677: Stop of 'ora.driver.afd' on 'erwadba2' succeeded
    CRS-2677: Stop of 'ora.cssdmonitor' on 'erwadba2' succeeded
    CRS-2677: Stop of 'ora.evmd' on 'erwadba2' succeeded
    CRS-2677: Stop of 'ora.gpnpd' on 'erwadba2' succeeded
    CRS-2677: Stop of 'ora.gipcd' on 'erwadba2' succeeded
    CRS-2677: Stop of 'ora.mdnsd' on 'erwadba2' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba2' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    2018/07/23 14:40:46 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 14:42:40 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 14:42:41 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
    [root@erwadba2 install]#
    2.在节点1上执行
    [root@erwadba1 install]# ./rootcrs.pl -deconfig -force -verbose -lastnode
    Using configuration parameter file: ./crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba1/crsconfig/crsdeconfig_erwadba1_2018-07-23_02-44-39PM.log
    PRCR-1070 : Failed to check if resource ora.net1.network is registered
    CRS-0184 : Cannot communicate with the CRS daemon.
    PRCR-1070 : Failed to check if resource ora.helper is registered
    CRS-0184 : Cannot communicate with the CRS daemon.
    PRCR-1070 : Failed to check if resource ora.ons is registered
    CRS-0184 : Cannot communicate with the CRS daemon.

    2018/07/23 14:44:50 CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0.1/grid/bin/srvctl config nodeapps'
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.evmd' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.driver.afd' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.gipcd' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'erwadba1'
    CRS-2677: Stop of 'ora.drivers.acfs' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.cssdmonitor' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.driver.afd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.evmd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.gipcd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.mdnsd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.gpnpd' on 'erwadba1' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba1' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    2018/07/23 14:45:12 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 14:46:55 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 14:46:56 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
    [root@erwadba1 install]#

    节点1上执行root.sh。重新配置GI
    [root@erwadba1 grid]# /u01/app/12.2.0.1/grid/root.sh
    Performing root user operation.

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

    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.
    Relinking oracle with rac_on option
    Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba1/crsconfig/rootcrs_erwadba1_2018-07-23_03-44-16PM.log
    2018/07/23 15:44:18 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
    2018/07/23 15:44:18 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 15:44:43 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 15:44:43 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
    2018/07/23 15:44:46 CLSRSC-363: User ignored prerequisites during installation
    2018/07/23 15:44:46 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
    2018/07/23 15:44:48 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
    2018/07/23 15:44:49 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'.
    2018/07/23 15:44:54 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'.
    2018/07/23 15:44:55 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'.
    2018/07/23 15:44:55 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'.
    2018/07/23 15:45:13 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
    2018/07/23 15:45:19 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
    2018/07/23 15:45:19 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
    2018/07/23 15:45:23 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
    2018/07/23 15:45:38 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
    2018/07/23 15:46:07 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
    2018/07/23 15:46:11 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba1'
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba1' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    CRS-4123: Oracle High Availability Services has been started.
    2018/07/23 15:46:37 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
    2018/07/23 15:46:41 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba1'
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba1' 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 'erwadba1'
    CRS-2672: Attempting to start 'ora.mdnsd' on 'erwadba1'
    CRS-2676: Start of 'ora.mdnsd' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.evmd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.gpnpd' on 'erwadba1'
    CRS-2676: Start of 'ora.gpnpd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'erwadba1'
    CRS-2672: Attempting to start 'ora.gipcd' on 'erwadba1'
    CRS-2676: Start of 'ora.cssdmonitor' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.gipcd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.cssd' on 'erwadba1'
    CRS-2672: Attempting to start 'ora.diskmon' on 'erwadba1'
    CRS-2676: Start of 'ora.diskmon' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.cssd' on 'erwadba1' succeeded

    Disk groups created successfully. Check /u01/app/grid/cfgtoollogs/asmca/asmca-180723PM034717.log for details.


    2018/07/23 15:47:50 CLSRSC-482: Running command: '/u01/app/12.2.0.1/grid/bin/ocrconfig -upgrade grid oinstall'
    CRS-2672: Attempting to start 'ora.crf' on 'erwadba1'
    CRS-2672: Attempting to start 'ora.storage' on 'erwadba1'
    CRS-2676: Start of 'ora.storage' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.crf' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.crsd' on 'erwadba1'
    CRS-2676: Start of 'ora.crsd' on 'erwadba1' succeeded
    CRS-4256: Updating the profile
    Successful addition of voting disk 031110c86e2a4f61bfd4ea115902b2b4.
    Successfully replaced voting disk group with +OCR.
    CRS-4256: Updating the profile
    CRS-4266: Voting file(s) successfully replaced
    ## STATE File Universal Id File Name Disk group
    -- ----- ----------------- --------- ---------
    1. ONLINE 031110c86e2a4f61bfd4ea115902b2b4 (/dev/mapper/asm3ParArb01p1) [OCR]
    Located 1 voting disk(s).
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.crsd' on 'erwadba1'
    CRS-2677: Stop of 'ora.crsd' on 'erwadba1' succeeded
    CRS-2673: Attempting to stop 'ora.storage' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.crf' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'erwadba1'
    CRS-2677: Stop of 'ora.drivers.acfs' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.crf' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.gpnpd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.storage' on 'erwadba1' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'erwadba1'
    CRS-2677: Stop of 'ora.mdnsd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.asm' on 'erwadba1' succeeded
    CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'erwadba1'
    CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'erwadba1' succeeded
    CRS-2673: Attempting to stop 'ora.ctssd' on 'erwadba1'
    CRS-2673: Attempting to stop 'ora.evmd' on 'erwadba1'
    CRS-2677: Stop of 'ora.evmd' on 'erwadba1' succeeded
    CRS-2677: Stop of 'ora.ctssd' on 'erwadba1' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'erwadba1'
    CRS-2677: Stop of 'ora.cssd' on 'erwadba1' succeeded
    CRS-2673: Attempting to stop 'ora.gipcd' on 'erwadba1'
    CRS-2677: Stop of 'ora.gipcd' on 'erwadba1' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba1' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    2018/07/23 15:48:38 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
    CRS-4123: Starting Oracle High Availability Services-managed resources
    CRS-2672: Attempting to start 'ora.evmd' on 'erwadba1'
    CRS-2672: Attempting to start 'ora.mdnsd' on 'erwadba1'
    CRS-2676: Start of 'ora.mdnsd' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.evmd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.gpnpd' on 'erwadba1'
    CRS-2676: Start of 'ora.gpnpd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.gipcd' on 'erwadba1'
    CRS-2676: Start of 'ora.gipcd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'erwadba1'
    CRS-2676: Start of 'ora.cssdmonitor' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.cssd' on 'erwadba1'
    CRS-2672: Attempting to start 'ora.diskmon' on 'erwadba1'
    CRS-2676: Start of 'ora.diskmon' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.cssd' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'erwadba1'
    CRS-2672: Attempting to start 'ora.ctssd' on 'erwadba1'
    CRS-2676: Start of 'ora.ctssd' on 'erwadba1' succeeded
    CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.asm' on 'erwadba1'
    CRS-2676: Start of 'ora.asm' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.storage' on 'erwadba1'
    CRS-2676: Start of 'ora.storage' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.crf' on 'erwadba1'
    CRS-2676: Start of 'ora.crf' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.crsd' on 'erwadba1'
    CRS-2676: Start of 'ora.crsd' on 'erwadba1' succeeded
    CRS-6023: Starting Oracle Cluster Ready Services-managed resources
    CRS-6017: Processing resource auto-start for servers: erwadba1
    CRS-6016: Resource auto-start has completed for server erwadba1
    CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
    CRS-4123: Oracle High Availability Services has been started.
    2018/07/23 15:50:08 CLSRSC-343: Successfully started Oracle Clusterware stack
    2018/07/23 15:50:08 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
    CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'erwadba1'
    CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.asm' on 'erwadba1'
    CRS-2676: Start of 'ora.asm' on 'erwadba1' succeeded
    CRS-2672: Attempting to start 'ora.OCR.dg' on 'erwadba1'
    CRS-2676: Start of 'ora.OCR.dg' on 'erwadba1' succeeded
    2018/07/23 15:51:20 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
    2018/07/23 15:51:39 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
    [root@erwadba1 grid]#


    节点2上执行root.sh

    [root@erwadba2 grid]# /u01/app/12.2.0.1/grid/root.sh
    Performing root user operation.

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

    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.
    Relinking oracle with rac_on option
    Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params
    The log of current session can be found at:
    /u01/app/grid/crsdata/erwadba2/crsconfig/rootcrs_erwadba2_2018-07-23_03-56-34PM.log
    2018/07/23 15:56:35 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
    2018/07/23 15:56:35 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 15:57:01 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
    2018/07/23 15:57:01 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
    2018/07/23 15:57:02 CLSRSC-363: User ignored prerequisites during installation
    2018/07/23 15:57:02 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
    2018/07/23 15:57:03 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
    2018/07/23 15:57:03 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'.
    2018/07/23 15:57:05 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'.
    2018/07/23 15:57:06 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'.
    2018/07/23 15:57:06 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'.
    2018/07/23 15:57:08 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
    2018/07/23 15:57:10 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
    2018/07/23 15:57:10 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
    2018/07/23 15:57:11 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
    2018/07/23 15:57:26 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
    2018/07/23 15:57:51 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
    2018/07/23 15:57:52 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba2'
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba2' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    CRS-4123: Oracle High Availability Services has been started.
    2018/07/23 15:58:16 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
    2018/07/23 15:58:17 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'erwadba2'
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba2' 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 'erwadba2'
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'erwadba2'
    CRS-2677: Stop of 'ora.drivers.acfs' on 'erwadba2' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'erwadba2' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    2018/07/23 15:58:34 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
    CRS-4123: Starting Oracle High Availability Services-managed resources
    CRS-2672: Attempting to start 'ora.evmd' on 'erwadba2'
    CRS-2672: Attempting to start 'ora.mdnsd' on 'erwadba2'
    CRS-2676: Start of 'ora.mdnsd' on 'erwadba2' succeeded
    CRS-2676: Start of 'ora.evmd' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.gpnpd' on 'erwadba2'
    CRS-2676: Start of 'ora.gpnpd' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.gipcd' on 'erwadba2'
    CRS-2676: Start of 'ora.gipcd' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'erwadba2'
    CRS-2676: Start of 'ora.cssdmonitor' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.cssd' on 'erwadba2'
    CRS-2672: Attempting to start 'ora.diskmon' on 'erwadba2'
    CRS-2676: Start of 'ora.diskmon' on 'erwadba2' succeeded
    CRS-2676: Start of 'ora.cssd' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'erwadba2'
    CRS-2672: Attempting to start 'ora.ctssd' on 'erwadba2'
    CRS-2676: Start of 'ora.ctssd' on 'erwadba2' succeeded
    CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.asm' on 'erwadba2'
    CRS-2676: Start of 'ora.asm' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.storage' on 'erwadba2'
    CRS-2676: Start of 'ora.storage' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.crf' on 'erwadba2'
    CRS-2676: Start of 'ora.crf' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.crsd' on 'erwadba2'
    CRS-2676: Start of 'ora.crsd' on 'erwadba2' succeeded
    CRS-6017: Processing resource auto-start for servers: erwadba2
    CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'erwadba2'
    CRS-2672: Attempting to start 'ora.net1.network' on 'erwadba2'
    CRS-2676: Start of 'ora.net1.network' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.ons' on 'erwadba2'
    CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'erwadba2' succeeded
    CRS-2672: Attempting to start 'ora.asm' on 'erwadba2'
    CRS-2676: Start of 'ora.ons' on 'erwadba2' succeeded
    CRS-2676: Start of 'ora.asm' on 'erwadba2' succeeded
    CRS-6016: Resource auto-start has completed for server erwadba2
    CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
    CRS-4123: Oracle High Availability Services has been started.
    2018/07/23 16:00:06 CLSRSC-343: Successfully started Oracle Clusterware stack
    2018/07/23 16:00:06 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
    2018/07/23 16:00:17 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
    2018/07/23 16:00:25 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
    [root@erwadba2 grid]#

    点击继续的时候,出现了一个小插曲
    界面报错
    Action?-?You may chose to retry the operation, without continuing further. Alternatively you can refer to information given below and manually execute the mentioned commands on the failed nodes now or later to update the inventory. More Details
    Execute the following command on node(s) [erwadba2]:

    /u01/app/12.2.0.1/grid/oui/bin/runInstaller -jreLoc /u01/app/12.2.0.1/grid/jdk/jre -paramFile /u01/app/12.2.0.1/grid/oui/clusterparam.ini -silent -ignoreSysPrereqs -updateNodeList -bigCluster ORACLE_HOME=/u01/app/12.2.0.1/grid CLUSTER_NODES=erwadba2 "NODES_TO_SET={erwadba1,erwadba2}" -invPtrLoc "/u01/app/12.2.0.1/grid/oraInst.loc" -local CRS=true -doNotUpdateNodeList

    按要求执行即可
    [root@erwadba1 grid]# su - grid
    Last login: Mon Jul 23 16:07:16 CST 2018
    [grid@erwadba1 ~]$ /u01/app/12.2.0.1/grid/oui/bin/runInstaller -updateNodeList -setCustomNodelist -noClusterEnabled ORACLE_HOME=/u01/app/12.2.0.1/grid "CLUSTER_NODES={erwadba1,erwadba2}" "NODES_TO_SET={erwadba1,erwadba2}" CRS=true "INVENTORY_LOCATION=/u01/app/oraInventory" LOCAL_NODE=erwadba1
    Starting Oracle Universal Installer...

    Checking swap space: must be greater than 500 MB. Actual 32767 MB Passed

    [grid@erwadba1 ~]$


    crs重新配置成功。后面的添加磁盘和单实例情况差不多。

  • 相关阅读:
    SQLite的SQL语法
    C/C++中各种类型int、long、double、char表示范围(最大最小值)
    君子性非异也,善假于物也
    简单工厂模式
    Linux下通配符总结
    Readprocessmemory使用方法
    C++ 清空消息队列
    一周自学动态站点设计
    iOS 8.0正式公布啦
    What is the difference between JRE,JVM and JDK?
  • 原文地址:https://www.cnblogs.com/erwadba/p/8965792.html
Copyright © 2020-2023  润新知