AMD平台安装完Oracle grid运行root.sh出错故障解决

最新推荐文章于 2021-11-15 11:01:06 发布

cthbl797150

最新推荐文章于 2021-11-15 11:01:06 发布

阅读量343

点赞数

============================================================
AMD平台安装完Oracle grid运行root.sh出错故障解决
【RedHat Linux AP 5.3+Oracle11.2.0 RAC】
by 王磊/菜小小~@2011-5-27 13:16
============================================================

故障现象

RedHat Linux AP 5.3+Oracle 11.2.0RAC 安装完grid软件后运行root.sh时爆错：

[11:42:35root@node1 soft]>/u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[11:58:02root@node1 soft]>/u01/app/11.2.0/grid/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/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 ...

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.

2011-05-27 11:58:17: Parsing the host name

2011-05-27 11:58:17: Checking for super user privileges

2011-05-27 11:58:17: User has super user privileges

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Creating trace directory

Failure with signal 11 from command: /u01/app/11.2.0/grid/bin/ocrconfig -local -upgrade oracle oinstall

Failed to create or upgrade OLR

ocrconfig报错日志如下：

[13:36:35root@node1 client]>pwd

/u01/app/11.2.0/grid/log/node1/client

[13:36:07root@node1 client]>cat ocrconfig_14119.log

2011-05-27 11:58:23.929: [ OCRCONF][3046549184]ocrconfig starts...

2011-05-27 11:58:24.099: [ OCRCONF][3046549184]Upgrading OCR data

2011-05-27 11:58:24.195: [ OCROSD][3046549184]utread:3: Problem reading buffer a2de000 buflen 4096 retval 0 phy_offset 102400 retry 0

2011-05-27 11:58:24.196: [ OCROSD][3046549184]utread:3: Problem reading buffer a2de000 buflen 4096 retval 0 phy_offset 102400 retry 1

2011-05-27 11:58:24.196: [ OCROSD][3046549184]utread:3: Problem reading buffer a2de000 buflen 4096 retval 0 phy_offset 102400 retry 2

2011-05-27 11:58:24.196: [ OCROSD][3046549184]utread:3: Problem reading buffer a2de000 buflen 4096 retval 0 phy_offset 102400 retry 3

2011-05-27 11:58:24.196: [ OCROSD][3046549184]utread:3: Problem reading buffer a2de000 buflen 4096 retval 0 phy_offset 102400 retry 4

2011-05-27 11:58:24.196: [ OCROSD][3046549184]utread:3: Problem reading buffer a2de000 buflen 4096 retval 0 phy_offset 102400 retry 5

2011-05-27 11:58:24.196: [ OCRRAW][3046549184]propriogid:1_1: Failed to read the whole bootblock. Assumes invalid format.

2011-05-27 11:58:24.196: [ OCRRAW][3046549184]proprioini: all disks are not OCR/OLR formatted

2011-05-27 11:58:24.196: [ OCRRAW][3046549184]proprinit: Could not open raw device

2011-05-27 11:58:24.196: [ default][3046549184]a_init:7!: Backend init unsuccessful : [26]

2011-05-27 11:58:24.220: [ OCRCONF][3046549184]Exporting OCR data to [OCRUPGRADEFILE]

2011-05-27 11:58:24.221: [ OCRAPI][3046549184]a_init:7!: Backend init unsuccessful : [33]

2011-05-27 11:58:24.222: [ OCRCONF][3046549184]There was no previous version of OCR. error:[PROCL-33: Oracle Local Registry is not configured]

经查阅Oracle support相关文档：

《GRID INSTALLATION ROOT.SH fails with Failure with signal 11 Failed to create or upgrade OLR [ID 1068212.1]》，得到cause及solution如下：

Cause

Unpublished bug 8670579 which relates to the identification of newer AMD chips and therefore only affect platforms using teh newer AMD chips.

Solution

If the error occurs during the installation of the GRID Infrastructure the patch has to be applied, before the root.sh Script in the installation is run:

a.) Run a installation (grid/runInstaller) to the prompt where it requests to run orainstroot.sh and /root.sh

b.) Run orainstroot.sh on all nodes, but not root.sh

c.) Open another session with the Oracle User and apply Patch 8670579 on all nodes (with opatch apply).

d.) Continue with the root.sh from the installation.

If you hit this bug, and have already started root.sh then:

- Deconfigure Clusterware on the failed host with /install/rootcrs.pl -deconfig -force

