DBCA建库遭遇ORA-12547
大家好：环境：HPUX 11.31 + ORACLE11GR2
描述：
最近在搭建一套ASM+11GR2单实例环境
GRID以及数据库软件已经正常安装，过程中无报错，并且磁盘组也已经创建完成，状态如下：
$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE smi2
ora.LISTENER.lsnr
ONLINE ONLINE smi2
ora.OV.dg
ONLINE ONLINE smi2
ora.asm
ONLINE ONLINE smi2 Started
ora.ons
OFFLINE OFFLINE smi2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE smi2
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE smi2
问题：
用DBCA建库时，无法显示已经建好的磁盘组名，手动添加磁盘组名称（+DATA）之后日志中报如下错误：
[ 2013-12-10 15:42:27.508 GMT+08:00 ] m_bReaderStarted: false
[ 2013-12-10 15:42:27.509 GMT+08:00 ] Starting Reader Thread...
[ 2013-12-10 15:42:28.368 GMT+08:00 ] Done called
[ 2013-12-10 15:42:28.369 GMT+08:00 ] Done called
[ 2013-12-10 15:42:28.370 GMT+08:00 ] ORA-12547: TNS:lost contact
[ 2013-12-10 15:42:34.252 GMT+08:00 ] Dbca exit status is: -1
[ 2013-12-10 15:42:34.253 GMT+08:00 ] check point context null
[ 2013-12-10 15:42:34.257 GMT+08:00 ] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[ 2013-12-10 15:42:34.258 GMT+08:00 ] homeName = Ora11g_dbhome1
有人遇见过么，求解。 继续上信息啊
cat /etc/passwd
cat /etc/group
id oracle
id grid
一些系统需要的包你是否都安装好了？ Evils 发表于 2013-12-10 17:27 static/image/common/back.gif
一些系统需要的包你是否都安装好了？
按照官方文档做的，系统包没问题。 GuanghuiZhou 发表于 2013-12-10 17:23 static/image/common/back.gif
继续上信息啊
cat /etc/passwd
cat /etc/group
smi2#id oracle
uid=109(oracle) gid=201(oinstall) groups=202(dba),204(asmdba)
smi2#id grid
uid=110(grid) gid=201(oinstall) groups=202(dba),203(asmadmin),204(asmdba) 小龙 发表于 2013-12-10 17:38 static/image/common/back.gif
smi2#id oracle
uid=109(oracle) gid=201(oinstall) groups=202(dba),204(as ...
su - grid 查看监听注册 hosts 都检查下 ODM FINDING:
DBCA Failing With Error ORA-04414, ORA-12547: TNS:lost Contact (Doc ID 1499541.1)
Applies to:
Oracle Server - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
Symptoms
A new database creation with DBCA or manually with the scripts as generated by DBCA, this fails with errors ORA-04414, ORA-12547
Changes
The Oracle Home was cloned to a new environment per guidelines provided in
Note 1221705.1 - Cloning An Existing Oracle11g Release 2 (11.2.0.x) RDBMS Installation Using OUI
The cloning as such was independently verified to be correct by the Oracle Support Install competency.
Cause
In this case, several issues may have lead to the reported errors:
/proc filesystem not mounted
Insufficient ulimit values as shown below.
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user) unlimited
The PATH setting as shown below differed from the previously successful cloned environment (QA & DEV)
Suspect usr/ccs/bin directory needs to be placed before the /usr/ucb - (archiver executable that creates library files needs to come from usr/ccs/bin when relinking)
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/usr/local/bin:/usr/local/bin:/bin:/usr/ccs/bin:/usr/pge/bin:/usr/pge/adm:/usr/pge/apps:/usr/local/bin:/opt/LicenseUseManagement/bin:/usr/opt/ifor/ls/os/aix/bin
NOTE:
The PATH setting may not have been relevant here based on
Note 131321.1 - How to Relink Oracle Database Software on UNIX
Also the relink with the cloning procedure had shown no related errors.
However, it was another indication the new clone environment clearly differed from the source environment.
Solution
Make sure the clone target environment is the same as the source environment. At least make sure all instalation requirements are also met on the target environment, e.g.:
Mount /proc filesystem as identified in
Note 372143.1 - ORA-12547 connecting to sqlplus '/ as sysdba' on AIX
To resolve the ORA-04414, increased ulimit shell settings to "unlimited" or according to the install Guide, e.g.
Oracle® Database Installation Guide
11g Release 2 (11.2) for Linux
Part Number E24321-07
Chapter 2 Oracle Database Preinstallation Requirements
Section 2.11 Checking Resource Limits for the Oracle Software Installation Users
http://docs.oracle.com/cd/E11882_01/install.112/e24321/pre_install.htm#BABIAIED
Correct other environment differences, e.g. the PATH setting Liu Maclean(刘相兵 发表于 2013-12-10 19:53 static/image/common/back.gif
ODM FINDING:
DBCA Failing With Error ORA-04414, ORA-12547: TNS:lost Contact (Doc ID 1499541.1)
非常感谢,不过我这个问题不是这上面所说的问题，后来仔细排查了一遍发现是GRID HOME/bin 目录中一个oracle文件权限问题，应该是6517，不知道怎么就变成750了，改过来之后就可以了。 Evils 发表于 2013-12-10 17:53 static/image/common/back.gif
hosts 都检查下
解决了，多谢帮忙。 [ 2013-12-10 15:42:34.257 GMT+08:00 ] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS ASM Diskgroup Can Not Be Shown When Creating Database With DBCA (文档 ID 1269734.1)
页:
[1]