Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › DBCA建库遭遇ORA-12547

小龙

0 积分	1 好友	2 主题

发消息

[备份恢复] DBCA建库遭遇ORA-12547

1^#

发表于 2013-12-10 17:05:58 | 查看: 11058| 回复: 11

大家好：

环境：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）之后日志中报如下错误：
[AWT-EventQueue-0] [ 2013-12-10 15:42:27.508 GMT+08:00 ] [SQLEngine.initialize:362]  m_bReaderStarted: false
[AWT-EventQueue-0] [ 2013-12-10 15:42:27.509 GMT+08:00 ] [SQLEngine.initialize:366]  Starting Reader Thread...
[AWT-EventQueue-0] [ 2013-12-10 15:42:28.368 GMT+08:00 ] [SQLEngine.done:2189]  Done called
[AWT-EventQueue-0] [ 2013-12-10 15:42:28.369 GMT+08:00 ] [SQLEngine.done:2189]  Done called
[AWT-EventQueue-0] [ 2013-12-10 15:42:28.370 GMT+08:00 ] [ASMUtils.loadDiskGroups:863]  ORA-12547: TNS:lost contact

[AWT-EventQueue-0] [ 2013-12-10 15:42:34.252 GMT+08:00 ] [Host.cleanup:3663]  Dbca exit status is: -1
[AWT-EventQueue-0] [ 2013-12-10 15:42:34.253 GMT+08:00 ] [Host.cleanup:3666]  check point context null
[AWT-EventQueue-0] [ 2013-12-10 15:42:34.257 GMT+08:00 ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[AWT-EventQueue-0] [ 2013-12-10 15:42:34.258 GMT+08:00 ] [InventoryUtil.getHomeName:111]  homeName = Ora11g_dbhome1

有人遇见过么，求解。

分享0

收藏0 回复只看该作者道具举报

GuanghuiZhou

2^#

发表于 2013-12-10 17:23:20

继续上信息啊
cat /etc/passwd
cat /etc/group
id oracle
id grid

回复只看该作者道具举报

Evils

3^#

发表于 2013-12-10 17:27:27

一些系统需要的包你是否都安装好了？

回复只看该作者道具举报

小龙

4^#

发表于 2013-12-10 17:37:28

Evils 发表于 2013-12-10 17:27
一些系统需要的包你是否都安装好了？

按照官方文档做的，系统包没问题。

回复只看该作者道具举报

小龙

5^#

发表于 2013-12-10 17:38:54

GuanghuiZhou 发表于 2013-12-10 17:23
继续上信息啊
cat /etc/passwd
cat /etc/group

smi2[/oracle/cfgtoollogs/dbca]#id oracle
uid=109(oracle) gid=201(oinstall) groups=202(dba),204(asmdba)
smi2[/oracle/cfgtoollogs/dbca]#id grid
uid=110(grid) gid=201(oinstall) groups=202(dba),203(asmadmin),204(asmdba)

回复只看该作者道具举报

GuanghuiZhou

6^#

发表于 2013-12-10 17:52:02

小龙发表于 2013-12-10 17:38
smi2[/oracle/cfgtoollogs/dbca]#id oracle
uid=109(oracle) gid=201(oinstall) groups=202(dba),204(as ...

su - grid 查看监听注册

回复只看该作者道具举报

Evils

7^#

发表于 2013-12-10 17:53:37

hosts 都检查下

回复只看该作者道具举报

Liu Maclean(刘相兵

8^#

发表于 2013-12-10 19:53:03

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 ... nstall.htm#BABIAIED

Correct other environment differences, e.g. the PATH setting

回复只看该作者道具举报

小龙

9^#

发表于 2013-12-11 14:06:26

Liu Maclean(刘相兵发表于 2013-12-10 19:53
ODM FINDING:

DBCA Failing With Error ORA-04414, ORA-12547: TNS:lost Contact (Doc ID 1499541.1)

非常感谢,不过我这个问题不是这上面所说的问题，后来仔细排查了一遍发现是GRID　HOME/bin　目录中一个oracle文件权限问题，应该是6517，不知道怎么就变成750了，改过来之后就可以了。

回复只看该作者道具举报

小龙

10^#

发表于 2013-12-11 14:07:10

Evils 发表于 2013-12-10 17:53
hosts 都检查下

解决了，多谢帮忙。

回复只看该作者道具举报

lgang403

11^#

发表于 2013-12-11 16:00:20

[AWT-EventQueue-0] [ 2013-12-10 15:42:34.257 GMT+08:00 ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

回复只看该作者道具举报

lgang403

12^#

发表于 2013-12-11 16:00:43

ASM Diskgroup Can Not Be Shown When Creating Database With DBCA (文档 ID 1269734.1)

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册