ITPub博客

[oracle@bj-etlsrv1 dump_etl]$ oerr ora 3921339213, 00000, "Metadata processing is not available"// *Cause: The Data Pump could not use the Metadata API. Typically,// this is caused by the XSL stylesheets not being set up properly.// *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets// to reload the stylesheets.------解决办法：用SYS用户执行dbms_metadata_util.load_stylesheets即可解决.[@more@]

#enable login shell:vi /etc/security/login.cfg #enable privs of null device to anybody.chmod 777 /dev/nulllssrc -a|grep sshstartsrc -s sshdstopsrc -s sshd#check privs, priv key 600, other 644 :/etc/ssh/*#check other directory privs:/ , /opt , /home/oracle ....[@more@]

Examples 1 To create a new ram disk using a default 512-byte block size, and the size is 500 MBs (1048576 * 512), enter: mkramdisk 1048576 /dev/rramdisk0 The /dev/rramdisk0 ramdisk is created. 2 To create a new ramdisk with a size of 500 Megabytes, enter: mkramdisk 500M /dev/rramdisk0 The /dev/rramdisk0 ramdisk is created. Note that the ramdisk has the same size as example 1 above. 3 To create a new ram

一: nvlselect nvl(字段名,0) from 表名;解释》如果字段的值为null,则用0代替。二：nvl2select nvl2(字段名，'A'，'B'）from 表名解释》如果字段值不为null，输出A，反之输出B。三：lnnvllnnvl只能用于where子句中；表达式的操作符号不能包含 AND, OR, BETWEEN。select * from 表名 where lnnvl(字段名>值)解释：如果lnnvl表达式中的结果为true，输出false，反之输出true四：nullif select nullif(字段A，字段B）from 表名解释》如果字段A等于字段B，输出null，反之输出字段A。 refs:http://blog.sina.com.cn/s/blog_5edcfe6a0100jpna

ref:http://hi.baidu.com/javashmily/blog/item/426e80ee644c0f06fcfa3c75.htmlsummary:LISTAGG Analystic Function in 11g Release 2SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees FROM emp GROUP BY deptno;[@more@]

refs:http://blog.csdn.net/daimin1983/article/details/4291661http://space.itpub.net/index.php?action/viewspace/itemid/629063---------------TNS-12547 Linux Error: 104: Connection reset by peer解决过程参考:http://blog.chinaunix.net/u/7121/showart_403812.html[oracle@MyMachine log]$ lsnrctl startLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2009 09:53:26Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /opt/oracle/product/10.2.1/db_1/bin/tnslsnr: please wait...TNSLSNR for

key: linux 查看网络端口link:http://www.linuxdiyf.com/viewarticle.php?id=187139netstat -an 查看网络端口 lsof -i :port，使用lsof -i :port就能看见所指定端口运行的程序，同时还有当前连接。 nmap 端口扫描作者: freeice 发布日期: 2010-10-291)统计80端口连接数 netstat -nat|grep -i "80"|wc -l 1 2）统计httpd协议连接数 ps -ef|grep httpd|wc -l 1 3）、统计已连接上的，状态为“established' netstat -na|grep ESTABLISHED|wc -l 2 4)、查出哪个IP地址连接最多,将其封了. netstat -na|grep ESTABLISHED|awk '{print

Link:http://bbs.et8.net/bbs/printthread.php?t=874713[@more@]

第一个故事发生在一个使用了DBLINK的UPDATE事物中，执行UPDATE操作本身正常，但是当COMMIT时，就报ORA-02050,ORA-02051 ERROR。用oerror ora 02050/02051查找帮助，没有收获，上网求助也没有收获，正在郁闷时，突然想起会不会是MVIEW LOG导致的，一查，果然有，于是DROP MATERIALIZED VIEW LOG ，再执行更新，终于正确了，大喜啊。 要不然今晚上就回不去了，呜呜。。。。第二个故事发生在11.2.0.1, 11.2.0.2之间，两个库只差了一个子版本，按理说从高版本导出数据到低版本不应有问题，但事实竟然出问题了，一直是 好像是COMPRESS 不能重复

当你遇到不明身份的用户非法尝试登录而导致帐户锁定而影响正常的开发用户或生产环境时，是否会因为找不到那个不法份子而感到抓狂和无耐，那就试试下面的方法吧。create table tab_logon(USERID VARCHAR2(30),WHO VARCHAR2(30),PTS VARCHAR2(30),SERVICE_USER VARCHAR2(30),IP VARCHAR2(30),LOGONDATE DATE,SERVERERROR VARCHAR2(10));CREATE or replace TRIGGER tri_logerror AFTER SERVERERROR ON DATABASEBEGINIF (IS_SERVERERROR (1017)) THENINSERT INTO TAB_LOGON VALUES (SYS_CONTEXT('USERENV', 'SESSIONID'),SYS_CONTEXT('USERENV

-----windows 2003 64bit, 16GB memory,---- oracle 10.2 32bit , (yes , but it is support to be 64bit )when startup db ,encounter an error , following is exception of message.ORA-27102O/S ERROR: (OS 1445).....-------------Action:1, scale up the pagefile size . or 2, add more physical memory, or 3, close some other application which occupy large memory.[@more@]

----错误信息：执行restore database 或 duplicate target database to vmdb2;报如下错误：1、$ rman target / RMAN> restore database;RMAN-03002: failure of restore command at 06/11/2005 01:19:01RMAN-06026: some targets not found - aborting restoreRMAN-06023: no backup or copy of datafile 3 found to restoreRMAN-06023: no backup or copy of datafile 2 found to restoreRMAN-06023: no backup or copy of datafile 1 found to restore----经过深入检讨，发现问题并非没有备份，而是恢复目标路径不存在。----解决办

intel virtual tech. EPT VMM VThttp://hi.baidu.com/zhanghuikl/blog/item/2b7c162472386120d40742f3.html[@more@]

Cause: when you drop the materialized view ,then oracle will to check the integrity of the materilized view , if the mview is created referencing remote object by db-link. then Oracle will access the remote object.Sometimes the db-link is expired, So when you drop mview at the moment, the process will hung and the wait events would be "single-task message" and "enq: TM-contention" .[@more@]

库启动正常，以前用作迁移开发。启动后，服务器本地可以连上，但是远程不行，报TNS-12523 。后台日志显示出 以前配置的网关连接失效。后来实在没招了，设置了本地监听参数，再试，竟然好了。唉，真神奇。。。alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.5.61)(PORT=1521))))' scope=both ;[@more@]

