ITPub博客

使用了ASM的数据库，修改DBID 和DB NAME参考资料Oracle® Database Utilities10g Release 2 (10.2)Part Number B14215-0116 DBNEWID Utility[@more@]$ sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 27 10:04:05 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL> startup mount;ORACLE instance started.Total System Global Area 2499805184 bytesFixed Size 2022928 bytesVariable Size 620757488 bytesDatabase Buffers 1862270976 bytesRedo Buffe

在创建表时，可以使用ROWDEPENDENCIES 属性，例如SQL> create table t( 2 mycol varchar2(20) 3 ) 4 rowdependencies;加这个属性的作用如下： select ora_rowscn,mycol from t;oracle9i 中虽然有这个属性，但没有ora_rowscn函数，仅仅在数据复制环境中提到了这点.NOROWDEPENDENCIES, the default, specifies that the SCN is tracked at the data block level. ROWDEPENDENCIES specifies that the SCN is tracked for each row in the table. 下面是参考psoug的演示流程，做一个闪回数据库的示例: [@more@]conn / as sysdbaSEL

ORA-06521: PL/SQL: Error mapping function SQL> exec dbms_stats.gather_schema_stats('ys'); begin dbms_stats.gather_schema_stats('ys'); end; ORA-06521: PL/SQL: 映射函数时出错ORA-06512: 在"SYS.DBMS_STATS", line 10070ORA-06512: 在"SYS.DBMS_STATS", line 10564ORA-06512: 在"SYS.DBMS_STATS", line 10751ORA-06512: 在"SYS.DBMS_STATS", line 10805ORA-06512: 在"SYS.DBMS_STATS", line 10782ORA-06512: 在line 2 SQL> exec dbms_stats.gather_table_stats(user,

Finding the current session's ID select sid, serial# from v$session where audsid = sys_context('userenv','sessionid');Or, if you're only interested in the sid, not in serial#: select distinct sid from v$mystat;Note, the selected sid has nothing to do with the System Identifier. If dbms_support is installed, the current sid can also be found with its mysid function: select dbms_support.mysid from dual;Thanks to Jan Arnoldus who pointed out an error on this page! dbms_support的包位于 ?/rdbms/ad

在做tspitr时,发现组织索引表不能被恢复,在TS_PITR_CHECK 检查失败About to export Tablespace Point-in-time Recovery objects...EXP-00008: ORACLE error 29308 encounteredORA-29308: view TS_PITR_CHECK failureORA-06512: at "SYS.DBMS_PITR", line 810ORA-06512: at line 1EXP-00000: Export terminated unsuccessfullyhost command completeRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: =============

在oracle 9i中, 仅是delete误删除数据,还比较容易恢复数据;如果做了truncate 或者 drop 再来恢复,比较麻烦.(当然10g 另外一说)在drop表之后,特别是在生产环境下,可以采用的恢复手段,理论上有全库不完全恢复表空间恢复TSPITR复制一个库来恢复三种.在实际操作中第三种来的相对实用和安全.[@more@]昨晚加班帮朋友做了这样一个恢复.先是准备使用TSPITR，后来发现在前天晚上全备之后，开发人员又添加了一个表空间；另外担心这个表空间上的其它对象；所以后来改用复制一个库出来，Creating a Non-Current Duplicate Database 得以实现。其中复制

RE: Where once can find MAXLOGFILES value other than on "traced" control file?Hi,You can useSQLPLUS> select TYPE,RECORDS_TOTAL from v$controlfile_record_section;The type "REDO LOG" is your answer.HTH,Quamrul Polash[@more@]引自http://www.freelists.org/post/oracle-l/Where-once-can-find-MAXLOGFILES-value-other-than-on-traced-control-file,1另外如何查看maxlogmembers?SQL> Select '--> MAXLOGMEMBERS ' || dimlm from x$kccdi;'-->MAXLOGMEMBERS'||DIMLM------------------------

1 停止备库select process,status from v$managed_standby;alter database recover managed standby database cancel;shutdown immediate;2 在主库上停用到备库的归档.......[@more@][ standby db ] windows下备库的删除过程1 停止备库select process,status from v$managed_standby;alter database recover managed standby database cancel;shutdown immediate;2 在主库上停用到备库的归档alter system set log_archive_dest_state_2=defer scope=both;3 删除备库的口令文件c:oracleora92database> del pwddevdb.ora4 删除备库上的SP

起因： trgt 开始在 catalog 注册使用过一段时间; trgt 没有连接catalog，使用控制文件做了databse resetlog ; 控制文件中记录了两个incarnation; 再次使用catalog连接时，list incarnation; 只显示较早的incartion; 如果RMAN> resync catalog; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of resync command on default ch

Mladen Gogala <mgogala@xxxxxxxxxxx> wrote:I have a RAC database with a standby. Both RAC and standby are on ASM. On standby,I used the flashback recovery area located on the DGFRA diskgroup to create standby redologs. There aren't any problems but I am perplexed by entries like this:RFS[1]: Successfully opened standby log 30: '+DGFRA/adprd/onlinelog/group_30.265.614877861'SUCCESS: diskgroup DGFRA was dismountedSUCCESS: diskgroup DGFRA was mountedSUCCESS: diskgroup DGFRA was dismountedSun F

sp2-0750遇到sp2-0750,看错误号应该是oracle home变量没有设置,但实际上已经设置,为什么还有这个错?难道是因为在windows中编写的然后上传上去的.sh文件? 我直接vi一个就可以使用.[@more@]没有什么证据证明不能这样搞.但换一个方式就行得通.有时候oracle的错误号也是表里不一,你不能离开提示,你也不要局限于提示.

Webspere配置Oracle RAC集群数据源的问题Webspere配置Oracle RAC集群数据源，Oracle双机的IP为10.10.10.121与10.10.10.122 ，实例名分别为orcl1与orcl2，服务名为oracledbservice，采用连接串应为： jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.122)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracledbservice))) 测试的时候，有时成功，有时失败，报如下错误

