Oracle11gR2安装RAC错误之--HOSTS文件错误-mysql教程-PHP中文网

首页

数据库

mysql教程

Oracle11gR2安装RAC错误之--HOSTS文件错误

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 02:52 PM

rac安装错误

Oracle 11gR2 安装RAC错误之--HOSTS文件错误系统环境：操作系统：RedHat EL5 Cluster： Oracle GI( Grid Infrastructure) Oracle： Oracle 11.2.0.1.0 如图所示：RAC 系统架构 650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151214

Oracle 11gR2 安装RAC错误之--HOSTS文件错误

系统环境：

操作系统：RedHat EL5

Cluster： Oracle GI(Grid Infrastructure)

Oracle： Oracle 11.2.0.1.0

如图所示：RAC 系统架构

对于Oracle 11G构建RAC首先需要构建GI(Grid Infrastructure)的架构

错误现象：

节点2运行root.sh脚本错误：

[root@hk2 ~]# /u01/11.2.0/grid/root.sh

Running Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...
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.sh script.
Now product-specific root actions will be performed.
2014-07-07 17:04:37: Parsing the host name
2014-07-07 17:04:37: Checking for super user privileges
2014-07-07 17:04:37: User has super user privileges
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE 
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node hk1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
CRS-2672: Attempting to start 'ora.mdnsd' on 'hk2'
CRS-2676: Start of 'ora.mdnsd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'hk2'
CRS-2676: Start of 'ora.gipcd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'hk2'
CRS-2676: Start of 'ora.gpnpd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'hk2'
CRS-2676: Start of 'ora.cssdmonitor' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'hk2'
CRS-2672: Attempting to start 'ora.diskmon' on 'hk2'
CRS-2676: Start of 'ora.diskmon' on 'hk2' succeeded
CRS-2676: Start of 'ora.cssd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'hk2'
CRS-2676: Start of 'ora.ctssd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'hk2'
CRS-2676: Start of 'ora.drivers.acfs' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'hk2'
CRS-2676: Start of 'ora.asm' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'hk2'
CRS-2676: Start of 'ora.crsd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'hk2'
CRS-2676: Start of 'ora.evmd' on 'hk2' succeeded
Timed out waiting for the CRS stack to start.

查看日志：

[root@hk2 crsd]# ls

core.12152 core.15934 core.16128 crsd.log crsdOUT.log crsd.trc

[root@hk2 crsd]# tail crsdOUT.log

Unable to resolve address for localhost:2016

ONS runtime exiting

Fatal error: eONS: eonsapi.c: Aug 4 2009 21:09:36

2014-07-07 17:55:31

Changing directory to /u01/11.2.0/grid/log/hk2/crsd

2014-07-07 17:55:31

CRSD REBOOT

Unable to resolve address for localhost:2016

ONS runtime exiting

Fatal error: eONS: eonsapi.c: Aug 4 2009 21:09:36

[root@hk2 crsd]# more crsdOUT.log

2014-07-07 17:08:23

Changing directory to /u01/11.2.0/grid/log/hk2/crsd

2014-07-07 17:08:23

CRSD REBOOT

Unable to resolve address for localhost:2016

ONS runtime exiting

Fatal error: eONS: eonsapi.c: Aug 4 2009 21:09:36

......

错误提示，无法解析localhost主机！

查看/etc/hosts文件：

[root@hk2 crsd]# cat /etc/hosts

# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.56.101  hk1
192.168.56.103  hk2
10.10.10.101  hk1-priv
10.10.10.103  hk2-priv
192.168.56.104 hk1-vip
192.168.56.105 hk2-vip
192.168.56.106 hk-scan

缺少对localhost的解析！

解决方法：

1、编辑/etc/hosts文件

[root@hk1 bin]# cat /etc/hosts

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1  localhost
192.168.56.101  hk1
192.168.56.103  hk2
10.10.10.101  hk1-priv
10.10.10.103  hk2-priv
192.168.56.104 hk1-vip
192.168.56.105 hk2-vip
192.168.56.106 hk-scan

2、删除CRS的配置，重新运行root.sh

[root@hk2 install]# perl rootcrs.pl -deconfig -force

2014-07-07 18:09:51: Parsing the host name
2014-07-07 18:09:51: Checking for super user privileges
2014-07-07 18:09:51: User has super user privileges
Using configuration parameter file: ./crsconfig_params
PRCR-1035 : Failed to look up CRS resource ora.cluster_vip.type for 1
PRCR-1068 : Failed to query resources
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.gsd is registered
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.ons is registered
Cannot communicate with crsd
PRCR-1070 : Failed to check if resource ora.eons is registered
Cannot communicate with crsd
ACFS-9200: Supported
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'hk2'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'hk2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'hk2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'hk2'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'hk2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'hk2'
CRS-2673: Attempting to stop 'ora.evmd' on 'hk2'
CRS-2673: Attempting to stop 'ora.asm' on 'hk2'
CRS-2677: Stop of 'ora.cssdmonitor' on 'hk2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'hk2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'hk2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'hk2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'hk2' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'hk2' succeeded
CRS-2677: Stop of 'ora.asm' on 'hk2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'hk2'
CRS-2677: Stop of 'ora.cssd' on 'hk2' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'hk2'
CRS-2673: Attempting to stop 'ora.gipcd' on 'hk2'
CRS-2677: Stop of 'ora.gipcd' on 'hk2' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'hk2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'hk2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
error: package cvuqdisk is not installed
Successfully deconfigured Oracle clusterware stack on this node

重新运行root.sh：

[root@hk2 install]# /u01/11.2.0/grid/root.sh

