-
编辑 删除
logmnr简易操作说明
......1. run two script, under the user “sys”:SQL>$oracle_home/rdbms/admin/dbmslm.sql;SQL>$oracle_home/rdbms/admin/dbmslmd.sql;2. shut down the DB.3. modify initSID.ora file.We should add parameter ...
-
编辑 删除
Oracle8i: How to migrate LONG RAW to BLOB[from akadia]
In Oracle8i BLOB's (Binary Large Objects) can be used instead of LONG RAW's to store binary unformatted data, like documents, images, audio and video. On the new BLOB data type many of the former LONG...
-
编辑 删除
ora-01591
ORA-01591:错误处理: 锁定已被有问题的分配事务处理XX.XX.XXXXXX挂起1) alter session set "_smu_debug_mode" = 4;2) execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('XX.XX.XXXXXX'); ...
-
编辑 删除
rman error; ora-1220
一个oracle8170数据库,在做rman恢复时遇到这个错误:RMAN-03022: compiling command: resync RMAN-03023: executing command: resync RMAN-08002: starting full resync of recovery catalog RMAN-01005: resync ...
-
编辑 删除
ORA-02062: distributed recovery
今天遇到了这个问题，正好xzh2000的blog上提到了解方法：http://blog.itpub.net/post/96/31085(1) set transaction use rollback segment system (this is VERY important, otherwise database loss can occur) (2) ...
-
编辑 删除
ora-00600[4097][],ora-00600[4194][4]
oracle9204,系统掉电后，部分表的增删改报以上错误解决办法：新建一个undo表空间,使用这个新的.
-
编辑 删除
Migration to 8i / 9i: Set "_SYSTEM_TRIG_ENABLED" to FALSE[akadia]
This important Tip was published on Oracle Metalink.This parameter was introduced in Oracle 8.1. It is a HIDDEN parameter (It begins with an UNDERSCORE). This parameter can only be set in the init.ora...
-
编辑 删除
Checking if LNS processes need to be shutdown
用户电话说，新装了一个数据库，但open一会就当掉，日志内容：Checking if LNS processes need to be shutdown在metalink上找到一个类似的：CauseThese trace files are normal trace files which can be generated ...
-
编辑 删除
Switch to another Oracle User and back[akadia]
Sometimes, the DBA needs to log into a user's account to make a change, such as to grant a privilege on a user's table to another user, but, may not know what the user's password is, or, may need to m...
-
编辑 删除
RFID技术标准现状[zt]
http://www.pld.com.cn/blog/more.asp?name=xudan0303&id=2304
-
编辑 删除
关于通过数据库链路创建视图,字符字段长度加倍的问题
同事打电话,遇到这样一个问题:在8i数据库里通过数据库链路创建了一个视图,desc 之后,某些字符字段长度加倍.导致应用程序出错.开发人员在视图里用了substr函数,结果很慢.8174 cgb 通过 db_link 连 9204 gbk.发现可以...
-
编辑 删除
数据库数据坏块的处理一例
一个统计数据库，开发人员反应，程序运行过程中，遇到如下错误：ORA-00600:[kafspa:columnBuffer1], [1859], [3], [], [], [], [], []做数据库全库逻辑备份时，到某个表报如下错误：EXP-00056: ORACLE error 3113 en...
-
编辑 删除
ora-24347:聚合函数中出现空列
一个pb9.0开发的应用程序，某个数据窗口第一次retrieve，没有问题，第二次以后一定会报以上错误。将sql放到sqlplus里运行，执行多少次都没有问题.怀疑是pb的一个bug.发现其中一个地方写得不规范：sum(decode(a,20,1)...
-
编辑 删除
Tom's tools---autotrace.sql
..set echo onset linesize 121drop table t;clear screencreate table t as select * from all_objects;create index t_idx on t(object_id);begindbms_stats.gather_table_stats( user, 'T', method_opt=> 'for co...
-
编辑 删除
ORA-29540: 类oracle/CDC/PublishApi不存在
在使用cdc时报错解决方法：@。。。。/rdbms/admin/rmcdc.sql@。。。。/rdbms/admin/initcdc.sql
-
编辑 删除
prebuilt table
http://www.itpub.net/showthread.php?threadid=309939&pagenumber=值得推荐.
-
编辑 删除
ORA-26040: Data block was loaded using the NOLOGGING option
最近也遇到了这个问题：ORA-01578: ORACLE data block corrupted (file # 17, block # 271)ORA-01110: data file 17: '/dev/rlv_sgyfz_dat01'ORA-26040: Data block was loaded using the NOLOGGING optionORA-06512...
-
编辑 删除
ORA-01157
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data file 4: '/dev/rdrsys_lv'国庆前用户将网络、主机、数据库全部正常关闭，10.8日开机时遇到这个错。经检查，是由于交换机出故...
-
编辑 删除
exp很慢
升级前准备做一个全库的 exp, 于是就直接运行 crontab 里的脚本，却发现很慢，速度越是50 k/s.es40 ora805 ra7000 1cpu开始以为sga开小了，只有75M(估计是buffer少了一个0)可加大以后,速度依然。于...
-
编辑 删除
Interacting with Oracle via the UNIX Korn shell [adakia]
UNIX remains a fabulous choice for hosting Oracle databases. Both technologies have proven to be more flexible and more stable for more time than most of us care to remember.The remarkable 'Korn' shel...