- Install the Patch as Oracle User (opatch apply)

- Rerun root.sh

实例

[13:19:14root@node1 8670579]>cat /proc/cpuinfo

processor : 0

vendor_id : AuthenticAMD

cpu family : 17

model : 3

model name : AMD Athlon(tm) X2 Dual-Core QL-64

stepping : 1

cpu MHz : 2100.139

cache size : 512 KB

fdiv_bug : no

hlt_bug : no

f00f_bug : no

coma_bug : no

fpu : yes

fpu_exception : yes

cpuid level : 1

wp : yes

flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt rdtscp lm 3dnowext 3dnow constant_tsc up nonstop_tsc pni cx16 lahf_lm extapic 3dnowprefetch ts ttp tm stc 100mhzsteps hwpstate [8]

bogomips : 4200.27

[15:49:32oracle@node1 ~]>cd /u01/app/11.2.0/grid/OPatch/

[12:20:43oracle@node1 OPatch]>opatch lsinventory

Java could not be located. OPatch cannot proceed!

OPatch returns with error code = 1

Cause

Opatch is not able to find “java”.

Solution

Use the “–jre” option to specify location of java.

For example:

$ opatch lsinventory –jre %ORACLE_HOME%\jdk

[12:20:10oracle@node1 OPatch]>opatch lsinventory -jre /u01/app/11.2.0/grid/jdk

Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

Oracle Home : /u01/app/oracle/product/11.2.0/db_1 --应该是grid的home才对，因此需要指定home

Oracle Home Inventory : n/a

OPatch version : 11.1.0.6.6

Product information : n/a

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-05-27_12-20-40PM.log

Patch history file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-05-27_12-20-40PM.txt

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

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[12:25:05oracle@node1 OPatch]>opatch lsinventory -help -jre /u01/app/11.2.0/grid/jdk

Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

DESCRIPTION

List the inventory for a particular $ORACLE_HOME (installed

product, installed patche(s) if any)

SYNTAX

opatch lsinventory [-all ] [-bugs_fixed ][-detail ]

[-group_by_date ][-jre ] [-oh ]

[-patch ] [-patch_id ]

[-property_file ]

OPTIONS

-all

Report the name and installation directory for the

$ORACLE_HOME.

-bugs_fixed

Reports bugs fixed by installed patches in a tabular format.

Besides the bugs fixed, the report also displays the installed

patches, installed times, and bug descriptions.

The fixed bugs are sorted per installed patch. Default display

is patches in descending order based on installed time and

ascending order of bugs within each patch. You can use 'asc'

(or) 'desc' with this option to enforce sort order on bugs

within each patch.

You can use this option with the patch (or) patch_id option to

obtain sort orders with installed patches.

-detail(s)

Report installed product and other details. This

option cannot be used in conjunction with all option.

-group_by_date

This option tells OPatch to group all installed

patches by the date they were installed in the

Oracle Home

-jre

This option tells OPatch to use JRE (java) from the

specified location instead of the default location

under Oracle Home

-oh

The oracle home to work on. This takes precedence over

the environment variable ORACLE_HOME

-patch

Lists the patch IDs installed in the Oracle home in ascending

(asc) or descending (desc) order, which is the default, based on

installed time.

-patch_id

Lists the patch IDs installed in the oracle home

in ascending (asc) or descending (desc) order based on

patch numbers. The value defaults to ascending (asc).

-property_file

The user defined property file for OPatch to use. The

path to the property file should be absolute. This

property file takes precedence over the one that is

supplied with OPatch

PARAMETERS

This operation does not have any required parameters.

[12:26:10oracle@node1 8670579]>/u01/app/11.2.0/grid/OPatch/opatch apply -jre /u01/app/11.2.0/grid/jdk -oh /u01/app/11.2.0/grid/

Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

Oracle Home : /u01/app/11.2.0/grid

Central Inventory : /u01/app/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.1.0.6.6

OUI version : 11.2.0.1.0

OUI location : /u01/app/11.2.0/grid//oui

Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2011-05-27_12-26-20PM.log

Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

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

The patch has more than one Archive Action but there is no Make Action.

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

ApplySession applying interim patch '8670579' to OH '/u01/app/11.2.0/grid'

ApplySession failed: ApplySession failed to prepare the system. ApplySession was not able to create the patch_storage area: /u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12 --发现无权限

System intact, OPatch will not attempt to restore the system

OPatch failed with error code 73

[12:27:13root@node1 8670579]>chown -R oracle:oinstall /u01

