-
ORA-02298: cannot validate (CTG.FK_CTG_LOGS_INT_201306) – parent keys not found
最近在做10G使用impdp的方式跨平台迁移到11GR2的时候遇到一个下面的报错 ORA-39083: Object type REF_CONSTRAINT failed to create with error: ORA-02298: cannot validate (CTG.FK_CTG_LOGS_INT_201306) - parent keys not found Failing sql is: ALTER TABLE "CTG"."CTG_LOGS_20130 ...
-
rhel 4新安装的数据库sqlplus报Segmentation Fault
在测试9i升级到11G的时候，新安装的在执行sqlplus / as sysdb就报Segmentation Fault错误。 通过下如方法解决： To implement the solution, please execute the following steps: Refer to: 1. cd /usr/bin (as root) 2. mv gcc gcc.script 3. mv g++ g++.script 4. ln - ...
-
9.2.0.8数据库查询seg$ hang住，出现enqueue (tt)阻塞
唉，悲剧的月初啊，星期天的早上8点去客户的路上就接到电话说，查询dba_free_space的进程一直hang住，查询不出来结果，到现场后，手动查询dba_free_space果然hang住。 SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group b ...
-
dbca: line 171: 7911 Aborted
故障现象 环境：OS:RHEL 4.8 DB:10.2.0.4 今天在dbca创建数据库的时候报下面的错误 [oracle10g@rhel4 ~]$ dbca # # An unexpected error has been detected by HotSpot Virtual Machine: # # SIGSEGV (0xb) at pc=0x00c1bb69, pid=7911, tid=4160600288 # # Java VM: Java HotSpot(TM) Clien ...
-
10G RAC 10.2.0.5升级到10.2.0.5.4报错OPatch failed with error code 73
最近霉，做什么事情都不顺利，下面是10RAC 从10.2.0.5升级到10.2.0.5.4，1节点正常升级，但是2节点遇到下面的报错 [oracle@rac2 12419392]$ opatch apply -local Invoking OPatch 10.2.0.5.1 Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle C ...
-
ORA-06553: PLS-213: package STANDARD not accessible
今天在自己的测试环境把9.2.0.4升级到9.2.0.8遇到ORA-06553: PLS-213: package STANDARD not accessible的报错。 测试环境：OS:RHEL 4.8 1，执行catpatch.sql的时候报下面错误 SQL> STARTUP MIGRATE ORACLE instance started. Total ...
-
IMP-00013: only a DBA can import a file exported by another DBA
今天在11.2.0.3环境中用scott导出表，同一个用户再导入到同一个数据库中，切报了下面的错误 [oracle11g@rhel4 sql]$ imp scott/oracle file='/tmp/test.dmp' tables='test_1'; Import: Release 11.2.0.3.0 - Production on Fri Apr 19 09:51:15 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. ...
-
ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks
今天在ASM中增加undo表空间的数据文件是报了上面的错误，最大4194303块，当好32G的大小，在8K的db_block_size的条件下，smallfile表空间单个数据文件最大为32G，bigfile表空间除外。 SQL> alter tablespace undotbs1 add datafile '+CRED1_DATADG' size 32G autoextend off; alter tablespace undotbs1 add datafi ...
-
Auto-tuning: Starting background process GTXj
今天上班，客户QQ发来信息说有个业务RAC中2节点在一直出现GTXj进程不停的重启，当时一看GTXj进程是什么进程哦，reference一搜发现如下的解释： GTXn Global Transaction Process These processes help maintain the global information about XA global transactions throughout the cluster. Also, the proce ...
csdw
是 1031csdw
哈哈,,黄大师,总结得好huangtingzhong
Loading Hinted Executionhuangtingzhong
下面是ASM磁盘头的部分ASM DATA DIhuangtingzhong
RMAN backup to Flash Rechuangtingzhong
Database Crashed With ORhuangtingzhong
How to Resolve ORA-00257123
How To Find The Processhuangtingzhong
How To Generate Same Nam罗罗
哦，懂了！