aix oracle9i rac,AIX上安装Oracle9iRAC出现FailedtostartGSDonlocalnode

本文主要是介绍aix oracle9i rac,AIX上安装Oracle9iRAC出现FailedtostartGSDonlocalnode,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

5268f80b9b1e01f982625ef6fac83ca1.png

最近做一个数据库迁移项目,安装ORACLE 9i RAC在建库时,出现Failed to start GSD on local node,解决过程如下:testa:/oracle/

最近做一个数据库迁移项目,安装Oracle 9i RAC在建库时,,出现Failed to start GSD on local node,解决过程如下:

testa:/oracle/app/product/9.2.0/bin>gsdctl start

Failed to start GSD on local node

这个起不来通常是由于srvConfig没有在所有结点上创建或者是访问这个文件有问题造成的。

ls -lsa /dev/ro*

0 crw-rw---- 1 oracle dba 50, 13 Nov 28 15:02 /dev/ro9_srvconf

testb:/var/opt/oracle>ls -lsa

total 4

0 drwxr-xr-x 2 oracle dba 256 Nov 29 17:02 .

0 drwxr-xr-x 6 bin bin 256 Nov 29 16:58 ..

4 -rw-rw-r-- 1 oracle system 31 Nov 30 13:33 srvConfig.loc

testb:/var/opt/oracle>more srvConfig.loc

srvconfig_loc=

(发现这里是空的,没有内容),手工指定:

srvconfig_loc= /dev/ro9_srvconf

重新初始化,如下

testb:/var/opt/oracle>srvconfig -init

重启后正常:

testb:/var/opt/oracle>gsdctl start

Successfully started GSD on local node

此问题也算是一个bug,详细参考Oracle Metalink ID:Resolving PRKR-1064 ina RAC Environment [ID 212631.1],如下:

Fact(s)

~~~~~~~~

Attempting to set up a shared configuration file in a Real Application Clusters

environment.

Symptom(s)

~~~~~~~~~~

PRKR-1064 error in a RAC environment.

Change(s)

~~~~~~~~~~

Setting this up for the first time or changes on the srvConfig.loc file or

shared configuration file(s).

Cause

~~~~~~~

Shared configuration file is incorrectly configured.

Fix

~~~~

Verify that the shared configuration file has been correctly configured:

1. Get ls -l output of the /var/opt/oracle/srvConfig.loc file from each node to

verify permissions:

[rac1]/var/opt/oracle> ls -l /var/opt/oracle/srvConfig.loc

-rwxrwxrwx 1 oracle dba 75 Aug 27 18:35 /var/opt/oracle/srvConfig.loc*

Note: This file (srvConfig.loc) may also exist in /etc or $ORACLE_HOME/srvm/config

This file should be readable and writable by the Oracle user on all nodes.

2. Check the contents of srvConfig.loc file on each node to verify the shared

configuration file location:

[rac1]/var/opt/oracle> more /var/opt/oracle/srvConfig.loc

srvconfig_loc=/dev/vx/rdsk/srvm.dbf

Note: This file (srvConfig.loc) may also exist in /etc or $ORACLE_HOME/srvm/config

This should be pointing to a valid shared file or raw device.

3. If you are pointing to a raw device, confirm that the raw device was created

to be at least100M. If you are using CFS or NFS, ensure that the shared

configuration file has been precreated:

[rac1]/var/opt/oracle> touch /shared/srvm.dbf

4. Check the permissions on the shared configuration file being used to verify

permissions and ownership:

[rac1]/var/opt/oracle> ls -l /dev/vx/rdsk/srvm.dbf

crw-rw---- 1 oracle dba 201,37005 Sep 4 06:35 /dev/vx/rdsk/srvm.dbf

5. Make sure you can 'dd' the shared configuration file as the Oracle user:

$ dd if=f=/dev/null bs=

Example:

[rac1]/> dd if=/dev/vx/rdsk/srvm.dbf f=/dev/null bs=8192

20480+0 records in

20480+0 records out

6. Stop the GSD if it is running.

9.0:

$ ps -ef | grep jre

$ kill -9 Note: Make sure that this is the process in use by GSD

9.2:

$ gsdctl stop

7. Attemt to re-initialize the SRVM file:

[rac1]/var/opt/oracle> srvconfig -init -f

8. If this is successful, start the GSDs and add the databases and instances to

srvctl. If this still fails, trace srvconfig using the instructions in the

following note and provide output of steps 1-8 to Oracle Support:

The following are known bugs involving PRKR-1064 errors:

Bug 2861550

Description: GSD fails at startup with PRKR-1064