修改后再次执行

[12:29:53oracle@node1 8670579]>../opatch apply -jre /u01/app/11.2.0/grid/jdk -oh /u01/app/11.2.0/grid/

Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

Oracle Home : /u01/app/11.2.0/grid

Central Inventory : /u01/app/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.1.0.6.6

OUI version : 11.2.0.1.0

OUI location : /u01/app/11.2.0/grid//oui

Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2011-05-27_12-30-00PM.log

Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

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

The patch has more than one Archive Action but there is no Make Action.

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

ApplySession applying interim patch '8670579' to OH '/u01/app/11.2.0/grid'

Running prerequisite checks...

OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.

This node is part of an Oracle Real Application Cluster.

Remote nodes: 'node2'

Local node: 'node1'

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/11.2.0/grid')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '8670579' for restore. This might take a while...

Backing up files affected by the patch '8670579' for rollback. This might take a while...

Patching component oracle.network.rsf, 11.2.0.1.0...

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/ahseteco.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/am11rkg.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/amsha.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/cpui32.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/sha.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/x931rand.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/am11dkg.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/am931rnd.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/amsharnd.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/ghash.o"

Updating archive file "/u01/app/11.2.0/grid/lib/libnnz11.a" with "lib/libnnz11.a/shacomm.o"

Copying file to "/u01/app/11.2.0/grid/lib/libnnz11.so"

ApplySession adding interim patch '8670579' to inventory

Verifying the update...

Inventory check OK: Patch ID 8670579 is registered in Oracle Home inventory with proper meta-data.

Files check OK: Files from Patch ID 8670579 are present in Oracle Home.

The local system has been patched. You can restart Oracle instances on it.

Patching in rolling mode.

The node 'node2' will be patched next.

Please shutdown Oracle instances running out of this ORACLE_HOME on 'node2'.

(Oracle Home = '/u01/app/11.2.0/grid')

Is the node ready for patching? [y|n]

User Responded with: Y

Updating nodes 'node2'

Apply-related files are:

FP = "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_files.txt"

DP = "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_dirs.txt"

MP = "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/make_cmds.txt"

RC = "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/remote_cmds.txt"

Auto-Rollback-related files are:

FR = "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/remove_files.txt"

DR = "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/remove_dirs.txt"

Instantiating the file "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/remove_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/remove_dirs.txt" with actual path.

Removing directories on remote nodes...

Instantiating the file "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_files.txt" with actual path.

Propagating files to remote nodes...

Instantiating the file "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/11.2.0/grid/.patch_storage/8670579_Feb_25_2010_09_55_12/rac/copy_dirs.txt" with actual path.

Propagating directories to remote nodes...

The node 'node2' has been patched. You can restart Oracle instances on it.

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

The following warnings have occurred during OPatch execution:

1) OUI-67078:Interim patch 8670579 is a superset of the patch(es) [ 8670579 ] in OH /u01/app/11.2.0/grid

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

OPatch Session completed with warnings.

OPatch completed with warnings.

根据上文输出的信息，该patch在两节点都进行了patch操作，应该不需要在其他节点执行patch了，不过俺还是按照solution的步骤来把，在节点2也执行一遍。

[15:49:17oracle@node2 ~]>cd /u01/app/11.2.0/grid/OPatch/

[15:49:54oracle@node2 OPatch]>cd 8670579/

[15:57:46oracle@node2 8670579]>/u01/app/11.2.0/grid/OPatch/opatch apply -jre /u01/app/11.2.0/grid/jdk -oh /u01/app/11.2.0/grid/

Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

Oracle Home : /u01/app/11.2.0/grid

Central Inventory : /u01/app/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.1.0.6.6

OUI version : 11.2.0.1.0

OUI location : /u01/app/11.2.0/grid//oui

Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2011-05-29_15-57-52PM.log

Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

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

The patch has more than one Archive Action but there is no Make Action.

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

ApplySession applying interim patch '8670579' to OH '/u01/app/11.2.0/grid'

Interim patch 8670579 is a superset of the patch(es) [ 8670579 ] in OH /u01/app/11.2.0/grid

OPatch will rollback the subset patches and apply the given patch.

Running prerequisite checks...

OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.

This node is part of an Oracle Real Application Cluster.

Remote nodes: 'node1'

Local node: 'node2'

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/11.2.0/grid')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '8670579' for restore. This might take a while...

ApplySession rolling back interim patch '8670579' from OH '/u01/app/11.2.0/grid'