一、 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 becau 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 ur
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用户加入hagsur组
报错2：
[root@vsopdb2:/mboss/oracle/product/10.2.0/crs/install]#./root102.sh
Error : Plea 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/chur> command then 'crsctl stop crs' and 'crsctl start crs'.
chur 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:
Enterpri Manager Grid Control - Version: 10.2.0.2 to 10.2.0.5 - Relea: 10.2 to 10.2
oracle Server - Enterpri Edition - Version: 10.2.0.1 to 11.2.0.2 [Relea: 10.2 to 11.2]
IBM AIX on POWER Systems (64-bit)
.
The problem below appears to affect oracle installations on AIX rvers 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 Relea 2 (10.2), oracle11g Relea 1 (11.1) or oracle11g Relea 2 (11.2) on an AIX rver 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 u 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: lek(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, u the command:
% oslevel -s
Cau
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 relead fixes
Solution
For AIX 6.1 TL6, IBM have relead fix IZ88711:
ftp://public./aix/efixes/iz88711/
Fixes for other AIX 6.1 TL's are also available.
Plea 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 the 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 patcht 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]
Cau
Write permission is missing on some files created by ba relea 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 patcht 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/*
3.Apply patcht 10.2.0.4/10.2.0.5
如果已安装patcht，可以手工修复：
If you had patcht already installed, plea manually transfer the 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 : Plea 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运
行localconfig ret可能会导致相关节点重启，或者是OCR位置错误，至使RAC只有一个节点正常运行。
苏轼的浣溪沙Unable to configure the Cluster Synchronization Service due to the next e
rror:
# /refresh/oracle1/64bit/app/oracle/product/asm/bin/localconfig ret
Error : Plea 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/chur> command.
CAP_BYPASS_RAC_VMM CAP_PROPAGATE CAP_NUMA_ATTACH > by running </usr/bin/chur>
command.
Cau
The oracle OS ur has not the following OS capabilities:
CAP_PROPAGATE
CAP_BYPASS_RAC_VMM
客服自我介绍简短CAP_NUMA_ATTACH
Solution
1) Plea t tho OS capabilities to the oracle & root OS urs as root OS ur:
# chur capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH <oracle OS ur which owns the ASM oracle Home>
# chur capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE,CAP_NUMA_ATTACH root
2) Check the new values:
# lsur -a capabilities oracle
oracle capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
# lsur -a capabilities root
root capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
3) Reconfigure the CSS rvice as follow:
# /refresh/oracle1/64bit/app/oracle/product/asm/bin/localconfig ret Successfully accumulated necessary OCR keys.
Creating OCR keys for ur '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 conds.
Checking the status of new oracle
Expecting the CRS daemons to be up within 600 conds.
Cluster Synchronization Services is active on the nodes.
ceaixcb10
Cluster Synchronization Services is active on all the nodes.
oracle CSS rvice 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 : Ur equivalence check failed for ur
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 rvice:
# /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 tting on node "" may r
esult in urs being disconnected before login is completed
Cau: PRVE-0038: The SSH LoginGraceTime tting on node "nodename" may result in urs being disconnected before login is completed. This error occurs becau 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 tting 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，使用起来也没发现什么问题。
