-
编辑 删除
PRKP-1001 CRS-1028 CRS-0223: Resource 'ora.RACDB.RACDB1.inst' has placement error解决办法
Correcting our RAC problemWe have seen the CRS commands and syntax, now lets look at the practical aspect of it. I was having some trouble while running my RAC on RHEL4 (I think the problem primarily arose because I supplied my virtual machines with inadequate memory. When I noticed that I was getting some alerts on my SoRAC tool, I looked at the status of my RAC.oracle@vmora01rh4 ~]$ cd /u01/app/oracle/product/10.2.0/crs/bin [oracle@vmora01rh4 bin]$ crs_stat -t Name Type T
-
编辑 删除
RAC: 日常监控
所有实例和服务的状态$ srvctl status database -d racdbInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2特定节点上节点应用程序的状态$ srvctl status nodeapps -n linux1VIP is running on node: linux1GSD is running on node: linux1Listener is running on node: linux1ONS daemon is running on node: linux1ASM 实例的状态$ srvctl status asm -n linux1ASM instance +ASM1 is running on node linux1.列出配置的所有数据库$ srvctl config databaseracdb集群中所有正在运行的实例SELECTinst_i
-
编辑 删除
RAC:学习链接
在 Oracle Enterprise Linux 和 iSCSI 上构建您自己的 Oracle RAC 集群：http://www.oracle.com/technology/global/cn/pub/articles/hunter_rac10gr2_iscsi.html[@more@]
-
编辑 删除
RAC: SRVCTL and VIPCA 命令报错解决方法
SRVCTL and VIPCA Utilities Set the LD_ASSUME_KERNEL ParameterThe SRVCTL and VIPCA utilities shipped with Oracle Database 10g release 2 and Oracle Clusterware software set the environmental variable LD_ASSUME_KERNEL. On SUSE Linux Enterprise Server 10, because the older Linux threads API has been removed from GLIBC, setting this parameter causes the SRVCTL and VIPCA utilities to exit with the following error:/opt/oracle/crs/jdk/jre/bin/java: error while loading shared libraries: libpthread.so
-
编辑 删除
[转]RAC 安装配置过程中的问题
OS RHAS 3.2 DB 9204在RAC的安装配置过程中，虽然是严格仔细按照文档来实施，但还是出现不少问题，现整理出来。现象一 ：在节点一安装数据库的时候出现以下错误[oracle@rac1 dbs]$ sqlplus "/nolog"SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 23 14:09:08 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> connect / as sysdbaConnected to an idle instance.SQL> startup nomount pfile="/home/oracle/9.2.0.4/dbs/init.ora"ORA-00444: background process "LMD0
-
编辑 删除
Oracle录入特殊字符 [&] 的小问题
昨天测试同事发现新修改[密码修改]功能，数据库会报[解析失败]经查，原因为[&]字符录入时数据库解析失败内部使用解决方法为: 在[&]后加上[amp;] ， 例: [1234%^&*]网上找到的方法1: 用 [‘||chr(38)||’] 来替代[@more@]
