文章版权所有Jusin Hao(luckyfriends),支持原创,转载请注明。
1.1. Oracle 11.2.0.1下dbca建库hang到2%(2011928)
Windows2008 R2 安装11.2.0.1下dbca建库hang到2%-
1.1.1. 问题现象如上命令提示符所示日志,停留在了启动实例读取参数文件init.ora;
查看日志有如下信息
[main] [ 2011-09-28 19:36:15.050 CST ] [GETCRSHOMEUtil.getCRS_HOME:147] cmdTool.execute() failed.
[main] [ 2011-09-28 19:36:15.066 CST ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1400 : 未能执行 getcrshome。详细错误:
localnode
PRCT-1400 : 未能执行 getcrshome。详细错误:
localnode
at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:425)
at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:592)
at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:652)
at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:360)
at oracle.sysman.assistants.dbca.ui.DBCAWizard.(DBCAWizard.java:452)
at oracle.sysman.assistants.dbca.ui.UIHost.(UIHost.java:268)
at oracle.sysman.assistants.dbca.ui.InteractiveHost.(InteractiveHost.java:54)
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:164)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:112)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:184)
Caused by: PRCT-1400 : 未能执行 getcrshome。详细错误:
localnode
at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:161)
at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:112)
at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:422)
... 9 more
[main] [ 2011-09-28 19:36:15.066 CST ] [DBCAWizard.removePageFromList:1248] DBCAWizard->remov
1.1.2. 解决:1)如果使用Oracle 11g R2 数据库,必须安装Oracle 11.2.0.1 Patch 5
https://www.vmware.com/files/cn/pdf/view_5_install_guide_cn-zh.pdf
http://space.itpub.net/7796861/viewspace-674291
需要Oracle 11.2.0.1的Patch5 (9966926)
2)opatch下载,上面的补丁要求opatch至少是11.2.0.1.7):
3) metalink下载补丁:
补丁程序9966926: ORACLE 11G 11.2.0.1 PATCH 5 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64T)
4)利用opatch安装补丁,如下提示:还有oracle进程没有退出;
要停止所有的oracle服务
如下开始安装补丁,输入y
确认信息后,开始安装,如下所示:
5)分析,安装11.2.0.2 应该也可以解决此问题:
下载及安装url:
http://blogs.oracle.com/UPGRADE/entry/patch_set_11202_for_win32_and
http://www.itpub.net/thread-1347436-1-1.html
http://space.itpub.net/35489/viewspace-697773
http://apps.hi.baidu.com/share/detail/32702026
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14710393/viewspace-1097170/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14710393/viewspace-1097170/