一、 orACLE 10g
环境:aix 6.1
安装CRS,不显示地址信息,如上。
查看metalink文档,这个是由于没有正确检测到hacmp造成的。文档内容见附件:
1.对比症状
注意下面这个lsnodes文件是临时产生的,需要在不关闭OUI界面的情况下,到/tmp/OraInstall2008-04-22_01-45-01PM/oui/bin/执行该命令。
# ./lsnodes
exec(): 0509-036 Cannot load program /tmp/OraInstall2008-04-22_01-45-01PM/oui/bin/lsnodes.bin because of the following errors:
0509-150 Dependent module libskgxn2.a(shr_skgxn2.o) could not be loaded.
0509-022 Cannot load module libskgxn2.a(shr_skgxn2.o).
0509-026 System error: A file or directory in the path name does not exist.
2.下载补丁6718715
i) Download the Patch 6718715
Steps to apply the patch
------------------------
1--> Login as root user
2--> Unpack the files shipped in this patch in a temporary directory
3--> Run the rootpre.sh script
./rootpre.sh
在6718715 的readme文档里说是for HACMP 5.4的,我在HACMP 6.1上打该补丁,同样生效。
注:打完这个补丁后会要求将oracle用户加入hagsuser组
报错2:
[root@vsopdb2:/mboss/oracle/product/10.2.0/crs/install]#./root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
< CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH >
by running </usr/bin/chuser> command then 'crsctl stop crs' and 'crsctl start crs'.
chuser capabilities=CAP_PROPAGATE,CAP_BYPASS_RAC_VMM,CAP_NUMA_ATTACH oracle
报错3:
INFO: ld: 0711-711 ERROR: Input file /mboss/oracle/product/10.2.0/db/lib32/libnmemso.so is empty.
The file is being ignored.
INFO: make: 1254-004 The error code from the last command is 8.
Stop.
INFO: make: 1254-004 The error code from the last command is 2.
INFO:
Stop.
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'agent nmo nmb' of makefile '/mboss/oracle/product/10.2.0/db/sysman/lib/ins_sysman.mk'. See '/mboss/oracle/oraInventory/logs/
installActions2011-03-30_12-53-49AM.log' for details.
解决方法:
Linking Fails With ld 0706-010 The binder was killed by a signal Segmentation fault On AIX 6.1 [ID 1264074.1]
Applies to:
Enterprise Manager Grid Control - Version: 10.2.0.2 to 10.2.0.5 - Release: 10.2 to 10.2
oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 [Release: 10.2 to 11.2]
IBM AIX on POWER Systems (64-bit)
.
The problem below appears to affect oracle installations on AIX servers running:
AIX 6.1 TL2 SP10 (6100-02-10-1036) and higher
AIX 6.1 TL3 SP7 (6100-03-07-1036) and higher
AIX 6.1 TL4 SP7 (6100-04-07-1036) and higher
AIX 6.1 TL5 SP3 (6100-05-03-1036) and higher
AIX 6.1 TL6 (all SP levels)
AIX 6.1 TL7 (all SP levels)
The problem does not appear to affect:
AIX 6.1 TL2 SP9 or l
ower
AIX 6.1 TL3 SP6 or lower
AIX 6.1 TL4 SP6 or lower
AIX 6.1 TL5 SP2 or lower
Symptoms
While installing oracle10g Release 2 (10.2), oracle11g Release 1 (11.1) or oracle11g Release 2 (11.2) on an AIX server running AIX 6.1, the following error may occur:
INFO:
ld: 0706-010 The binder was killed by a signal: Segmentation fault
Check for binder messages or use local problem reporting procedures.
INFO: make: 1254-004 The error code from the last command is 254.
Stop.
INFO: make: 1254-004 The error code from the last command is 2.
Stop.
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'agent nmb nmo nmhs' of makefile '/u01/app/oracle/product/11.2.0/sysman/lib/ins_emagent.mk'.
More specifically, the "ld: 0706-010" error may occur when running the following command:
% make -f $ORACLE_HOME/sysman/lib/ins_emagent.mk relink_sharedobj SHAREDOBJ=libnmemso
Using 'truss' to trace this command generates output similar to this:
:
15925416: 20512937: kopen("/usr/lib/glink64.o", O_RDONLY) = 31
15925416: 20512937: fstatx(31, 0x0FFFFFFFFFFFCBF0, 176, 0) = 0
15925416: 20512937: shmat(31, 0x0000000000000000, 6144) = 0x0700000300000000
15925416: 20512937: __libc_sbrk(0x0000000000010020) = 0x000000011161E140
15925416: 20512937: __libc_sbrk(0x0000000000010020) = 0x000000011162E160
15925416: 20512937: __libc_sbrk(0x0000000000010020) = 0x000000011163E180
********: 20512937: __libc_sbrk(0x0000000000010020) = 0x000000011164E1A0
15925416: 20512937: __libc_sbrk(0x0000000000010020) = 0x000000011165E1C0
15925416: 20512937: __libc_sbrk(0x0000000000010020) = 0x000000011166E1E0
15925416: 20512937: _getpid() = 15925416
15925416: 20512937: lseek(0x0000000000000003, 0x0000000000000000, 0x0000000000000001) = 0x0000000000002252
:
15925416: 20512937: kread(0x0000000000000003, 0x00000001102C14B8, 0x0000000000001000) = 0x0000000000001000
15925416: 0x00000000: "\n"
15925416: 20512937: shmat(4, 0x07F0000000000000, 2048) = 0x07F0000000000000
15925416: Received signal #11, SIGSEGV [default]
15925416: *** process killed ***
:
NOTE
To verify which AIX version is running, use the command:
% oslevel -s
Cause
Oracle Support opened Bug:10259393 for this issue but it appears to be a known issue on the following AIX 6.1 versions:
AIX 6.1 TL2 SP10 (6100-02-10-1036) and higher
AIX 6.1 TL3 SP7 (6100-03-07-1036) and higher
AIX 6.1 TL4 SP7 (6100-04-07-1036) and higher
AIX 6.1 TL5 SP3 (6100-05-03-1036) and higher
AIX 6.1 TL6 (all SP levels)
AIX 6.1 TL7 (all SP levels)
IBM have investigated the error and released fixes
Solution
For AIX 6.1 TL6, IBM have released fix IZ88711:
ftp://public.dhe.ibm/aix/efixes/iz88711/
Fixes for other AIX 6.1 TL's are also available.
Please contact IBM to identify the correct fix for your environment.
After installin
g the AIX fix, run the following command:
% make -f $ORACLE_HOME/sysman/lib/ins_emagent.mk relink_sharedobj SHAREDOBJ=libnmemso
to link the libnmemso.so library
Alternative solution
If these errors occur on AIX 6.1 TL4 SP6/SP7, you may alternatively be hitting the AIX defect below:
IZ44217 CRASH CAUSED BY STALE FILE DESCRIPTOR IN FORKED CHILD
下载补丁后:
emgr -e IZ88711SP2.101121.epkg.Z
$cd $ORACLE_HOME/bin
$relink all
或者在打完补丁后点retry继续安装
报错4:
AIX: PRKC-1073 : Failed to Transfer Directory "/u01/app/crs/inventory" to Any of the Given Nodes [ID 1314406.1]
When applying patchset 10.2.0.x on top of CRS 10.2.0.1, the following error message is in installAction*.log
WARNING: Error while copying directory /u01/app/crs/inventory with exclude file list '/tmp/OraInstall2011-03-23_10-40-10AM/installExcludeFile.lst' to nodes 'racdb2'. [PRKC-1073 : Failed to transfer directory "/u01/app/crs/inventory" to any of the given nodes "racdb2 ".
Error on node racdb2:null]
Cause
Write permission is missing on some files created by base release 10.2.0.1:
<crs_home>/inventory/Templates/install/root*
This issue is described in unpublished bug 8555018 which is duplicate of unpublished bug 6727474.
This problem only applies to patchset 10.2.0.4 and 10.2.0.5 on AIX.
Solution
通过打补丁解决:
1.Install CRS 10.2.0.1
2.Execute the following command on ALL remote nodes:
$ chmod -R u+w <CRS_HOME>/inventory/Templates/*
安装oracle10g3.Apply patchset 10.2.0.4/10.2.0.5
如果已安装patchset,可以手工修复:
If you had patchset already installed, please manually transfer these files as following. Replace <CRS_HOME> and <node_name> with actual value.
-- on all remote nodes
$ chmod -R u+w <CRS_HOME>/inventory/Templates/*
-- on local node
$ (cd <CRS_HOME>/inventory && /usr/bin/find ./* -depth -print | /bin/cpio -oacEignore)|/usr/bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyChecking=yes -o NumberOfPasswordPrompts=0 <node_name> "(cd <CRS_HOME>/inventory &&/bin/cpio -idmuc)"
for example:
(cd /u01/crs/oracle/product/10.2.0/crs/inventory && /usr/bin/find ./* -depth -print | /bin/cpio -oacEignore)|/usr/bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyChecking=yes -o NumberOfPasswordPrompts=0 coredb2 "(cd /u01/crs/oracle/product/10.2.0/crs/inventory &&/bin/cpio -idmuc)"
报错5:
ASM / CSS Error : Please Change The CSS_ORACLE_USER Id CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH [ID 726234.1]
Symptoms
Note: The solution provided in this document is only for Non-clusterware configurations (non-CRS). 在安装完cluster后,运行root.sh时也会有这样的报错,但这个错误不针对集软件,如果对cluster运行loc
alconfig reset可能会导致相关节点重启,或者是OCR位置错误,至使RAC只有一个节点正常运行。
Unable to configure the Cluster Synchronization Service due to the next e
rror:
# /refresh/oracle1/64bit/app/oracle/product/asm/bin/localconfig reset
Error : Please change the CSS_ORACLE_USER id <oracle1> to have the following OS
capabilities : < CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH > by running
</usr/bin/chuser> command.
CAP_BYPASS_RAC_VMM CAP_PROPAGATE CAP_NUMA_ATTACH > by running </usr/bin/chuser>
command.
Cause
The oracle OS user has not the following OS capabilities:
CAP_PROPAGATE
CAP_BYPASS_RAC_VMM
CAP_NUMA_ATTACH
Solution
1) Please set those OS capabilities to the oracle & root OS users as root OS user:
# chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH <oracle OS user which owns the ASM oracle Home>
# chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH root
2) Check the new values:
# lsuser -a capabilities oracle
oracle capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
# lsuser -a capabilities root
root capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
3) Reconfigure the CSS service as follow:
# /refresh/oracle1/64bit/app/oracle/product/asm/bin/localconfig reset Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Configuration for local CSS has been initialized
Cleaning up Network socket directories
Setting up Network socket directories
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new oracle
Expecting the CRS daemons to be up within 600 seconds.
Cluster Synchronization Services is active on these nodes.
ceaixcb10
Cluster Synchronization Services is active on all the nodes.
oracle CSS service is installed and running under init(1M)4) Verify the CSS is up and running:
ps -fea | grep css
root 188604 1 0 17:33:44 - 0:00
/refresh/oracle1/64bit/app/oracle/product/asm/bin/ocssd.bin
ceaixcb10:+ASM:oracle1>crsctl check crs
Cluster Synchrnization Services appears healthy
Cannot communicate with Cluster Ready Services
Cannot communicate with Event Manager
5) Then you will be able to create the ASM instance thru the DBCA or manually.
二、ORACLE 11g
环境: aix 6.1
AIX安装oracle遇到的问题汇总
precheck时遇到的几个问题:
1、PRVF-4007 : User equivalence check failed for user
done ssh localnode date for once
-----------------------------------------------------------
NTP daemon slewing option check failed on some nodes
Check failed on nodes:
PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option
"-x"
Clock synchronization check using Network Time Protocol(NTP) failed
Check the ntp:
# ps -ef|grep ntp
root 786614 151686 0 08:02:32 - 0:00 /usr/sbin/xntpd
Restart the ntp service:
# /usr/bin/stopsrc
# /usr/bin/startsrc -s xntpd -a "-x"
# ps -ef|grep ntp
root 786614 151686 0 08:02:32 - 0:00 /usr/sbin/xntpd -x
-
---------------------------
-----------------------------
2、PRVE-0038 : The SSH LoginGraceTime setting on node "" may r
esult in users being disconnected before login is completed
Cause: PRVE-0038: The SSH LoginGraceTime setting on node "nodename" may result in users being disconnected before login is completed. This error occurs because the default timeout value for SSH connections on AIX is too low, if the LoginGraceTime parameter is commented out.
Action: oracle recommends uncommenting the LoginGraceTime parameter in the OpenSSH configuration file /etc/ssh/sshd_config, and setting it to a value of 0 (unlimited).
---------------------------------------------------------
3、在安装DB software时,出来一个错误提示:(网上收集,未验证,仅供参考)
Error in invoking target 'agent nmb nmo nmhs' of makefile '/scratch/sysvldb/app/sysvldb/product/11.2.0/
dbhome_1/sysman/lib/ins_emagent.mk'. See '/scratch/oracle/app/oraInventory/logs/installActions2011-03-21_10-11-20PM.log' for details.
在网上查了很久,看到一个解决办法,很多人说有效果,但对我无效,我的是AIX 7.1的版本。
Within the file detailed in the error edit it and find the line that reads $(MK_EMAGENT_NMECTL) change this to $(MK_EMAGENT_NMECTL) -lnnz11
Note : edit this file while you still have the installer open, once you have changed it just click retry.
后来看到一些说这是BUG的文章,于是我直接忽略,继续安装。安装成功后,建了DB,使用起来也没发现什么问题。
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。
发表评论