博客访问： 531206
博文数量： 216
博客积分： 6060
博客等级： 准将
技术积分： 1948
注册时间：
分类： Oracle 19:35:47
& 最近公司来了台IBM刀片机，几个哥们开始在上面折腾了，安装了操作系统，部署了数据库软件。准备测试下应用软件。这个机器上有两个刀片，在第一个刀片上安装oracle非常顺利，当在第二个刀片上安装时，却怎么也建不了库。于是哥们试了又试，删了又删。由于哥们儿不是专门搞db的，但是这些安装配置还是没有问题，所以百思不得其解，于是找到了我，但是第一天我是忙的不可开交，所以就没有顾得上来，于是哥几个又是删了又重装，最后还是败下阵来，有点儿郁闷。第二天我终于闲暇了，于是我也上来看看，到底是何方神圣，这么厉害？于是就看了下环境，是在IBM的power pc上弄的，操作系统是linux as 5.3，开始以为是哥几个rpm包没有装全，所以上来检查了一番，发现都有没有问题的，况且两个刀片环境基本一致。于是我就把软件首先重新来的一遍，轮到我建库的时候，还是报错，有意思，这个问题还是值得研究的，毕竟这样的软硬件环境都是以前没有接触过的嘛。小兴奋了一吧。
问题现象：在dbca建库的时候报错：ORA-03113: end-of-file on communication channel，需要说明的是，基本上是在创建实例的时候（后面会揭“包裹”）。
于是我想到会不会是jdk的问题呢？于是我就通过命令行来做了下：
SQL> startup nomount pfile="/home/oracle/orabase/admin/test/scripts/init.ora";ORA-03113: end-of-file on communication channelSQL> exitDisconnected
可惜结果还是如此，看来不是这个问题。继续排查吧。还好基础知识还是有一些，想到实例都起不来，实例就只包括内存和后台进程啊。于是我就再次尝试连接到sqlplus看看：
[oracle@IBMPOWER6 ~]$ sqlplus /"as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 6 10:10:37 2009
Copyright (c) , Oracle.& All rights reserved.
Connected.SQL> exit&& Disconnected
细心的读者可能会发现问题的，这里连接是发生在上的startup nomount之后的第一次连接，上面提示3113后我就退出了，再连接时发现是Connected.而不是idle instance。呵呵，于是就想看看后台进程起来没有：[oracle@IBMPOWER6 ~]$ ps ef|grep ora_16818 pts/4&&& S+&&&& 0:00& \_ grep ora_ HOSTNAME=IBMPOWER6 SHELL=/bin/bash TERM=vt100 HISTSIZE=1000 TMPDIR=/tmp NLS_LANG=AMERICAN_AMERICA.US7ASCII USER=oracle TEMP=/tmp LD_LIBRARY_PATH=/home/oracle/orahome/lib:/lib:/usr/lib:/usr/openwin/lib:/usr/td/lib:/usr/ucblib:/usr/local/lib LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: ORACLE_SID=test ORACLE_BASE=/home/oracle/orabase MAIL=/var/spool/mail/oracle PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/opt/local/bin:/opt/NSCPnav/bin:/home/oracle/orahome/bin:/usr/local/samba/bin:/usr/ucb: INPUTRC=/etc/inputrc PWD=/home/oracle LANG=en_US ORACLE_TERM=xterm SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=1 HOME=/home/oracle LOGNAME=oracle CVS_RSH=ssh LESSOPEN=|/usr/bin/lesspipe.sh %s ORA_NLS33=/home/oracle/orahome/ocommon/nls/admin/data ORACLE_HOME=/home/oracle/orahome G_BROKEN_FILENAMES=1 _=/bin/grep
没有瞅到想象中的那些熟悉的面孔，此时读者们，会如何继续下一步呢？反正本人是执行了以下命令：
[oracle@IBMPOWER6 ~]$ ipcs -a
------ Shared Memory Segments --------key&&&&&&& shmid&&&&& owner&&&&& perms&&&&& bytes&&&&& nattch&&&& status&&&&& 0x593&&&& oracle&&& 640&&&&&&& && 0&&&&&&&&&&&&&&&&&&&&&& 0x362&&&& oracle&&& 640&&&&&&&
0&&&&&&&&&&&&&&&&&&&&&& 0x5fd&&&& oracle&&& 640&&&&&&& & 0&&&&&&&&&&&&&&&&&&&&&&
------ Semaphore Arrays --------key&&&&&&& semid&&&&& owner&&&&& perms&&&&& nsems&&&&
------ Message Queues --------key&&&&&&& msqid&&&&& owner&&&&& perms&&&&& used-bytes&& messages&&
比较怪异啊，oracle有三个共享内存短，但是却没有semaphore arrays和message queues。于是立即想到一个操作系统配置文件sysctl.conf：
[oracle@IBMPOWER6 ~]$ more /etc/sysctl.conf# Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled.& See sysctl(8) and# sysctl.conf(5) for more details.
# Controls IP packet forwardingnet.ipv4.ip_forward = 0
# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1
# Do not accept source routingnet.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernelkernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename# Useful for debugging multi-threaded applicationskernel.core_uses_pid = 1
# Controls the use of TCP syncookiesnet.ipv4.tcp_syncookies = 1
# Controls the maximum size of a message, in byteskernel.msgmnb = 65536
# Controls the default maxmimum size of a mesage queuekernel.msgmax = 65536
# Controls the maximum shared segment size, in byteskernel.shmmax =
# Controls the maximum number of shared memory segments, in pageskernel.shmall =
kernel.shmall = 2097152kernel.shmmax = kernel.shmmni = 4096kernel.sem = 250 8fs.file-max = 65536net.ipv4.ip_local_port_range = net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144
细心的读者可能会发现一些问题的，有些参数设置了两遍。于是根据ipcs的结果修改了sysctl.conf文件为以下：
[oracle@IBMPOWER6 ~]$ more /etc/sysctl.conf# Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled.& See sysctl(8) and# sysctl.conf(5) for more details.
# Controls IP packet forwardingnet.ipv4.ip_forward = 0
# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1
# Do not accept source routingnet.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernelkernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename# Useful for debugging multi-threaded applicationskernel.core_uses_pid = 1
# Controls the use of TCP syncookiesnet.ipv4.tcp_syncookies = 1
# Controls the maximum size of a message, in byteskernel.msgmnb = 65536
# Controls the default maxmimum size of a mesage queuekernel.msgmax = 65536
# Controls the maximum shared segment size, in byteskernel.shmmax =
# Controls the maximum number of shared memory segments, in pageskernel.shmall =
#kernel.shmall = 2097152#kernel.shmmax = kernel.shmmni = 4096kernel.sem = 250 8fs.file-max = 65536net.ipv4.ip_local_port_range = net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144
然后重新建库，一路平安。没有什么事情，喝着coffee在旁边等着就行了。
这个案例和大家分享的目的有几点：
1、以前只知道shmmax参数设置不当对oracle性能有非常大的影响，倒是不影响实例的启动。所以任何事都有可能，还是要靠一步步分析。
2、任何问题的解决还是依靠分析，逐步排除，一一检查过关，最后解决问题。
3、本案例中之所以shmmax参数设置两次，是因为每次工程师都是直接拷贝到该文件中，而没有进行必要的检查。而且在建库的时候如果不修改内存参数的话，默认是物理内存的40%（本案例中3.2G），所以本文第一次配置的shmmax为一般的2G是不够的，这样就产生了多个共享内存段。导致实例无法启动，这样就无法建库。
阅读(1740) | 评论(0) | 转发(0) |
给主人留下些什么吧！~~
请登录后评论。oracle 11g rac dbca建库时提示创建监听
时间： 23:49:15
&&&& 阅读：479
&&&& 评论：
&&&& 收藏：0
标签：&&&&&&&&&&&&Oracle 11g rac dbca建库时提示创建监听在安装oracle 11g rac时，使用dbca建库的过程中提示需要创建监听：Default&Listener&"LISTENER"&is&not&configured&in&Grid&Infrantructure&home.Use&NetCA&to&configure&Default&Listener&and&return&DBCA解决步骤如下因为oracle 11g rac在安装过程中会自动创建监听，无需手动创建，首先使用grid用户登录查看监听状态：[&~]$&crs_stat&-t
Name&&&&&&&&&&&Type&&&&&&&&&&&Target&&&&State&&&&&Host&&&&&&&&
------------------------------------------------------------
ora.DATA.dg&&&&ora....up.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....N1.lsnr&ora....er.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.OCRVOTE.dg&ora....up.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.asm&&&&&&&&ora.asm.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.cvu&&&&&&&&ora.cvu.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.gsd&&&&&&&&ora.gsd.type&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora....network&ora....rk.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....SM1.asm&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.node1.gsd&&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node1.ons&&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.node1.vip&&ora....t1.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....SM2.asm&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.node2.gsd&&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node2.ons&&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.node2.vip&&ora....t1.type&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.oc4j&&&&&&&ora.oc4j.type&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.ons&&&&&&&&ora.ons.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.scan1.vip&&ora....ip.type&ONLINE&&&&ONLINE&&&&node1使用命令crs_stat -t查看各资源状态,发现没有监听资源，下面查看详细信息：[&~]$&crs_stat
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.OCRVOTE.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.cvu
TYPE=ora.cvu.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.gsd
TYPE=ora.gsd.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.node1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.node2.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.node2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.node2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.oc4j
TYPE=ora.oc4j.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE&on&node1手动添加监听资源：[&admin]$&srvctl&status&listener
PRCN-2044&:&No&listener&exists
[&admin]$&
[&admin]$&srvctl&add&listener
[&admin]$&srvctl&status&listener
Listener&LISTENER&is&enabled
Listener&LISTENER&is&not&running
[&admin]$&
[&admin]$&crs_stat&-t
Name&&&&&&&&&&&Type&&&&&&&&&&&Target&&&&State&&&&&Host&&&&&&&&
------------------------------------------------------------
ora.DATA.dg&&&&ora....up.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....ER.lsnr&ora....er.type&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora....N1.lsnr&ora....er.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.OCRVOTE.dg&ora....up.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.asm&&&&&&&&ora.asm.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.cvu&&&&&&&&ora.cvu.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.gsd&&&&&&&&ora.gsd.type&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora....network&ora....rk.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....SM1.asm&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....E1.lsnr&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node1.gsd&&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node1.ons&&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.node1.vip&&ora....t1.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....SM2.asm&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora....E2.lsnr&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node2.gsd&&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node2.ons&&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.node2.vip&&ora....t1.type&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.oc4j&&&&&&&ora.oc4j.type&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.ons&&&&&&&&ora.ons.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.scan1.vip&&ora....ip.type&ONLINE&&&&ONLINE&&&&node1手动启动监听：[&admin]$&srvctl&start&listener
[&admin]$&
[&admin]$&srvctl&status&listener
Listener&LISTENER&is&enabled
Listener&LISTENER&is&running&on&node(s):&node2,node1
[&admin]$&
[&admin]$&crs_stat&-t
Name&&&&&&&&&&&Type&&&&&&&&&&&Target&&&&State&&&&&Host&&&&&&&&
------------------------------------------------------------
ora.DATA.dg&&&&ora....up.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....ER.lsnr&ora....er.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....N1.lsnr&ora....er.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.OCRVOTE.dg&ora....up.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.asm&&&&&&&&ora.asm.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.cvu&&&&&&&&ora.cvu.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.gsd&&&&&&&&ora.gsd.type&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora....network&ora....rk.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....SM1.asm&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....E1.lsnr&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.node1.gsd&&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node1.ons&&application&&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.node1.vip&&ora....t1.type&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora....SM2.asm&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora....E2.lsnr&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.node2.gsd&&application&&&&OFFLINE&&&OFFLINE&&&&&&&&&&&&&&&
ora.node2.ons&&application&&&&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.node2.vip&&ora....t1.type&ONLINE&&&&ONLINE&&&&node2&&&&&&&
ora.oc4j&&&&&&&ora.oc4j.type&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.ons&&&&&&&&ora.ons.type&&&ONLINE&&&&ONLINE&&&&node1&&&&&&&
ora.scan1.vip&&ora....ip.type&ONLINE&&&&ONLINE&&&&node1发现监听正常启动，查看详细资源信息：[&admin]$&
[&admin]$&crs_stat
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.OCRVOTE.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.cvu
TYPE=ora.cvu.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.gsd
TYPE=ora.gsd.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.LISTENER_NODE1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.node1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node1.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.node2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.node2.LISTENER_NODE2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.node2.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.node2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.node2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE&on&node2
NAME=ora.oc4j
TYPE=ora.oc4j.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE
STATE=ONLINE&on&node1
NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE&on&node1本文出自 “” 博客，请务必保留此出处标签：&&&&&&&&&&&&原文地址：http://zaa47.blog.51cto.com/7517
&&国之画&&&& &&&&chrome插件&&
版权所有 京ICP备号-2
迷上了代码！查看: 1676|回复: 6
DBCA创建数据库卡死
论坛徽章:0
1.jpg (37.74 KB, 下载次数: 0)
22:08 上传
2.jpg (49.12 KB, 下载次数: 0)
22:08 上传
日志上传不了！
论坛徽章:7
建议先查看安装日志，看是否有特殊的错误
求职 : 认证徽章论坛徽章:31
日志是怎样的。
论坛徽章:2
木有日志，无解....
论坛徽章:0
我也想上传日志，但附件只支持图片，晚点回去把日志截图发上来。
求职 : 论坛徽章:3
这种情况直接查看安装日志，多数原因是由于系统资源紧张
论坛徽章:0
相关日志如附件。
我装的是单台oracle,没有ASM，不过需勾选了安装EM。
20:23 上传
点击文件名下载附件
99.92 KB, 下载次数: 3
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：10　广播电视节目制作经营许可证：编号（京）字第1149号Oracle 11g + ASM DBCA 建库问题解决心得_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Oracle 11g + ASM DBCA 建库问题解决心得
来源：Linux社区&
环境AIX 6.1& ，11g& ASM
ASM实例安装完成，并能正常启动，ASM盘组能够检测到。
oracle软件正常安装。
然后DBCA建库的时候，在选择文件存储为止的时候选择ASM磁盘，然后图形界面上不显示盘组，
手动输入　＋datadg 开始提示ORA-12705 错误，解决方法如下：
ORA-12705: Cannot access NLS data files or invalid environment specified .
解决方法：正确设置如下两个环境变量
& & & & & export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
& & & & & export ORA_NLS10=/u01/app/oracle/product/11.2.0/dbhome_1/nls/data
当上面的问题解决之后，还是不能检测到盘，手动输入ASM 地址又提示如下错误：
can not connect to asm due to following error : ORA-01031: insufficient privileges
解决方法：
这里我将 我的 oracle 用户添加到 asmdba组就好了开始时两个用户是这样的[root@FINAPROD /]#id oracleuid=901(oracle) gid=901(oinstall) groups=903(oper),902(dba),904(asmadmin)[root@FINAPROD /]#id grid
uid=1100(grid) gid=901(oinstall) groups=902(dba),904(asmadmin),905(asmdba),906(asmoper)
[root@FINAPROD /]#id oracleuid=901(oracle) gid=901(oinstall) groups=903(oper),902(dba),904(asmadmin) ，905(asmdba)[root@FINAPROD /]#id griduid=1100(grid) gid=901(oinstall) groups=902(dba),904(asmadmin),905(asmdba),906(asmoper)
以上两个问题，折腾了我半天，记录一下，也供有需要的参考。
但找不到ASM磁盘问题可能会有很多，我这里只是其中一种情况
推荐阅读：
如何修改ASM的sys密码
如何将ASM中的数据文件复制到操作系统中
Oracle 11g RAC ASM磁盘全部丢失后的恢复
Oracle 11g从入门到精通 PDF+光盘源代码
RHEL6 ASM方式安装Oracle 11g R2&
Oracle 10g 手工创建ASM数据库
12.04(amd64)安装完Oracle 11gR2后各种问题解决方法
如何修改Oracle 10g ASM的sys密码
更多Oracle相关信息见 专题页面
相关资讯 & & &
& (04/10/:46)
& (01/11/:48)
& (03月15日)
& (10/27/:29)
& (12/21/:23)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款博客访问： 6668409
博文数量： 1026
注册时间：
认证徽章：
网名：小麦苗|
微信公众号:xiaomaimiaolhr|
QQ群: 微信群：私聊|
《数据库笔试面试宝典》作者|
OCP、OCM网络班开讲啦，有需要的小伙伴可以私聊我。
分类： Oracle 17:16:50
原文地址： 作者：
在安装完RAC11.2.0.4,并打上PSU后，在通过DBCA创建数据库实例是出现诡异现象：
弹出来的框为单实例创建，二并非RAC实例。反复试了几次都是同样的问题，检查安装无问题。
在metalink上查看了下，问题原因很多，同事通过sqlplus连接空实例测试出现如下报错：
[oracle@zderp2vprd01 cfgtoollogs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 17 09:59:10 2016
Copyright (c) , Oracle. &All rights reserved.
ORA-12547: TNS:lost contact
Enter user-name: ^C
上述报错通常出现在打完PSU后，看到这个错误，怀疑是一个经常遇到的老问题了。目录权限问题，检查如下：
[oracle@zderp2vprd01 11.2.0]$ ls -lrt
drwxr-xr-x 73 root oinstall 4096 Nov 16 21:29 grid_1
drwxrwxr-x 78 grid oinstall 4096 Nov 17 09:40 db_1
[oracle@zderp2vprd01 11.2.0]$ chown oracle:oinstall db_1&
[root@zderp2vprd01 11.2.0]# ls -lrt
drwxr-xr-x 73 root oinstall 4096 Nov 16 21:29 grid_1
drwxrwxr-x 78 grid oinstall 4096 Nov 17 09:40 db_1
[root@zderp2vprd01 11.2.0]# chown oracle:oinstall db_1
修改后终于可以正常创建RAC实例了。
此处将metalink上的信息也贴出来，供大家参考学习。
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
After CRS or Grid Infrastructure installation and RDBMS installation, using dbca to create a RAC database,& it gives a welcome screen without the 'Oracle Real Applications Clusters' and 'Oracle single instance' database options. (same for netca).
While it supposes to be:
This can happen for the following cases.
With 11.2 Grid Infrastructure, using dbca to create a RAC database from a 10.x or 11.1.x ORACLE_HOME.
$ORACLE_HOME/cfgtoologs/dbca/trace.log shows:
[main] [10:36:4:10] [OCR.&init&:259] Primary Group of Current user: oracle
[main] [10:36:4:11] [HASContext.getInstance:200] Module init : 24
[main] [10:36:4:11] [HASContext.getInstance:223] Local Module init : 24
[main] [10:36:4:13] [ClusterLock.&init&:56] ClusterLock Instance Allocation Failed: oracle.ops.mgmt.has.HASContextException: OCR Error(Native: prsr_initCLSS:[21])
[main] [10:36:4:20] [Cluster.isCluster:206] oracle.ops.mgmt.cluster.Cluster.isCluster(Cluster.java:260)
oracle.ops.mgmt.cluster.Cluster.isCluster(Cluster.java:197)
oracle.sysman.assistants.util.ClusterUtils.&init&(ClusterUtils.java:185)
oracle.sysman.assistants.util.ClusterUtils.getInstance(ClusterUtils.java:236)
oracle.sysman.assistants.dbca.backend.Host.checkOPS(Host.java:2070)
oracle.sysman.assistants.dbca.backend.Host.startOperation(Host.java:2303)
oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:115)
oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)
[main] [10:36:4:20] [Host.checkOPS:2073] cluster existence:false
[main] [10:36:4:20] [Host.checkOPS:2111] Cluster installed=false
[Finalizer] [10:36:4:25] [ClusterLock.finalize:88] ClusterLock: finalized called for oracle.ops.mgmt.has.ClusterLock@5c7734
RDBMS is at the same release as CRS or Grid Infrastructure, RDBMS is installed with Real Application Cluster option
RDBMS is at the same release as CRS or Grid Infrastructure, RDBMS is installed on each individual node without selecting Real Application Cluster option.
Case IV,& V,& VI & VII
Grid Infrastructure and RDBMS are on the same release, they are installed as different user: grid and oracle. Grid Infrastructure is running on all nodes, RDBMS is installed with RAC option.
& This is caused by the cluster nodes not being pinned in 11.2 Grid Infrastructure.
See&&Pinning Cluster Nodes for Oracle Database Release 10.x or 11.x for more details.
This is caused by the problem inventory, eg: oraInventory/ContentsXML/inventory.xml does not list RAC nodes for the corresponding RDBMS ORACLE_HOME. For example:
&HOME NAME="OraDb11g_home" LOC="/opt/oracle/product/11.2.0/racdb" TYPE="O" IDX="3"&
While it should be similar to:
&HOME NAME="OraDb11g_home" LOC="/opt/oracle/product/11.2.0/racdb" TYPE="O" IDX="3"&
&& &NODE_LIST&
&&&& &NODE NAME="racnode1"/&
&&&& &NODE NAME="racnode2"/&
&& &/NODE_LIST&
If the RDBMS software is not installed with RAC option, then dbca will not show RAC option either. To confirm if RDBMS software is installed with RAC option, please refer&&How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC.
The problem is caused by RDBMS ORACLE_HOME wrongly owned by grid user. It should be owned by oracle user.
dbca trace shows:
03:46:46.745 GST ] [OracleHome.isDatabaseOptionOn:1133] &Checking Database Option: Real Application Clusters
03:46:46.745 GST ] [OracleHome.isDatabaseOptionOn:1190] &Database Option Real Application Clusters is false
Despite RDBMS ORACLE_HOME has RAC option installed correctly.
Further strace against dbca reveals there are ORA-600 reported before dbca display the option page:
:37.053231 open("/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/dbua4535717_ora_21999.trc", O_WRONLY|O_CREAT|O_TRUNC, 0660) = 3
:37.058573 write(3, "ORA-00600: internal error code, "..., 139) = 139
:37.214275 --- SIGSEGV (Segmentation fault) @ 0 (0) ---
checking /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/dbua4535717_ora_21999.trc, shows:
ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [1100], [1101], [], [], [], [], [], [], [], [], []
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper),1300(dba)
# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)
$ ls -l /u01/app/oracle/product/11.2.0
drwxrwxr-x 75&grid&oinstall 4096 Aug &8 14:21 dbhome_1& && this is wrongly owned by grid user
The problem is caused by an prior abnormal termination of dbca which left a test instance DBUA0 running on 1 of the cluster nodes, this prevents a new test instance to be created before the RAC option is displayed. dbca trace shows:
21:21:08.473 GMT ] [OracleHome.initOptions:1226] Initializing Database Options with& for dummy sid=DBUA0 using initfile=/data/oracle/product/11.2.0.2/dbs/initDBUA0.ora using pwdfile=/data/oracle/product/11.2.0.2/dbs/orapwDBUA0
21:21:08.899 GMT ] [OracleHome.initOptions:1240]& executing: startup nomount pfile='/data/oracle/product/11.2.0.2/dbs/initDBUA0.ora'
21:21:32.871 GMT ] [SQLEngine.done:2167]& Done called
21:21:32.872 GMT ] [OracleHome.initOptions:1247]& ORA-304: requested INSTANCE_NUMBER is busy &&&&
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-304: requested INSTANCE_NUMBER is busy&
&&&&&&& at&
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1
21:21:33.499 GMT ] [OracleHome.isDatabaseOptionOn:1129] Checking Database Option: Real Application Clusters
21:21:33.500 GMT ] [OracleHome.isDatabaseOptionOn:1186] Database Option Real Application Clusters is false &&&&
The problem is caused by $ORACLE_HOME/rdbms/audit directory missing or not writable.
$ORACLE_BASE/cfgtoollogs/dbca/trace.log_&ORACLE_HOMENAME&_&date& shows:
00:15:15.835 EST ] [OracleHome.initOptions:1236]& Initializing Database Options with& for dummy sid=DBUA1500252 using initfile=/u01/app/oradb1/product/11.2.0/dbhome_1/dbs/initDBUA1500252.ora using pwdfile=/u01/app/oradb1/product/11.2.0/dbhome_1/dbs/orapwDBUA1500252
00:15:38.793 EST ] [OracleHome.initOptions:1285]& ORA-09925: Unable to create audit trail file
The problem is caused by insufficient semaphores configed which leads to test instance startup failure.
dbca trace.log shows:
09:28:58.544 EDT ] [OracleHome.initOptions:1253]& executing: startup nomount pfile='/oracle/product/11.2.0.4.5/db11g/dbs/initDBUA2857847.ora'
09:29:00.158 EDT ] [SQLEngine.done:2189]& Done called
09:29:00.159 EDT ] [OracleHome.initOptions:1262]& ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpbitsper
Other Possible causes
1. RDBMS software corrupted, oracle binary shows different size for different nodes
2. Grid_home is not relinked properly
1.& To fix the issue, pin all nodes within the cluster using:
as root user:
crsctl pin css -n&node1& &node2&
2. To list all pinned nodes:
olsnodes -t -n
After this, dbca shows Oracle Real Application Clusters database option correctly.
For 10.x and 11.1.x dbca to work with 11.2 listener, patch 8288940 needs to be applied. Please refer to&&for other potential issues in such mixed environments.
&& Fix the inventory.xml via detaching the problem ORACLE_HOME, then re-attaching with correct information.
1. To detach ORACLE_HOME, on each cluster node, issue:
$ORACLE_HOME/oui/bin/runInstaller -detachHome -silent -local ORACLE_HOME=&$ORACLE_HOME path&
$ORACLE_HOME/oui/bin/runInstaller -detachHome -silent -local ORACLE_HOME=/opt/oracle/product/11.2.0/racdb
2. To attach ORACLE_HOME, on each cluster node, issue:
$ORACLE_HOME/oui/bin/runInstaller -silent -local -ignoreSysPrereqs -attachHome ORACLE_HOME=&$ORACLE_HOME path& ORACLE_HOME_NAME=&$ORACLE_HOME_NAME& CLUSTER_NODES=&local-node&,&remote-node& LOCAL_NODE=&local-node&
For example, on node 1, issue:
$ORACLE_HOME/oui/bin/runInstaller -silent -attachHome -local ORACLE_HOME="/opt/oracle/product/11.2.0/racdb" ORACLE_HOME_NAME="OraDb11g_home" "CLUSTER_NODES={racnode1,racnode2}" LOCAL_NODE='racnode1'
&on node 2, issue:
$ORACLE_HOME/oui/bin/runInstaller -silent -attachHome -local ORACLE_HOME="/opt/oracle/product/11.2.0/racdb" ORACLE_HOME_NAME="OraDb11g_home" "CLUSTER_NODES={racnode1,racnode2}" LOCAL_NODE='racnode2'
1. Relink Oracle binary to include RAC option.
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_on ioracle
2. Fix the inventory using the same procedure as case II.
Change RDBMS ORACLE_HOME to be owned by oracle user:
As root user:
cd /u01/app/oracle/product/11.2.0
chown oracle dbhome_1
Manually shutdown the instance DBUA0.
Please ensure there is no instance with name DBUA0 running on any node of the cluster before start dbca. This is not required if there is no earlier abnormal termination of dbca happened.
Create the default audit directory under $ORACLE_HOME/rdbms/audit if it is missing, otherwise correct the permission and ownership:
$ mkdir $ORACLE_HOME/rdbms/audit
It should have permission 755 (drwxr-xr-x) and ownership &oracle&:oinstall
Either increase the semaphores setting or clear up left over semaphores. Please refer to&&for solution.
1. Reinstall RDBMS oracle software
2. Relinking Grid Infrastructure binaries, refer to
Oracle? Grid Infrastructure Installation Guide
11g Release 2 (11.2) for Linux
阅读(805) | 评论(0) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
请登录后评论。