-
编辑 删除
Set autorace traceonly 的假象
LL@dbfs1>set autotraceUsage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] 有些朋友喜欢用set autotrace 来查看执行计划可是却不知道它的假象，有些朋友认为，set autotrace traceonly explain只是出现执行计划，却不知道其实它已经在后台默默的执行了。例：1....
-
编辑 删除
oracle 安装数据库时 检查 nobody 用户
As the purpose of the user is essentially to allow database users to execute external jobs, you should not use the oracle user. The oracle user is a pow...
-
编辑 删除
导出过程中报ORA-01691unable to extend lob segment...
在导出过程中遇到：ORA-01691: unable to extend lob segment SYS.SYS_LOB0001625349C00044$$ by 61446 in tablespace SYSTEM 很明显是表空间空间不够了，无法导出对象。随后扩展了表空间大小alter tablespace system add datafile '/../../rlv1_system12' size 10g;顺利导出总结： ...
-
编辑 删除
RMAN-06026 RMAN-06023: no backup or copy of datafile
MAN> restore database from tag "TAG20141120T184440";Starting restore at 26-NOV-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=316 device type=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: SID=315 device type=DISKallocated channel: ORA_DISK_3channel ORA_DISK_3: SID=317 device ...
-
编辑 删除
Please set RAT_ELRACKTYPE and try again
今天在客户现场做健康检查时出现这个问题[root@el01cn01 exachk]# ./exachk Unable to determine rack type. Please set RAT_ELRACKTYPE and try again在Oracle MOS中发现了解决方法Error 1:Unable to determine rack type. Please set RAT_ELRACKTYPE and try again.Error 2:Could not open d...
-
编辑 删除
Error message: ORA-48913
发现告警信息Wed Nov 19 07:16:18 2014Dumping diagnostic data indirectory=[cdmp_20141119071618], requested by (instance=1, osid=125680 (J000)),summary=[abnormal process termination].Non critical errorORA-48913 caught while writing to trace file"/u01/app/oracle/diag/rdbms/ed...
-
编辑 删除
使用dcli配置ssh互信
发现Exadata的dcli是个十分好用的工具。今天将该工具get出来，做个一个配置互信的实验。编辑文件，将需要配置互信的节点全部写入[root@db1 ~]# vi all_group 192.168.204.5192.168.204.10使用配置文件执行ssh配置[root@db1 ~]# ./dcli -k -g all_group -l rootError: Neither RSA nor DSA keys have been gen...
