-
编辑 删除
sysdba不能远程登录
sysdba不能远程登录这个也是一个很常见的问题了。 碰到这样的问题我们该如何解决呢？ 我们用sysdba登录的时候，用来管理我们的数据库实例，特别是有时候，服务器不再本台机器，这个就更是有必要了。&n...
-
编辑 删除
Oracle中sequence cache的测试
今天做了一个测试，有关oracle中sequence的cache的测试： sequence是以默认值20递增的， 新建seq=last_number=1 nextval执行后 当seq.currval=1时，last_number=21; 当se...
-
编辑 删除
pro_drop_seq
-------------------------------------------------- Export file for user ZHIFU ---- Created by zhanglei o...
-
编辑 删除
pro_create_seq
-------------------------------------------------- Export file for user ZHIFU ---- Created by zhanglei o...
-
编辑 删除
java.sql.SQLException: OALL8 处于不一致状态
转载：http://13594135.iteye.com/blog/904913一次做应用升级出现了一个问题，描述如下： 升级分为两块，一块是数据库结构变更（表结构增加新字段）;一块是应用程序的升级。 应用环境为：...
-
编辑 删除
审计数据库登陆失败触发器
1. 输入日志oerr ora 101701017, 00000, "invalid username/password; logon denied"alert.log2011-07-01 10:14:04 logon denied from 172.16.15.57 ccclyi with sqlplus.exe 2011-07-01 10:14:53 logon denied fro...
-
编辑 删除
审计数据库登陆登出触发器
1. 登陆触发器CREATE OR REPLACE TRIGGER DB_LOGONAFTER LOGON ON DATABASEBEGIN insert into user_logon values(sys_context('userenv','host'), sys_context('userenv','session_user'),...
-
编辑 删除
"DROP USER" fails with error: ORA-00942 and ORA-00604 (二)
Drop User command fails with errors ORA-00604 and ORA-00942 [ID 375954.1] --------------------------------------------------------------------------------Applies to: Oracle Server - Enterprise Editi...
-
编辑 删除
"DROP USER" fails with error: ORA-00942 and ORA-00604 (一)
今天同事遇到一个问题，他在drop table和drop user的时候都报了同一个错误：SQL> drop user testb;drop user testb*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-00942: table or view d...
-
编辑 删除
Bug 2784796: ORA-00001:UNIQUE CONSTRAINT
类型B - Defect已在产品版本中修复10.1.0.1严重性2 - Severe Loss of Service产品版本9.2.0.2.0状态80 - Development to Q/A平台38 - z*OBSOLETE: IBM AIX 4.3 Based Systems (64-bit)创建时间04...
-
编辑 删除
ora-00054:resource busy and acquire with nowait specified解决方法
转帖：http://space.itpub.net/12778571/viewspace-561543当某个数据库用户在数据库中插入、更新、删除一个表的数据，或者增加一个表的主键时或者表的索引时，常常会出现ora-00054:resource busy and acquire with ...
-
编辑 删除
ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errors
转帖：http://www.net527.cn/shujukuguanli/Oracle/2010/0503/10110.html 今天同事碰到一个问题：ORA-04068: existing state of packages has been discardedORA-04063: package body "SYS.DBMS_EXPORT_EXT...
-
编辑 删除
Import Datapump Job fails with ORA-39125
Import Datapump Job fails with ORA-39125 KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT [ID 453918.1] -------------------------------------------------------------------------------- &...
-
编辑 删除
Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE?
Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE? 文档 ID: 465423.1类型: HOWTO 上次修订日期: 27-APR-2009状态: PUBLISHEDIn this Document Goal ...
-
编辑 删除
MTBF=MTTF+MTTR
Mean Time Between Failure --MTBFMean Time To Repair --MTTRMean Time To Failure &n...
-
编辑 删除
ORA-600 [krslint.9] in PRIMARY database
Bug 8869647 - ORA-600 [krslint.9] in PRIMARY database. Standby fails to fetch gap sequence [ID 8869647.8] -------------------------------------------------------------------------------- ...
-
编辑 删除
ORA-27046: file size is not a multiple of logical block size
今天用数据泵搭建的同步环境同步失败了，报错信息如下：ORA-39002: invalid operationORA-31694: master table "<master table name>" failed to load/unloadORA-31640: unable to open dump file "<dump fi...
-
编辑 删除
FAQ about Detecting and Resolving Locking Conflicts [ID 15476.1]
找到一篇关于锁的很好的文章：FAQ about Detecting and Resolving Locking Conflicts [ID 15476.1] -------------------------------------------------------------------------------- ...
-
编辑 删除
How to find Current open Cursors in Oracle
select a.value, s.username, s.sid, s.serial# from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid=a.sid and b.name = 'opened cursors current';&...
-
编辑 删除
ORA-01013: User Requested Cancel Of Current Operation
How To Handle Error Java.sql.SQLException: ORA-01013: User Requested Cancel Of Current Operation [ID 788246.1] --------------------------------------------------------------------------------&...
