-
编辑 删除
RAC数据库中用opatch应用补丁
在RAC数据库中用opatch应该补丁，可以一个一个节点进行；如果条件容许，可以多个节点一起进行，在Oracle10.2.0.3.4开始还可以一次应用多个补丁。[@more@]opatch">zj1@oracle>opatch apply -hInvoking OPatch 10.2.0.3.0Oracle interim Patch Installer version 10.2.0.3.0Copyright (c) 2005, Oracle Corporation. All rights reserved.. DESCRIPTION This operation applies an interim patch to an ORACLE_HOME from the current directory. The patch location can specified using the parameter patch_location. SYN
-
编辑 删除
ORA-39700: database must be opened with UPGRADE option
when i startup my database after applied 10.2.0.3 patch,there are some error:check alert.logalert_mdzj2.log:ORA-39700: database must be opened with UPGRADE optionalert_mdzj2.log:ORA-1092 signalled during: ALTER DATABASE OPEN...[@more@]when i startup my database after applied 10.2.0.3 patch,there are some error:check alert.logalert_mdzj2.log:ORA-39700: database must be opened with UPGRADE optionalert_mdzj2.log:ORA-1092 signalled during: ALTER DATABASE OPEN...on node1:SQL>startup upgradeThere h
-
编辑 删除
CRS-0184: Cannot communicate with the CRS daemon
RAC节点重起有问题，查看crs 状态有如下错误CRS-0184: Cannot communicate with the CRS daemon[@more@]前几天搭建了两节点的一个RAC数据库发现一个问题，当我重起两台主机的时候，有如下的问题:虚拟IP全跑到其中一个节点上去了# ifconfig -aen0: flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN> inet 182.1.21.151 netmask 0xffff0000 broadcast 182.1.255.255 inet 182.1.21.156 netmask 0xffff0000 broadcast 182.1.255.255
-
编辑 删除
Oracle10.2 RAC节点中，查看crsd.log的时候发现有很多 th_select_handler message
crsd.log: th_select_handler message 是可以忽略的信息[ OCRSRV][3864]th_select_handler: Failed to retrieve procctx from ht. constr = [399766928] retval lht [-27] Signal CV.[@more@]crsd.log: th_select_handler message repeated[ OCRSRV][3864]th_select_handler: Failed to retrieve procctx from ht. constr = [399766928] retval lht [-27] Signal CV.metalnik上说:不用理会，可以屏蔽CauseThis is an informational message for development. SolutionThis message can be ignored as described in internal bug 4494370.S
-
编辑 删除
RAC安装完成后，就不能轻易更改主机名称了
RAC安装完成后，就不能轻易更改主机名称了，逼不得已，就重装CRS吧.[@more@]page 5-9 of Oracle 10g RAC Administrator's Guide, Oracle specifically stated to not change the host name after the install.The hostname becomes a part of CRS configuration, so changing the host name is not allowed.To change hostname in RAC environment reinstall CRS ...