Versions Affected:9.2.0.3

Platforms Affected: Linux: SLE8 and United Linux

Fixed Version:9.2.0.3 with Patch 2861550

Bug 2400133

Description: PRKR-1064 : General Exception in OCR with CFS

Versions Affected:9.2.0.X

Platforms Affected: All that support CFS

Workaround: Pre-create the shared configuration file.

Bug 2656165

Description: Failed to get status of srvconfig on PRKR-1064 when used '#'

character in srvConfig.loc.

Versions Affected:9.2.0.X

Workaround: Do not put '#' signs in the srvConfig.loc

Bug 2660531

Description: Srvconfig Fails Due To Multiple Open Of Shared File Without Closing It On Ocfs.

Versions Affected:9.2.0.1

Fixed in9.2.0.3

logo.gif

1428d0e076c3959ab11d28a39bc84fab.png

5268f80b9b1e01f982625ef6fac83ca1.png

本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源:php中文网

这篇关于aix oracle9i rac,AIX上安装Oracle9iRAC出现FailedtostartGSDonlocalnode的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/258290

相关文章

Win安装MySQL8全过程

《Win安装MySQL8全过程》:本文主要介绍Win安装MySQL8全过程,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录Win安装mysql81、下载MySQL2、解压文件3、新建文件夹data,用于保存数据库数据文件4、在mysql根目录下新建文件my.ini

最详细安装 PostgreSQL方法及常见问题解决

《最详细安装PostgreSQL方法及常见问题解决》:本文主要介绍最详细安装PostgreSQL方法及常见问题解决,介绍了在Windows系统上安装PostgreSQL及Linux系统上安装Po... 目录一、在 Windows 系统上安装 PostgreSQL1. 下载 PostgreSQL 安装包2.

Maven如何手动安装依赖到本地仓库

《Maven如何手动安装依赖到本地仓库》:本文主要介绍Maven如何手动安装依赖到本地仓库问题,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录一、下载依赖二、安装 JAR 文件到本地仓库三、验证安装四、在项目中使用该依赖1、注意事项2、额外提示总结一、下载依赖登

如何在Mac上安装并配置JDK环境变量详细步骤

《如何在Mac上安装并配置JDK环境变量详细步骤》:本文主要介绍如何在Mac上安装并配置JDK环境变量详细步骤,包括下载JDK、安装JDK、配置环境变量、验证JDK配置以及可选地设置PowerSh... 目录步骤 1:下载JDK步骤 2:安装JDK步骤 3:配置环境变量1. 编辑~/.zshrc(对于zsh

如何在pycharm安装torch包

《如何在pycharm安装torch包》:本文主要介绍如何在pycharm安装torch包方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录在pycharm安装torch包适http://www.chinasem.cn配于我电脑的指令为适用的torch包为总结在p

在PyCharm中安装PyTorch、torchvision和OpenCV详解

《在PyCharm中安装PyTorch、torchvision和OpenCV详解》:本文主要介绍在PyCharm中安装PyTorch、torchvision和OpenCV方式,具有很好的参考价值,... 目录PyCharm安装PyTorch、torchvision和OpenCV安装python安装PyTor

Python Transformer 库安装配置及使用方法

《PythonTransformer库安装配置及使用方法》HuggingFaceTransformers是自然语言处理(NLP)领域最流行的开源库之一,支持基于Transformer架构的预训练模... 目录python 中的 Transformer 库及使用方法一、库的概述二、安装与配置三、基础使用:Pi

如何解决mmcv无法安装或安装之后报错问题

《如何解决mmcv无法安装或安装之后报错问题》:本文主要介绍如何解决mmcv无法安装或安装之后报错问题,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录mmcv无法安装或安装之后报错问题1.当我们运行YOwww.chinasem.cnLO时遇到2.找到下图所示这里3.

Python 安装和配置flask, flask_cors的图文教程

《Python安装和配置flask,flask_cors的图文教程》:本文主要介绍Python安装和配置flask,flask_cors的图文教程,本文通过图文并茂的形式给大家介绍的非常详细,... 目录一.python安装:二,配置环境变量,三:检查Python安装和环境变量,四:安装flask和flas

Win11安装PostgreSQL数据库的两种方式详细步骤

《Win11安装PostgreSQL数据库的两种方式详细步骤》PostgreSQL是备受业界青睐的关系型数据库,尤其是在地理空间和移动领域,:本文主要介绍Win11安装PostgreSQL数据库的... 目录一、exe文件安装 (推荐)下载安装包1. 选择操作系统2. 跳转到EDB(PostgreSQL 的