-
编辑 删除
SQL SERVER 2008 login failed 一例处理
【现象】sql server登陆报错查看ERRORLOG2015-05-13 11:46:53.74 spid27s Recovery is writing a checkpoint in database 'mengniumiddle_sh' (7). This is an informational message only.&...
-
编辑 删除
impdp ORA-39166 Object was not found
帮别人解决的一个问题【现象】impdp nc0427/nc0427 directory=dump_dir dumpfile=nc632015042702.dmp logfile=nc632015042702.log remap_schema=nc63:nc0427 tables=pub_wf_instance_b TABLE_EXISTS_ACTION=appendORA-39002: invalid operationORA-39166:...
-
编辑 删除
分区表之局部索引的分区消除问题
oracle局部索引分为：局部前缀索引（local prefixed index）,分区键在索引定义的前几列上。例如，一个表在名为load_date上的列进行区间分区，该表上的局 部前缀索引以load_date作为其索引列列表中的第一列局部非前缀索引（local ...
-
编辑 删除
/etc/security/limits的中文解释
time(seconds) unlimited此用户的一个进程能占用的CPU处理时间file(blocks) unlimited此用户的进程可以生成和扩展的最大文件大小data(kbytes) 131072此用户的进程可分配使用的最大数据段大小（数据段可以有多个）stack(kbytes) 32768此用户的进程可使用的最大堆栈段大小memory(kbytes) 32768一个用...
-
编辑 删除
安装11g时ASM报错，Check if the DISPLAY variable is set
【现象】[grid@ecc-dg grid]$ env|grep DISPLAYDISPLAY=192.168.0.100:0.0[grid@ecc-dg grid]$[grid@ecc-dg grid]$[grid@ecc-dg grid]$[grid@ecc-dg grid]$ ./runInstaller -ignoresysprereqsStarting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual...
-
编辑 删除
Error "TNS-12518: TNS:listener could not hand off client connection"
In this DocumentSymptomsCauseSolutionAPPLIES TO:Oracle Fusion Application Toolkit - Version 11.1.3.0.0 and laterInformation in this document applies to any platform.**11/3/2014 checked f...
-
编辑 删除
Oracle'sRedoLog
Each Oracle database has a redo log. This redo log records all changes made in datafiles.PurposeThe redo log makes it possible to replay SQL statements.Before Oracle changes data in...
-
编辑 删除
aix mount "vmount: Operation not permitted." Error From NAS NFS
Question点击(此处)折叠或打开When nfs mounting from a Linux NFS server, customer gets the followingerror:vmount: operation not permitedAnswer点击(此处)折叠或打开Environment AIX ve...
-
编辑 删除
drop user drop user cascade区别
1.oracle数据库中删除用户有两种命令，一种是 drop user xxx；另外一个种是drop user xxx cascade;2.官方的说明如下：点击(此处)折叠或打开Dropping a Database User: Example If user Sidney\'s schema contains no objects, then you can drop sidney by issuing the s...
-
编辑 删除
全库导出时报 ORA-39125 ORA-04063 view "SYS.KU$_CLUSTER_VIEW" 有错误
点击(此处)折叠或打开C:\\Documents and Settings\\Administrator>expdp \'/ as sysdba\' directory=dump_dirfull=y dumpfile=fullexp.dmp logfile=fullexp.log parallel=2Export: Release 10.2.0.1.0 - Production on 星期一, 22 12月, 2014 10:08:...
-
编辑 删除
Heap size 2814K exceeds notification threshold (2048K)
客户反应alert.log以下警告一直出现：KGL object name :create table cjb_3 asselect a.xn,a.xq,a.xkkh,a.xh,a.xm,a.kcmc,a.qzxs,a.xf,a.cj,a.zscj,a.jd,a.bz,a.xgsj,a.xgs,a.cxbj,a.pscj,a.qmcj,a.sycj,a.bkcj,a.cxcj,a.kcxz,a.tj,a.tjbz,a.tzf,a.tzfjd,a.kcdm,a.cxxnxq,a.qzcj,a.fxbj,a.jf,a.kcgs,a.xsqr,a....
-
编辑 删除
Oracle Top 5 Timed Events
AWR Top 5 Timed Event
