Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about the failure caused by Oracle11gR2 grid stand-alone using asm storage to modify the host name. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Environment:

System: Aix 7.1

Database version: 11.2.0.3.11

one。 Problem description:

After the AIX 7.1 operating system modifies the hostname and restarts the server, the reasons why the css and ohasd services cannot be started are analyzed:

Grid cannot change hostname

If you change the standalone, you have to reconfigure the restart.

If you change the hostname in cluster, you can only use the method of adding or deleting nodes.

This document is about reconfiguring Oracle restart. If the server (host) is renamed, one reason for this operation may be.

If this is a caseand server restart, then ASM startup will fail, ora-29701.

The solution is to reconfigure Oracle restart. Has check:

[root@itpux grid] # crsctl start has

CLSU-00100: Operating System function:opendir failed with error data: 2

CLSU-00101: Operating System error message:No such file or directory

CLSU-00103: error location: scrsearch2

CLSU-00104: additional error information:cant open scr home dir scls_scr_getval

CRS-4000: Command Start failed, orcompleted with errors. [root@itpux grid] # hostname

Itpuxcss check:

[root@itpux grid] # crsctl check css

CRS-4639: Could not contact Oracle HighAvailability Services

CRS-4000: Command Check failed, orcompleted with errors.

Start + asm instance and report an error:

[grid@itpux grid] $sqlplus / as asmdba

SQL*Plus: Release 11.2.0.4.0 Production onSun Sep 28 13:12:11 2015

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

Connected to an idle instance.

SQL > startup

ORA-01078: failure in processing systemparameters

ORA-29701: unable to connect to Cluster Synchronization Service

SQL >

two。 Solution reference documentation:

How to Reconfigure Oracle Restart (document ID 986740.1) implementation steps:

1. Remove the Oracle restart configuration, which should be done with a privileged root user.

[root@itpux grid] # $ORACLE_HOME/crs/install/roothas.pl-deconfig-force

Using configuration parameter file:/u01/app/11.2.0/grid/crs/install/crsconfig_params

CRS-4639: Could not contact Oracle HighAvailability Services

CRS-4000: Command Stop failed, or completedwith errors.

CRS-4639: Could not contact Oracle HighAvailability Services

CRS-4000: Command Delete failed, orcompleted with errors.

CLSU-00100: Operating System function:opendir failed with error data: 2

CLSU-00101: Operating System error message:No such file or directory

CLSU-00103: error location: scrsearch2

CLSU-00104: additional error information:cant open scr home dir scls_scr_getval

CRS-4544: Unable to connect to OHAS

CRS-4000: Command Stop failed, or completedwith errors.

Successfully deconfigured Oracle Restartstack2. Reconfigure the Oracle restart component, which should also be performed with the privileged root user.

[root@node1bak grid] # $ORACLE_HOME/crs/install/roothas.pl

Using configuration parameter file:/u01/app/11.2.0/grid/crs/install/crsconfig_params

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 node1bak successfully pinned.

Adding Clusterware entries to inittab

Node1bak 2016/09/1811:20:40 / u01/app/11.2.0/grid/cdata/node1bak/backup_20160918_112040.olr

Successfully configured Oracle Grid Infrastructure for aStandalone Server3. Add ASM to the Oracle restart configuration, this step uses the grid facility owner grid user action.

[grid@itpux~] $srvctl add asm4. Start the ASM instance, which requires the grid user.

[grid@itpux~] $srvctl start asm5. Recreate the ASM server parameter file, using the grid user.

Vi / tmp/init+ASM.ora

Asm_diskgroups='DATA','RECO'

Instance_type='asm'

Large_pool_size=12M

Remote_login_passwordfile='EXCLUSIVE'

Asm_diskstring='/dev/sdb*'

Mount the disk group where the new server parameter file (SPFILE) will reside (e.g. DATA) and create SPFILE:$ sqlplus / as sysasm

SQL > startup pfile='/tmp/init+ASM.ora'

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size 2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ASM diskgroups mounted

ASM diskgroups volume enabledSQL > create spfile='+DATA' from pfile='/tmp/init+ASM.ora'

File created.SQL > show parameter pfile

NAME TYPE VALUE

-

Spfile stringSQL > shutdown immediate

ASM diskgroups volume disabled

ASM diskgroups dismounted

ASM instance shutdownSQL > startup

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size 2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ASM diskgroups mounted

ASM diskgroups volume enabled6. Restart the has service

[root@itpux grid] # crsctl stop has

CRS-2791: Starting shutdown of Oracle HighAvailability Services-managed resources on 'node1bak'

CRS-2673: Attempting to stop 'ora.DATA.dg'on' node1bak'

CRS-2677: Stop of 'ora.DATA.dg' on'node1bak' succeeded

CRS-2679: Attempting to clean 'ora.DATA.dg'on' node1bak'

CRS-2681: Clean of 'ora.DATA.dg' on'node1bak' succeeded

CRS-2673: Attempting to stop 'ora.asm' on'node1bak'

CRS-2677: Stop of 'ora.asm' on' node1bak'succeeded

CRS-2673: Attempting to stop 'ora.cssd' on'node1bak'

CRS-2677: Stop of 'ora.cssd' on' node1bak'succeeded

CRS-2673: Attempting to stop 'ora.evmd' on'node1bak'

CRS-2677: Stop of 'ora.evmd' on' node1bak'succeeded

CRS-2793: Shutdown of Oracle HighAvailability Services-managed resources on 'node1bak' has completed

CRS-4133: Oracle High Availability Serviceshas been stopped. [root@itpux grid] # crsctl start has

CRS-4123: Oracle High Availability Serviceshas been started.7. Add components back to the Oracle restart configuration

If you have databases, monitors, and other components, add them to the Oracle restart configuration at 7. 1. Adding a database component requires oracle user execution.

[oracle@itpux] $srvctl add database-dorcl-o / u01/app/oracle/product/11.2.0/dbhome_17.2. The grid user is required to add the listening component.

[grid@itpux] $srvctl add listener8. Finally, start the database.

[oracle@itpux ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production onSun Sep 28 14:12:11 2015

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

Connected to an idle instance.SQL > startup

ORACLE instance started.

Total System Global Area 1235959808 bytes

Fixed Size 2252784 bytes

Variable Size 738197520 bytes

Database Buffers 486539264 bytes

Redo Buffers 8970240 bytes

Database mounted.

Database opened.

This is the end of the article on "what to do if the Oracle11gR2 grid single computer uses asm storage to modify the host name". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.