suse linux 11 64bit上安装Oracle 11G RAC问题总结

admin管理员组

文章数量:1534197

2024年1月11日发(作者：)

suse linux 11 64bit上安装Oracle 11G RAC问题总结

问题总结 ......................................................................................................................................................................................... 2

介质：

OS平台：suse linux 11 64bit

Grid Infrastructure：11.2.0.4

Oracle database：11.2.0.4

PSU：11.2.0.4.2

虚拟机：VMware workstation 8

1

问题总结

问题1：

安装grid软件，在第二节点执行第二个脚本时报错

suse2:~ # /ora11g/grid/crs_home/

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= /ora11g/grid/crs_home

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/

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 script.

Now product-specific root actions will be performed.

Using configuration parameter file: /ora11g/grid/crs_home/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

Adding Clusterware entries to inittab

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node suse1, number 1, and is

terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Start of resource "" failed

CRS-2800: Cannot start resource '' as it is already in the INTERMEDIATE state on server 'suse2'

CRS-4000: Command Start failed, or completed with errors.

Failed to start Oracle Grid Infrastructure stack

Failed to start Cluster Ready Services at /ora11g/grid/crs_home/crs/install/crsconfig_ line 1353.

/ora11g/grid/crs_home/perl/bin/perl -I/ora11g/grid/crs_home/perl/lib -I/ora11g/grid/crs_home/crs/install

/ora11g/grid/crs_home/crs/install/ execution failed

suse2:~ #

原因：共享存储有问题。配置共享磁盘时，没有选择立即分配所需磁盘空间。重新配置磁盘选择的是立即分配所需磁盘空间

2

解决方法：重新创建共享磁盘。

参数：

-c -s 3g -a lsilogic -t 2 E:VMsuse_rac_

其中：-t 2表示立即分配所需空间，-t 0表示不立即分配所需空间，使用多少分配多少。

创建虚拟磁盘

C:Program Files (x86)VMwareVMware Workstation>

E:VMsuse_rac_

Creating disk 'E:VMsuse_rac_'

Create: 100% done.

Virtual disk creation successful.

C:Program Files (x86)VMwareVMware Workstation>

C:Program Files (x86)VMwareVMware Workstation>

E:VMsuse_rac_

Creating disk 'E:VMsuse_rac_'

Create: 100% done.

Virtual disk creation successful.

C:Program Files (x86)VMwareVMware Workstation>

E:VMsuse_rac_

Creating disk 'E:VMsuse_rac_'

Create: 100% done.

Virtual disk creation successful.

VMware workstation 8

配置共享存储，添加部分

UUID="TRUE"

cheMaxSize = "0"

cheMaxReadAheadSize = "0"

cheMinReadAheadSize = "0"

chePageSize = "4096"

yncedWrites = "0"

g = "false"

Bus = "virtual"

scsi1:Bus = "Virtual"

scsi1:="TRUE"

scsi1:Type="disk"

3

-c -s 3g

-c -s 10g

-c -s 5g

-a lsilogic

-a lsilogic

-a lsilogic

-t 2

-t 2

-t 2

scsi1:Bus = "Virtual"

scsi1:="TRUE"

scsi1:Type="disk"

scsi1:Bus = "Virtual"

scsi1:="TRUE"

scsi1:Type="disk"

问题2：