Running Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying coraenv to /usr/local/bin ...
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.sh script.
Now product-specific root actions will be performed.
2014-07-07 18:11:35: Parsing the host name
2014-07-07 18:11:35: Checking for super user privileges
2014-07-07 18:11:35: User has super user privileges
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE 
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node hk1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
CRS-2672: Attempting to start 'ora.mdnsd' on 'hk2'
CRS-2676: Start of 'ora.mdnsd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'hk2'
CRS-2676: Start of 'ora.gipcd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'hk2'
CRS-2676: Start of 'ora.gpnpd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'hk2'
CRS-2676: Start of 'ora.cssdmonitor' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'hk2'
CRS-2672: Attempting to start 'ora.diskmon' on 'hk2'
CRS-2676: Start of 'ora.diskmon' on 'hk2' succeeded
CRS-2676: Start of 'ora.cssd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'hk2'
CRS-2676: Start of 'ora.ctssd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'hk2'
CRS-2676: Start of 'ora.drivers.acfs' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'hk2'
CRS-2676: Start of 'ora.asm' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'hk2'
CRS-2676: Start of 'ora.crsd' on 'hk2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'hk2'
CRS-2676: Start of 'ora.evmd' on 'hk2' succeeded
hk2     2014/07/07 18:13:53     /u01/11.2.0/grid/cdata/hk2/backup_20140707_181353.olr
Preparing packages for installation...
cvuqdisk-1.0.7-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 4095 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.

@脚本运行成功！

3、验证

[root@hk2 bin]# ./crs_stat -t

Name           Type           Target    State     Host        
------------------------------------------------------------
ora.eons       ora.eons.type  ONLINE    ONLINE    hk1         
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora.hk1.gsd    application    OFFLINE   OFFLINE               
ora.hk1.ons    application    ONLINE    ONLINE    hk1         
ora.hk1.vip    ora....t1.type ONLINE    ONLINE    hk1         
ora.hk2.gsd    application    OFFLINE   OFFLINE               
ora.hk2.ons    application    ONLINE    ONLINE    hk2         
ora.hk2.vip    ora....t1.type ONLINE    ONLINE    hk2         
ora....network ora....rk.type ONLINE    ONLINE    hk1         
ora.ons        ora.ons.type   ONLINE    ONLINE    hk1

@至此，问题解决！

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

MySQL：初学者的基本技能Apr 18, 2025 am 12:24 AM

MySQL适合初学者学习数据库技能。1.安装MySQL服务器和客户端工具。2.理解基本SQL查询，如SELECT。3.掌握数据操作：创建表、插入、更新、删除数据。4.学习高级技巧：子查询和窗口函数。5.调试和优化：检查语法、使用索引、避免SELECT*，并使用LIMIT。

MySQL：结构化数据和关系数据库Apr 18, 2025 am 12:22 AM

MySQL通过表结构和SQL查询高效管理结构化数据，并通过外键实现表间关系。1.创建表时定义数据格式和类型。2.使用外键建立表间关系。3.通过索引和查询优化提高性能。4.定期备份和监控数据库确保数据安全和性能优化。

MySQL：解释的关键功能和功能Apr 18, 2025 am 12:17 AM

MySQL是一个开源的关系型数据库管理系统，广泛应用于Web开发。它的关键特性包括：1.支持多种存储引擎，如InnoDB和MyISAM，适用于不同场景；2.提供主从复制功能，利于负载均衡和数据备份；3.通过查询优化和索引使用提高查询效率。

SQL的目的：与MySQL数据库进行交互Apr 18, 2025 am 12:12 AM

SQL用于与MySQL数据库交互，实现数据的增、删、改、查及数据库设计。1）SQL通过SELECT、INSERT、UPDATE、DELETE语句进行数据操作；2）使用CREATE、ALTER、DROP语句进行数据库设计和管理；3）复杂查询和数据分析通过SQL实现，提升业务决策效率。

初学者的MySQL：开始数据库管理Apr 18, 2025 am 12:10 AM

MySQL的基本操作包括创建数据库、表格，及使用SQL进行数据的CRUD操作。1.创建数据库：CREATEDATABASEmy_first_db;2.创建表格：CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY,titleVARCHAR(100)NOTNULL,authorVARCHAR(100)NOTNULL,published_yearINT);3.插入数据：INSERTINTObooks(title,author,published_year)VA

MySQL的角色：Web应用程序中的数据库Apr 17, 2025 am 12:23 AM

MySQL在Web应用中的主要作用是存储和管理数据。1.MySQL高效处理用户信息、产品目录和交易记录等数据。2.通过SQL查询，开发者能从数据库提取信息生成动态内容。3.MySQL基于客户端-服务器模型工作，确保查询速度可接受。

mysql：构建您的第一个数据库Apr 17, 2025 am 12:22 AM

构建MySQL数据库的步骤包括：1.创建数据库和表，2.插入数据，3.进行查询。首先，使用CREATEDATABASE和CREATETABLE语句创建数据库和表，然后用INSERTINTO语句插入数据，最后用SELECT语句查询数据。

MySQL：一种对数据存储的初学者友好方法Apr 17, 2025 am 12:21 AM

MySQL适合初学者，因为它易用且功能强大。1.MySQL是关系型数据库，使用SQL进行CRUD操作。2.安装简单，需配置root用户密码。3.使用INSERT、UPDATE、DELETE、SELECT进行数据操作。4.复杂查询可使用ORDERBY、WHERE和JOIN。5.调试需检查语法，使用EXPLAIN分析查询。6.优化建议包括使用索引、选择合适数据类型和良好编程习惯。

See all articles