1.在WEBLOGIC上配置了一个多池，利用WEBLOGIC提供的负载均衡策略，将并发均衡的分别到两个节点上。详细配置在如下参考资料或附件中。 参考资料:http://www.oracle.com/technology/products/weblogic/howto/rac/index.html 2.直接使用了RAC的负载均衡策略。 在Oracle中找到tnsnames.ora这个文件。在配置数据源时，URL修改为如下 jdbc:oracle:thin:@(description=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.159)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.158)(PORT = 1521))(load_balance=yes)(fa

1.在WEBLOGIC上配置了一个多池，利用WEBLOGIC提供的负载均衡策略，将并发均衡的分别到两个节点上。详细配置在如下参考资料或附件中。 参考资料:http://www.oracle.com/technology/products/weblogic/howto/rac/index.html 2.直接使用了RAC的负载均衡策略。 在Oracle中找到tnsnames.ora这个文件。在配置数据源时，URL修改为如下 jdbc:oracle:thin:@(description=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.159)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.158)(PORT = 1521))(load_balance=yes)(fa

How-To Configure and Use Oracle Real Application Clusters (RAC) with Oracle WebLogic Server 10.3http://www.oracle.com/technology/products/weblogic/howto/rac/index.html[@more@]How-To Configure and Use Oracle Real Application Clusters (RAC) with Oracle WebLogic Server 10.3要点服务器端tnsnames.oraHASERVICE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = apemrac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = apemrac2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA =

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.10.115)(PORT=1521))' sid='devdb1';System altered. SQL> conn sys/oracle@devdb2 as sysdba Connected. SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.10.116)(PORT=1521))' sid='devdb2'; System altered. [@more@]也可以在建库之后,备份PFILE之后,在pfile中修改 例如pfile.bakprk2.local_listener='LISTENER_PRK2'prk1.local_listener='LISTENER_PRK1'tnsnames.oraLISTENER_PRK2 =(ADDRESS = (PROTOCOL = TCP)(HOST =

开发人员遇到的一个问题:一个存储过程在开发环境中可能使用,迁移到正式环境中编译报这个错误,原因是数据类型不一致[@more@]在一个XML处理存储过程中,使用了dbms_xmldom包,当从开发环境向正式环境中迁移时,遇到PLS-00801: internal error [pdticv:CHR/AFC网上有人说是10G的程序向9迁时的问题,Maaher说是数据类型不一致的原因,经过查找,确定是数据类型不一致的原因.相关链接:http://www.orafaq.com/forum/t/58400/2/you are trying to assing a VARCHAR2 column to a locally declared type. I could easily reproduce it.Code: [Select all

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

这两天处理了两例因杀毒软件造成的数据库故障，两例的共同点是oracle 9i + windows2003。[@more@]第一例是某省某数据库于凌晨3点钟挂掉，再也不能启来了。在服务中启动也报错，net start启动时提示找不到文件，找不到服务。找不到什么文件？最后查出是杀毒辣软件将oracle进程给停掉之后，将oracle.exe文件给隔离了。恢复oracle.exe 故障解决。第二例是某省在安装数据库时，进行到88%的时候，挂起，不再进行。手工建监听器也惨遭失败。日志中没有什么可参考的价值。因为是windows，所以怀疑操作系统是不是有病毒？是不是什么补丁没打？之类

一兄弟准备备份开发环境的数据库，在做EXP导出时失败，症状如下：使用开发用户导出，报ora-31600使用system用户导出，正在导出对象类型定义的时候挂起[@more@]C:>exp mjjj/oracle file=d:mjjj.dmp rows=n owner=mjjjEXP-00056: 遇到 ORACLE 错误 31600ORA-31600: 输入值 EMIT_SCHEMA 无效, 它用于参数 NAME, 位于函数 SET_TRANSFORM_PARAM 中ORA-06512: 在"SYS.DBMS_SYS_ERROR", line 105ORA-06512: 在"SYS.DBMS_METADATA_INT", line 3926ORA-06512: 在"SYS.DBMS_METADATA_INT", line 4050ORA-06512: 在