-
编辑 删除
Oracle 10g RAC启动节点报错 Default gateway is not defined
安装配置好RAC之后，启动节点1报错。[oracle@rac1 racg]$ srvctl start nodeapps -n rac1rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=rac1.kevin.com)rac1:ora.rac1.vip:Interface eth0 checked failed (host=rac1.kevin.com)rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=rac1.kevin.com)rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=rac1.kevin.com)rac1:ora.rac1.vip:Interface eth0 checked failed (host=rac1.kevin.com)rac1:ora.rac1.vip:Invalid parameters
-
编辑 删除
Oracle 10g RAC安装过程中，运行root.sh报错error while loading shared libraries: libpthread.so.0
OS：Redhat Linux AS5在节点2上运行root.sh报错，红色字部分[root@rac2 crs]# /u01/crs/oracle/product/10.2.0/crs/root.shWARNING: directory '/u01/crs/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/crs/oracle/product' is not owned by rootWARNING: directory '/u01/crs/oracle' is not owned by rootWARNING: directory '/u01/crs' is not owned by rootWARNING: directory '/u01' is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating i
-
编辑 删除
RAC环境下oracle用户环境变量问题引起数据库无法启动
Oracle 10g RAC+ASM启动node1正常，启动node2发现ASM实例已经启动，但node2的数据库没有启动，在node2上sqlplus / as sysdba登录数据库[oracle@rac2 ~]$sqlplus / as sysdbaSQL>startupORACLE instance started.Total System Global Area 184549376 bytesFixed Size 1218412 bytesVariable Size 96471188 bytesDatabase Buffers 83886080 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.数据库可以正常启动，但为什么在启动系统的时候不能自动启动了。检查
-
编辑 删除
使用 VMware Workstation 在 Oracle Enterprise Linux 上安装 Oracle RAC 10g
在网上看到很多文章都是说在vmware server 2.0+rhel 4下实现的oracle 10g RAC，都不推荐使用vmware workstation，原因是共享磁盘有问题，以下是我在vmware workstation 7下成功实现oracle 10g RAC的一些记录。我的操作系统：win7 （32bit）2G内存，每个虚拟机配置700M内存。准备条件：vmware workstation 7 RedHat AS4.6 oracle 10g ocfs2-2.6.9-67.ELsmp-1.2.9-1.el4.i686.rpm ocfs2console-1.2.7-1.el4.i386.rpm ocfs2-tools-1.2.7-1.el4.i386.rpm oracleasm-2.6.9-67.ELsmp-2
-
编辑 删除
数据库关闭情况下删除数据文件导致启动错误：ORA-01157
ORA-01157: 无法标识/锁定数据文件 21 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 21: 'D:RONGHAIRONGHAI2.SQL'。解决办法：以dba身份登录，1、alter database datafile 'D:RONGHAIRONGHAI2.SQL' offline drop如删除多个文件，重复以上步骤。2、shutdown immediate3、startup[@more@]
