http://blog.csdn.net/Petergepeter/拔刀斋的专栏zh-CNWed, 20 May 2009 16:05:00 GMT60拔刀斋http://blog.csdn.net/Petergepeter/archive/2009/05/20/4204135.aspxWed, 20 May 2009 16:03:00 GMThttp://blog.csdn.net/Petergepeter/archive/2009/05/20/4204135.aspxhttp://blog.csdn.net/Petergepeter/comments/4204135.aspxhttp://blog.csdn.net/Petergepeter/archive/2009/05/20/4204135.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/4204135.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=4204135<br />alter system set standby_file_management=manual;<br />select name from v$datafile;<br />##ALTER DATABASE rename FILE '/app/oracle/product/10.2/dbs/UNNAMED00005'  TO '/app/oracle/product/oradata/ora10g/test1.dbf'<br />alter database create datafile 5 as '/app/oracle/product/oradata/ora10g/test1.dbf' size 10M ;<br />alter system set standby_file_management=auto;<br />最后，<br />recover managed standby database disconnect;<img src ="http://blog.csdn.net/Petergepeter/aggbug/4204135.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2009/03/12/3983073.aspxThu, 12 Mar 2009 10:15:00 GMThttp://blog.csdn.net/Petergepeter/archive/2009/03/12/3983073.aspxhttp://blog.csdn.net/Petergepeter/comments/3983073.aspxhttp://blog.csdn.net/Petergepeter/archive/2009/03/12/3983073.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/3983073.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3983073<br />直接用DROP TABLE XXXX PURGE; <br />会遇到 ORA-02449: unique/primary keys in table referenced by foreign keys 错误.<br />改成 DROP TABLE cascade constraints PURGE; <br />即可!<br />然后, 就可以把几百个TABLE统统干掉.<img src ="http://blog.csdn.net/Petergepeter/aggbug/3983073.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2009/03/12/3983033.aspxThu, 12 Mar 2009 10:08:00 GMThttp://blog.csdn.net/Petergepeter/archive/2009/03/12/3983033.aspxhttp://blog.csdn.net/Petergepeter/comments/3983033.aspxhttp://blog.csdn.net/Petergepeter/archive/2009/03/12/3983033.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/3983033.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3983033<br />刚安装完ORACLE APPLICATION SERVER,要登陆发现密码来是不对,晕倒!<br />正好看看如何RESET密码,找了一下,很简单.<br />先把AP 停下, 可以用命令(opmnctl stopall)或菜单(stop SOA suite),<br />然后找到system-jazn-data.xml,<br />修改这段里的<br /><br />oc4jadmin<br />OC4J Administrator<br />401A4A600E9E11DE9F3C171D5C64F0C9<br />OC4J Administrator<br />{903}PdQgmBRfvLNWlbUHOipx3<img src ="http://blog.csdn.net/Petergepeter/aggbug/3983033.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2009/01/08/3734906.aspxThu, 08 Jan 2009 15:50:00 GMThttp://blog.csdn.net/Petergepeter/archive/2009/01/08/3734906.aspxhttp://blog.csdn.net/Petergepeter/comments/3734906.aspxhttp://blog.csdn.net/Petergepeter/archive/2009/01/08/3734906.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/3734906.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3734906processes设置过大，就开不了ORACLE了.<br />ORA-27303: additional information: invalid shared ctx<br />ORA-27146 : post/wait initialization failed<br />ORA-27300: OS system dependent operation:semget failed with status: 28<br />ORA-27301: OS failure message: No space left on device<br />ORA-27302: failure occurred at: sskgpcreates<br /><br />改小点就能开了.<br />虽然semmns已经设了1024了,看来还要加,查了一下参数和Kernel参数的关系.<br /><br />db_block_buffers            shmmax<br />db_files (maxdatafi<img src ="http://blog.csdn.net/Petergepeter/aggbug/3734906.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/10/21/3118308.aspxTue, 21 Oct 2008 16:50:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/10/21/3118308.aspxhttp://blog.csdn.net/Petergepeter/comments/3118308.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/10/21/3118308.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/3118308.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3118308ORACLE EBS前台出错，报Ora-00942: Table Or View Does Not Exist错误，但不知道到底是哪个table or view, 又不能马上看代码，TRACE也没用。后来，突然想到可以使用EVENTS，让它直接报错进dump.<br /><br />ALTER SYSTEM SET EVENTS '942 trace name errorstack level 10';<br /><br />跑应用，果然在ALERT LOG文件里有，ORA-00942的信息， 还有TRACE 文件，<br />打开文件，终于看到哪个TABLE的问题了。<br /><br />用完关掉。<br />ALTER SYSTEM SET EVENTS '942 trace name errorstack off';<br /><br />真是管用,看来除了10046，其它也可以用啊。<img src ="http://blog.csdn.net/Petergepeter/aggbug/3118308.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/09/11/2913585.aspxThu, 11 Sep 2008 15:04:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/09/11/2913585.aspxhttp://blog.csdn.net/Petergepeter/comments/2913585.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/09/11/2913585.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2913585.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2913585lsof可以看process的信息， 不过我主要看Server 端口有哪些进程连接。<br />先下载:<br />ftp://ftp.sunfreeware.com/pub/freeware/sparc/9/lsof-4.80-sol9-sparc-local.gz<br />再解压:<br />gunzip lsof-4.80-sol9-sparc-local.gz<br />变:<br />lsof-4.80-sol9-sparc-local<br />再转换:<br /># pkgtrans  lsof-4.80-sol9-sparc-local .<br />--pkgtrans 将package 由档案系统(file system)的格式, 转成datastream的格式. (不太明白)<br />The following packages are available:<br />  1  SMClsof     lsof<br />     &<img src ="http://blog.csdn.net/Petergepeter/aggbug/2913585.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/09/01/2861878.aspxMon, 01 Sep 2008 15:46:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/09/01/2861878.aspxhttp://blog.csdn.net/Petergepeter/comments/2861878.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/09/01/2861878.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2861878.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2861878转自:http://www.dba-oracle.com/t_detecting_duplicate_indexes.htm<br /><br />真的很神奇的SQL。<br /><br />select /*+ rule */ <br />    a.table_owner, <br />    a.table_name, <br />    a.index_owner, <br />    a.index_name, <br />    column_name_list, <br />    column_name_list_dup, <br />    dup duplicate_indexes, <br />    i.uniqueness, <br />    i.partitioned, <br />  &<img src ="http://blog.csdn.net/Petergepeter/aggbug/2861878.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/08/22/2813555.aspxFri, 22 Aug 2008 13:01:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/08/22/2813555.aspxhttp://blog.csdn.net/Petergepeter/comments/2813555.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/08/22/2813555.aspx#Feedback2http://blog.csdn.net/Petergepeter/comments/commentRss/2813555.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2813555redhat 4:<br />1.建立accuont & password db, logins.txt用后可以删除。<br />vi logins.txt<br /><br />testa<br />testap<br />testb<br />testbp<br /><br />db41_load -T -t hash -f /tmp/logins.txt /etc/vsftpd/vsftpd_load.db<br /><br />chmod 600 /etc/vsftpd/vsftpd_load.db<br /><br />2. 在/etc/pam.d/中创建vsftpd.vu 添加<br />auth    required    /lib/security/pam_us<img src ="http://blog.csdn.net/Petergepeter/aggbug/2813555.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/08/20/2801186.aspxWed, 20 Aug 2008 13:29:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/08/20/2801186.aspxhttp://blog.csdn.net/Petergepeter/comments/2801186.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/08/20/2801186.aspx#Feedback1http://blog.csdn.net/Petergepeter/comments/commentRss/2801186.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2801186先TAR集成到一个包里：<br />tar cvpf test.tar test_folder<br />可以先压缩，或压可以，<br />compress test.tar<br />分解成1G的多个文件，<br />split -b 1000M test.tar.z test.t<br />然后FTP传输，<br />再合并<br />cat test.t* > test.tar.z<br />解压，<br />uncompress test.tar.z<br />再解开，<br />tar xvf test.tar<img src ="http://blog.csdn.net/Petergepeter/aggbug/2801186.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/06/17/2557527.aspxTue, 17 Jun 2008 16:10:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/06/17/2557527.aspxhttp://blog.csdn.net/Petergepeter/comments/2557527.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/06/17/2557527.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2557527.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2557527MWA Tips for Troubleshooting : 269991.1<img src ="http://blog.csdn.net/Petergepeter/aggbug/2557527.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/06/12/2537691.aspxThu, 12 Jun 2008 09:28:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/06/12/2537691.aspxhttp://blog.csdn.net/Petergepeter/comments/2537691.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/06/12/2537691.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2537691.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2537691一编译大量的INVALID OBJECTS，就报<br />Access violation at address XXXXXXXXXXX in module 'SQLNav5.exe'错误。<br />查了一下有个方法，可以避免这个问题，打开windows task manager,即工作管理员，不要关掉。<br />这样一来就好了，不报错了，怪事。<br />据称5.5是好的，因为在服务器上，也懒的安装新版。<img src ="http://blog.csdn.net/Petergepeter/aggbug/2537691.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/06/06/2517464.aspxFri, 06 Jun 2008 16:59:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/06/06/2517464.aspxhttp://blog.csdn.net/Petergepeter/comments/2517464.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/06/06/2517464.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2517464.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2517464HP GlancePlus fatal error.<br />Connection to midaemon lost -- check midaemon process and status.mi.<br /><br />解决方法：<br />mwa stop<br />ps -ef|grep midaemon<br />看看有没有真的结束<br />没有KILL掉。<br />mwa start<br /><br />一切OK。<img src ="http://blog.csdn.net/Petergepeter/aggbug/2517464.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/05/29/2493778.aspxThu, 29 May 2008 16:25:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/05/29/2493778.aspxhttp://blog.csdn.net/Petergepeter/comments/2493778.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/05/29/2493778.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2493778.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2493778刚发现原来Oracle还有这个工具,可以修改block.<br />在9204,10GR1,10GR2下，试了一下都有这个．<br />再查一下，从ORACLE 7就有了．<br />看来还有很多不知道的事情啊！这么隐藏的东东，肯定是给内部用的，有风险的．<br />同alter system dump的作用相同，但还可以修改,不过最好是高手．<br />不过需要link编译一下下：<br />cd $ORACLE_HOME/rdbms/lib<br />make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed<br />或<br />make -f ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed<br />然后就有了，<br />要密码登陆，blockedit.<br />具体等有时间再搞搞．<br />如果想搞挂DB的话，就用这个吧．<img src ="http://blog.csdn.net/Petergepeter/aggbug/2493778.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/05/09/2423208.aspxFri, 09 May 2008 15:38:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/05/09/2423208.aspxhttp://blog.csdn.net/Petergepeter/comments/2423208.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/05/09/2423208.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2423208.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2423208sssu一般肯定会安装，在C:\Program Files\Hewlett-Packard\Sanworks\Element Manager for StorageWorks HSV\Bridge找到SSSU命令，手动先看看能否正常连接：<br />SSSU for HP StorageWorks Command View <br />EVAVersion: 6.0<br />Build : 34<br />&lt<img src ="http://blog.csdn.net/Petergepeter/aggbug/2423208.aspx" width = "1" height = "1" />拔刀斋http://blog.csdn.net/Petergepeter/archive/2008/04/15/2293836.aspxTue, 15 Apr 2008 14:38:00 GMThttp://blog.csdn.net/Petergepeter/archive/2008/04/15/2293836.aspxhttp://blog.csdn.net/Petergepeter/comments/2293836.aspxhttp://blog.csdn.net/Petergepeter/archive/2008/04/15/2293836.aspx#Feedback0http://blog.csdn.net/Petergepeter/comments/commentRss/2293836.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2293836ORACLE 10G R1 重建em<img src ="http://blog.csdn.net/Petergepeter/aggbug/2293836.aspx" width = "1" height = "1" />