ITPub博客

执行truncate partition时报错：SQL> alter table EC_IOM_OCMDRDER_TBL truncate partition E_I_O_T_2009_APR update global indexes            *ERROR a...

当某个数据库用户在数据库中插入、更新、删除一个表的数据，或者增加一个表的主键时或者表的索引时，常常会出现ora-00054:resource busy and acquire with nowait specified这样的错误。主要是因为有事务正在执行（...

09:21:28 SQL> conn system/passwordConnected.09:28:50 SQL> @$ORACLE_HOME/rdbms/admin/utlxplanTable created.09:29:46 SQL> grant all on plan_table to public;Grant succeeded.09:31:02 SQL> create public sy...

最近一台新上线的Oracle10gR2数据库在警告日志文件中(alert.log)持续出现如下错误:Tue Jul 18 23:09:22 2006WARNING: inbound connection timed out (ORA-3136)Tue Jul 18 23:09:23 2006WARNING: inbound connec...

ORA-01555是常见的oracle错误。相信绝大部分dba都遇到过这个错误。平时面试的时候我也比较喜欢问这个问题，一方面问题比较基础，每个人都有work on it的经验，可以谈谈自己的想法，另一方面容易由此问题引申到其他更...

ORA-04098: 触发器 'PLM.LOGON_DB_TRIGGER' 无效且未通过重新确认CREATE OR REPLACE TRIGGER LOGON_DB_TRIGGERAFTER LOGON ON DATABASEDECLARE  IP VARCHAR2(30);  UNAME VARCHAR2(30);Begin &...

最近数据库突然出现RECO进程不停的报ORA-02068和ORA-03113的错误：Errors in file /oracle/admin/UBISP/bdump/ubisp_reco_23401.trc:ORA-02068: following severe error from DBNAMEORA-03113: end-of-file on commu...

ORA-12838 cannot read/modify an object after modifying it in parallelCause: Within the same transaction, an attempt was made to add read or modification statements on a table after it had been modifie...

通过db-link对远程数据库的一张表进行insert操做，报2069错误补充一下，插入的值中包括本地的一个sequence----------------------------------------------------------------------------------------ORA-02069 ...

数据库报了如下的错误。。Thread 1 advanced to log sequence 23952  Current log# 2 seq# 23952 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\XRISK\REDO02.LOGThu Jun 11 13:52:47 2009Errors in file c:\...

Oracle 10G冒出的错误：ORA-12631: Username retrieval failed Cause: The authentication service failed to retrieve the name of a user. Action: Enable tracing to determine which routine is failing.Error...

ORA-00600: internal error code, arguments: [qerpfAllocateR]由于一个并行的分页查询引发的我的平台为：RHEL4 U6 x86_64,db version :10.2.0.1,Rac 环境ORA-00600: internal error code, arguments: [qerpfAlloca...