[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home.

原因：第一次安装Oracle database软件失败后，再次重装。因信息没有完全删除，所以报错。

解决方法：清除中多余的信息，问题解决。

--在Oracle 11g rac环境中，这个文件位于grid用户的oraInventory目录下

节点2（正常）

grid[suse2]/ora11g/grid/oraInventory/ContentsXML> more

4

11.2.0.4.0

2.1.0.6.0

节点1（异常，多了一部分信息）

grid[suse1]/ora11g/grid/oraInventory/ContentsXML> more

11.2.0.4.0

2.1.0.6.0

5

删除

问题解决

问题3：

原因：在安装Oracle 11g database软件时，一节点已经安装完，在向第二节点copy文件时，二节点主机自动重启了，导致出现这个错误。

解决方法：重装。

问题4：

原因：在安装Oracle 11g database软件时，没有配置ssh。

解决：重新配置后，问题解决。

6

问题5：

在安装Oracle 11g database软件时，组不对。原因ora11g用户的组集中没有dba，所以选择了oinstall组。

异常：

7

正常情况下，应该是dba组，而不是oinstall组

问题6：

ora11g[suse1]/ora11g/orainst/18139609/18031668> opatch apply -local

Oracle Interim Patch Installer version 11.2.0.3.6

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

Oracle Home : /ora11g/oracle/db11g

Central Inventory : /ora11g/grid/oraInventory

from : /ora11g/oracle/db11g/

OPatch version : 11.2.0.3.6

OUI version : 11.2.0.4.0

Log file location : /ora11g/oracle/db11g/cfgtoollogs/opatch/opatch2014-07-13_19-17-19PM_

Verifying environment and performing

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/ora11g/oracle/db11g/lib/.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /ora11g/oracle/db11g/cfgtoollogs/opatch/opatch2014-07-13_19-17-19PM_

8

OPatch failed with error code 73

在给oracle 11g database软件打11.2.0.4.2的PSU时报错。原因是sqlplus在调用.11.1文件，导致报错。

解决方法：

查看日志信息

more /ora11g/oracle/db11g/cfgtoollogs/opatch/opatch2014-07-13_19-17-19PM_

[Jul 13, 2014 7:25:10 PM] Following executables are active :

/ora11g/oracle/db11g/lib/.11.1

[Jul 13, 2014 7:25:10 PM] Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/ora11g/oracle/db11g/lib/.11.1

[Jul 13, 2014 7:25:10 PM] Start fuser command /bin/fuser /ora11g/oracle/db11g/bin/proc at Sun Jul 13 19:25:10

GMT+08:00 2014

[Jul 13, 2014 7:25:10 PM] Finish fuser command /bin/fuser /ora11g/oracle/db11g/bin/proc at Sun Jul 13 19:25:10

GMT+08:00 2014

[Jul 13, 2014 7:25:10 PM] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

[Jul 13, 2014 7:25:10 PM] Finishing UtilSession at Sun Jul 13 19:25:10 GMT+08:00 2014

[Jul 13, 2014 7:25:10 PM] Log file location:

/ora11g/oracle/db11g/cfgtoollogs/opatch/opatch2014-07-13_19-24-36PM_

[Jul 13, 2014 7:25:10 PM] Stack Description: eException: Prerequisite check

"CheckActiveFilesAndExecutables" failed.

[Jul 13, 2014 7:25:10 PM] StackTrace:

lyPrereqs(:6420)

[Jul 13, 2014 7:25:10 PM] StackTrace: s(:1614)

[Jul 13, 2014 7:25:10 PM] StackTrace: (:1136)

[Jul 13, 2014 7:25:10 PM] StackTrace: 0(Native Method)

[Jul 13, 2014 7:25:10 PM] StackTrace:

(:39)

[Jul 13, 2014 7:25:10 PM] StackTrace:

(:25)

[Jul 13, 2014 7:25:10 PM] StackTrace: (:592)

[Jul 13, 2014 7:25:10 PM] StackTrace: s(:322)

[Jul 13, 2014 7:25:10 PM] StackTrace: (:2343)

[Jul 13, 2014 7:25:10 PM] StackTrace: (:614)

9

ora11g[suse1]/ora11g/orainst/18031668> fuser /ora11g/oracle/db11g/lib/.11.1

/ora11g/oracle/db11g/lib/.11.1: 16623m

ora11g[suse1]/ora11g/orainst/18031668> ps -ef|grep 16623

ora11g 8066 7206 0 19:28 pts/5 00:00:00 grep 16623

ora11g 16623 16572 0 17:50 pts/3 00:00:00 sqlplus

ora11g[suse1]/ora11g/orainst/18031668>

ora11g[suse1]/home/ora11g> ps -ef|grep 16623

ora11g 8652 8358 0 19:31 pts/5 00:00:00 grep 16623

ora11g 16623 16572 0 17:50 pts/3 00:00:00 sqlplus

ora11g[suse1]/home/ora11g>

ora11g[suse1]/home/ora11g> kill -9 16623

ora11g[suse1]/home/ora11g>

ora11g[suse1]/home/ora11g> ps -ef|grep 16623

ora11g[suse1]/home/ora11g>

ora11g[suse1]/home/ora11g>

ora11g[suse1]/home/ora11g> ps -ef|grep 16623

ora11g 8671 8358 0 19:31 pts/5 00:00:00 grep 16623

ora11g[suse1]/home/ora11g>

ora11g[suse1]/home/ora11g>

sqlplus在调用.11.1文件，杀掉进程后，再次打补丁，补丁顺利打上。

问题7：

在给oracle 11g database软件打11.2.0.4.2的PSU时出现warning

Verifying

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

ins_:113: warning: overriding commands for target `nmosudo'

ins_:52: warning: ignoring old commands for target `nmosudo'

/ora11g/oracle/db11g/sysman/lib/ins_:113: warning: overriding commands for target `nmosudo'

/ora11g/oracle/db11g/sysman/lib/ins_:52: warning: ignoring old commands for target `nmosudo'

Composite patch 18031668 successfully applied.

OPatch Session completed with warnings.

Log file location: /ora11g/oracle/db11g/cfgtoollogs/opatch/opatch2014-07-13_19-34-02PM_

OPatch completed with warnings.

10

查看PSU中的README，可以忽略

Issue 2

Warnings may be returned during the re-link phase of 18031668. These warnings may be ignored.

warning: overriding commands for target `nmosudo'

warning: ignoring old commands for target `nmosudo'

问题8：

在安装grid时，还是无法自动扫描出磁盘，需要手动添加，添加后，正常安装。

安装前扫描磁盘：

grid[suse1]/ora11g/orainst/grid> ./ comp ssa -n suse1,suse2 -s /dev/asm-diskb,/dev/asm-diskc,/dev/asm-diskd

Verifying shared storage accessibility

Checking shared

"/dev/asm-diskb" is shared

"/dev/asm-diskc" is shared

"/dev/asm-diskd" is shared

Shared storage check was successful on nodes "suse2,suse1"

Verification of shared storage accessibility was successful.

根据扫描结过看，磁盘是共享的，所以手动添加后，成功安装。

--说明：根据以前的安装经验，手动添加的磁盘，安装都失败了；这次手动添加磁盘，安装居然成功了。

11

无法自动扫描出磁盘：

手动添加磁盘：

12

问题9：

安装grid前，检查共享磁盘，发现cvuqdisk包没安装。

grid[suse1]/orainst/grid> ./ comp ssa -n suse1,suse2 -s /dev/asmdisk1,/dev/asmdisk2,/dev/asmdisk3

Verifying shared storage accessibility

Checking shared

ERROR: /dev/asmdisk1

suse1:PRVF-7017 : Package cvuqdisk not installed

ERROR: /dev/asmdisk2

suse1:PRVF-7017 : Package cvuqdisk not installed

ERROR: /dev/asmdisk3

suse1:PRVF-7017 : Package cvuqdisk not installed

Shared storage check failed on nodes "suse2,suse1"

Verification of shared storage accessibility was unsuccessful on all the specified nodes.

解决方法：

针对linux平台，在grid软件里面包含有包，该包的默认安装属组为oinstall组。必须有oinstall组才能安装。

suse1:/orainst/grid/rpm # rpm -ivh

########################################### [100%]

Using default group oinstall to install package

Group oinstall not found

oinstall : Group doesn't exist.

Please define environment variable CVUQDISK_GRP with the correct group to be used

error: %pre(cvuqdisk-1.0.9-1.x86_64) scriptlet failed, exit status 1

error: install: %pre scriptlet failed (2), skipping cvuqdisk-1.0.9-1

suse1:/orainst/grid/rpm #

suse1:/orainst/grid/rpm # groupadd oinstall

suse1:/orainst/grid/rpm #

suse1:/orainst/grid/rpm # rpm -ivh

########################################### [100%]

Using default group oinstall to install package

13

1:cvuqdisk ########################################### [100%]

suse1:/orainst/grid/rpm #

问题10：

Checking consistency of file "/etc/" across nodes

Checking the file "/etc/" to make sure only one of domain and search entries is defined

File "/etc/" does not have both domain and search entries defined

Checking if domain entry in file "/etc/" is consistent across

domain entry in file "/etc/" is consistent across nodes

Checking if search entry in file "/etc/" is consistent across

search entry in file "/etc/" is consistent across nodes

Checking DNS response time for an unreachable node

Node Name Status

------------------------------------ ------------------------

suse2 failed

suse1 failed

PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: suse2,suse1

File "/etc/" is not consistent across nodes

用于配置dns域名

使用多个scan vip时，要在该文件中进行配置。

14

15

本文标签： 磁盘安装添加文件