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

相关文章

Linux系统中卸载与安装JDK的详细教程

《Linux系统中卸载与安装JDK的详细教程》本文详细介绍了如何在Linux系统中通过Xshell和Xftp工具连接与传输文件,然后进行JDK的安装与卸载,安装步骤包括连接Linux、传输JDK安装包... 目录1、卸载1.1 linux删除自带的JDK1.2 Linux上卸载自己安装的JDK2、安装2.1

Linux卸载自带jdk并安装新jdk版本的图文教程

《Linux卸载自带jdk并安装新jdk版本的图文教程》在Linux系统中,有时需要卸载预装的OpenJDK并安装特定版本的JDK,例如JDK1.8,所以本文给大家详细介绍了Linux卸载自带jdk并... 目录Ⅰ、卸载自带jdkⅡ、安装新版jdkⅠ、卸载自带jdk1、输入命令查看旧jdkrpm -qa

MySQL Workbench 安装教程(保姆级)

《MySQLWorkbench安装教程(保姆级)》MySQLWorkbench是一款强大的数据库设计和管理工具,本文主要介绍了MySQLWorkbench安装教程,文中通过图文介绍的非常详细,对大... 目录前言:详细步骤:一、检查安装的数据库版本二、在官网下载对应的mysql Workbench版本,要是

Linux安装MySQL的教程

《Linux安装MySQL的教程》:本文主要介绍Linux安装MySQL的教程,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录linux安装mysql1.Mysql官网2.我的存放路径3.解压mysql文件到当前目录4.重命名一下5.创建mysql用户组和用户并修

pip无法安装osgeo失败的问题解决

《pip无法安装osgeo失败的问题解决》本文主要介绍了pip无法安装osgeo失败的问题解决,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一... 进入官方提供的扩展包下载网站寻找版本适配的whl文件注意:要选择cp(python版本)和你py

Oracle存储过程里操作BLOB的字节数据的办法

《Oracle存储过程里操作BLOB的字节数据的办法》该篇文章介绍了如何在Oracle存储过程中操作BLOB的字节数据,作者研究了如何获取BLOB的字节长度、如何使用DBMS_LOB包进行BLOB操作... 目录一、缘由二、办法2.1 基本操作2.2 DBMS_LOB包2.3 字节级操作与RAW数据类型2.

Android App安装列表获取方法(实践方案)

《AndroidApp安装列表获取方法(实践方案)》文章介绍了Android11及以上版本获取应用列表的方案调整,包括权限配置、白名单配置和action配置三种方式,并提供了相应的Java和Kotl... 目录前言实现方案         方案概述一、 androidManifest 三种配置方式

查看Oracle数据库中UNDO表空间的使用情况(最新推荐)

《查看Oracle数据库中UNDO表空间的使用情况(最新推荐)》Oracle数据库中查看UNDO表空间使用情况的4种方法:DBA_TABLESPACES和DBA_DATA_FILES提供基本信息,V$... 目录1. 通过 DBjavascriptA_TABLESPACES 和 DBA_DATA_FILES

nvm如何切换与管理node版本

《nvm如何切换与管理node版本》:本文主要介绍nvm如何切换与管理node版本问题,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录nvm切换与管理node版本nvm安装nvm常用命令总结nvm切换与管理node版本nvm适用于多项目同时开发,然后项目适配no

Python解析器安装指南分享(Mac/Windows/Linux)

《Python解析器安装指南分享(Mac/Windows/Linux)》:本文主要介绍Python解析器安装指南(Mac/Windows/Linux),具有很好的参考价值,希望对大家有所帮助,如有... 目NMNkN录1js. 安装包下载1.1 python 下载官网2.核心安装方式3. MACOS 系统安