row-level dependency tracking (10g new feature)SCN_TO_TIMESTAMP ora_rowscn SELECT ORA_ROWSCN,rowid from test;select SCN_TO_TIMESTAMP(205810284) from dual;refs:http://www.dbafan.com/blog/?p=194[@more@]

在rac+dataguard的环境中，为了减少应用宕机时间及改动，提高业务的可用性，要求jdbc客户端配置failover。同时为了很好地做应用分割，又不能load balance。即在第一个实例不行时，去偿试第二个实例，两个实例都不行时，去偿试data guard。这样的目的看起来简单，其实有些细小的地方值的注意。下面是一个配置的例子：jdbc:oracle:thin:@(description=(ADDRESS_LIST =(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = x)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = y)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(

11G物化视图支持基于DBLINK远程表的快速刷新,包含有LOB字段的表也可以进行快速刷新了。注意事项：1，在建立物化视图时，如果使用的是完全刷新，那么可以修改刷新方式为快速刷新，但是必须紧接着进行一次完全刷新，之后快速刷才会真正生效。2，基表发生了DDL操作（例如1，在建立物化视图时基表没有PKID，后来为了使用快速刷新，在基表上新加了PKID；2，基表从堆表转换为索引表），影响了数据模型，那么物化视图必须重新创建，否则快速刷新不可用。ALTER MATERIALIZED VIEW COMMONFRAMEWORK.TC_APP REFRESH FAST ;begin dbms_mview.refresh(

impdp 遭遇 ORA-600 错误，解决方法：去掉并行，parallel=1Mon Jun 20 14:49:44 2011DM00 started with pid=58, OS id=19464672, job HLDBA.SYS_IMPORT_SCHEMA_08Mon Jun 20 14:49:48 2011DW00 started with pid=59, OS id=2752626, wid=1, job HLDBA.SYS_IMPORT_SCHEMA_08Mon Jun 20 14:50:06 2011DW01 started with pid=60, OS id=5046318, wid=2, job HLDBA.SYS_IMPORT_SCHEMA_08Mon Jun 20 14:50:06 2011DW02 started with pid=63, OS id=13631978, wid=3, job HLDBA.SYS_IMPORT_SCHEMA_08Mon Jun 20 14:50:06 2011DW03 started with

悲剧的SEQUENCE。。。。。初步猜测可能是由于RAC 中手工修改sys.seq$表造成的。但是从报错的SEQUENCE NAME $ expdp '"hldba/azAZ123$%^"' directory=dump_dir3 logfile=exp_sales_salown061901.log dumpfile=sales_salown061901_%u.dmp schema>Export: Release 11.2.0.2.0 - Production on Sun Jun 19 19:50:16 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit ProductionWith the Partitioning, Real