oracle9i rac for aix,AIX上安装Oracle 9i RAC出现Failed to start GSD on local node

2023-10-22 01:40

本文主要是介绍oracle9i rac for aix,AIX上安装Oracle 9i RAC出现Failed to start GSD on local node,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

最近做一个数据库迁移项目,安装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.30b1331709591d260c1c78e86d0c51c18.png

这篇关于oracle9i rac for aix,AIX上安装Oracle 9i RAC出现Failed to start GSD on local node的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



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

相关文章

最详细安装 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

Node.js 数据库 CRUD 项目示例详解(完美解决方案)

《Node.js数据库CRUD项目示例详解(完美解决方案)》:本文主要介绍Node.js数据库CRUD项目示例详解(完美解决方案),本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考... 目录项目结构1. 初始化项目2. 配置数据库连接 (config/db.js)3. 创建模型 (models/

如何在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

使用Node.js制作图片上传服务的详细教程

《使用Node.js制作图片上传服务的详细教程》在现代Web应用开发中,图片上传是一项常见且重要的功能,借助Node.js强大的生态系统,我们可以轻松搭建高效的图片上传服务,本文将深入探讨如何使用No... 目录准备工作搭建 Express 服务器配置 multer 进行图片上传处理图片上传请求完整代码示例

解决SpringBoot启动报错:Failed to load property source from location 'classpath:/application.yml'

《解决SpringBoot启动报错:Failedtoloadpropertysourcefromlocationclasspath:/application.yml问题》这篇文章主要介绍... 目录在启动SpringBoot项目时报如下错误原因可能是1.yml中语法错误2.yml文件格式是GBK总结在启动S

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

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