[PRKC-1002
NFO: Exclude file list /tmp/OraInstall2011-03-16_02-09-47PM/installExcludeFile.lst does not exist or is empty. The file is ignored.WARNING: This will stop installation of all products and exit t...
PRKC-1044 :
[PRKC-1044 : Failed to check remote command execution setup for node rac01.site using shells /usr/bin/ssh and /usr/bin/rshrac01.site: Connection refused] 原來是 /etc/hosts.equiv 的 hostname...
CRS-0184: Cannot communicate with the CRS daemon.
oracle@rac01:~> crs_start -allCRS-0184: Cannot communicate with the CRS daemon. 1. NFS 文件系统没有装载 2.分别集群节点上用root执行rac01:/etc/init.d # /etc/init.d/init.crs stoprac01:/etc/init...
PRKP-1001 : CRS-0215:
srvctl start database -d racPRKP-1001 : Error starting instance rac1 on node rac01CRS-0215: Could not start resource 'ora.rac.rac1.inst'.启动日志在/home/oracle/product/10.2.0/db_1/log/rac01/racg数据...
The directory is not on cluster file system partition shared across nodes
DBCA 运行时磁到The directory /u01/oradata is not on cluster file system partition shared across nodes建库时目录选择必须是装载目录只接选/u02就ok了,他会自动在下面建目录
error while loading shared libraries: libpthread.so.0:
/home/oracle/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory 解决这个问题,需要三个步骤来完...
Startup will be queued to init within 90 seconds
Startup will be queued to init within 90 seconds.挂死1. 检查以确保防火墙选项关闭。如果防火墙选项已停用(如下面的示例所示),则不必继续执行以...
ORA-20000
ORA-20000: index " "." " or partition of such index is in unusable state Errors in file /export/home/oracle/admin/ora10/bdump/ora10_j001_20464.trc:ORA-20000: index " "." " or ...
ORA-00600
ORA-00600: internal error code, arguments: [13011], [9183], [12587093], [52], [12587093], [17], [], [] ORA-08102: index key not found, obj# 9029, file 3, block 35919 (2) .查看对象 SQL...
delete obsolete 下的错误
RMAN>delete obsoleteRMAN-06207: 警告: 由于状态不匹配, 所以不能删除 3 对象 (对于 DISK 通道)。RMAN-06208: 请用 CROSSCHECK 命令修正状态RMAN-06210: 不匹配对象的列表RMAN-06211: ==========================R...
数据库安装出现乱码
检查:LANG LC_CTYPE locale参数 export LANG=zh_CN.* export locale=zh_CN.GBK export LC_CTYPE=zh.GBK.en
查看表的外键的表
select a.constraint_name,a.constraint_type,a.table_name Rtablename,b.table_name pktablename from USER_CONSTRAINTS a , USER_CONSTRAINTS b where a.table_name='TABLE_NAME' and a.r_constraint_...
数据库启动错误--ORA-12560
今天数据接到开发人员说数据库启动不了.上去一查,数据库服务没有启动,Microsoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplus "/as sysdba...
10G 下打补丁及碰到的问题
将oracle10G 10.2.0.1.0打相应补丁,我这里打的是p6810189_10204_Linux-x86,打补丁的操作和安装oracle差不多. 1. 解压补丁包 # unzip p6810189_10204_Linux-x86.zip # chown -R oracle:dba Disk...