Sat, 27 Nov 2010 12:35:00 GMTCSDN博客聚合服务http://blog.csdn.net/blogrss.aspx?username=liuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2010/11/27/6039928.aspx葡萄10斤、冰糖2斤，葡萄洗净摘下，凉干水（洗葡萄时的水，不是让你把它晒成葡萄干），抓碎。最好是用豆浆机之类的与冰糖一起打碎更好，放入醰子中1.5--2个月。就可以喝到自己泡的葡萄酒了。10斤葡萄大约可以泡出6-7瓶矿泉水那么多的葡萄酒。今天喝了一个朋友自己做出的葡萄酒，味道不错，有葡萄酒味，还有点甜甜的。<img src="http://www1.feedsky.com/t1/441778370/liuya1985liuya/csdn.net/s.gif?r=http://blog.csdn.net/liuya1985liuya/archive/2010/11/27/6039928.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778370/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778370/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 27 Nov 2010 20:35:00 +0800刘亚http://blog.csdn.net/liuya1985liuya/archive/2010/11/27/6039928.aspx刘亚http://blog.csdn.net/liuya1985liuya/archive/2010/11/27/6039928.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778370/1077667http://blog.csdn.net/liuya1985liuya/archive/2010/05/20/5610581.aspx<br />jdk/bin目录下native2ascii.exe文件可以直接将中文转成unicode.<br />cmd进到bin目录下，运行native2ascii.exe。输入中文回车后就生成了unicode编码。<br />直接双击运也行，我在CMD下运行主要是为了方便将转换后的编码拷贝出来。<br />例：<br />cmd<br />cd C:\Java\jdk1.5.0_17<br />C:\Java\jdk1.5.0_17>native2ascii<br />蝇埋藏    (输入后回车)<br />\u8747\u57cb\u85cf<img src="http://www1.feedsky.com/t1/441778371/liuya1985liuya/csdn.net/s.gif?r=http://blog.csdn.net/liuya1985liuya/archive/2010/05/20/5610581.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778371/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778371/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 20 May 2010 11:08:00 +0800刘亚http://blog.csdn.net/liuya1985liuya/archive/2010/05/20/5610581.aspx刘亚http://blog.csdn.net/liuya1985liuya/archive/2010/05/20/5610581.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778371/1077667http://blog.csdn.net/liuya1985liuya/archive/2009/05/24/4212500.aspx<br />root用户<br />[root@localhost /]# cd /dev<br />查看你的光驱类型 <br />[root@localhost dev]# ls cdrom -l<br />lrwxrwxrwx  1 root root 3 2009-05-25  cdrom -> hdc<br />[root@localhost ~]# cd /media/cdrom<br />[root@localhost cdrom]# ls<br />啥都没有看到<br />知道了你的CDROM类型,现在挂载<br />[root@localhost dev]# mount /dev/hdc /media/cdrom<br />mount: block device /dev/hdc is write-protected, mounting read-only<br />[root@localhost dev]# ls /media/cdrom<br />client  gzip.exe  ics  install  keygen  linux  rebuild.bat<img src="http://www1.feedsky.com/t1/441778372/liuya1985liuya/csdn.net/s.gif?r=http://blog.csdn.net/liuya1985liuya/archive/2009/05/24/4212500.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778372/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778372/art01.gif" onerror="this.style.display='none'" /></a></p>Sun, 24 May 2009 15:37:00 +0800刘亚http://blog.csdn.net/liuya1985liuya/archive/2009/05/24/4212500.aspx刘亚http://blog.csdn.net/liuya1985liuya/archive/2009/05/24/4212500.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778372/1077667http://blog.csdn.net/liuya1985liuya/archive/2009/05/20/4202698.aspx用户liuya9and10创建视图create or replace view statsas select 'STAT...' || a.name name, b.value      from v$statname a, v$mystat b     where a.statistic# = b.statistic#    union all    select 'LATCH.' || name,  gets      from v$latch union all select 'STAT...Elapsed Time', hsecs from v$timer;报ORA-01031: insufficient privileges 权限不足,奇怪我已授予用户DBA权限,grant select any table to liuya9and10;授予用户询所有表的权限,在次创建还是不行.有点晕.grant<img src="http://www1.feedsky.com/t1/441778373/liuya1985liuya/csdn.net/s.gif?r=http://blog.csdn.net/liuya1985liuya/archive/2009/05/20/4202698.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778373/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778373/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 20 May 2009 01:21:00 +0800刘亚http://blog.csdn.net/liuya1985liuya/archive/2009/05/20/4202698.aspx刘亚http://blog.csdn.net/liuya1985liuya/archive/2009/05/20/4202698.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778373/1077667http://blog.csdn.net/liuya1985liuya/archive/2009/02/01/3856024.aspx环境 XP SP2 oracle 10.2由于电脑中毒,不得已重装系统,保留了完整的oradata目录下的所有文件(目录中的所有文件并未损坏),装完系统后想重用原库利用如下方法;重新建库,创建控制文件STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "orcl" NORESETLOGS  NOARCHIVELOG--  SET STANDBY TO MAXIMIZE PERFORMANCE    MAXLOGFILES 50    MAXLOGMEMBERS 5    MAXDATAFILES 100    MAXINSTANCES 1    MAXLOGHISTORY 113LOGFILE  GROUP 1 'D:\oracle\product\10.2.0\oradata\orcl\REDO01.LOG'  SIZE 50M,  GROUP 2 'D:\or<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778374/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778374/art01.gif" onerror="this.style.display='none'" /></a></p>Sun, 01 Feb 2009 00:41:00 +0800刘亚http://blog.csdn.net/liuya1985liuya/archive/2009/02/01/3856024.aspx刘亚http://blog.csdn.net/liuya1985liuya/archive/2009/02/01/3856024.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778374/1077667http://blog.csdn.net/liuya1985liuya/archive/2009/01/30/3855197.aspxoracle 10g OEM服务启动不起来解决办法<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778375/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778375/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 30 Jan 2009 21:22:00 +0800liuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2009/01/30/3855197.aspxliuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2009/01/30/3855197.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778375/1077667http://blog.csdn.net/liuya1985liuya/archive/2008/11/25/3373421.aspxOracle在执行一个SQL之前,首先要分析一下语句的执行计划,然后再按执行计划去执行。分析语句的执行计划的工作是由优化器(Optimizer)来完成的。不同的情况,一条SQL可能有多种执行计划,但在某一时点,一定只有一种执行计划是最优的,花费时间是最少的。相信你一定会用Pl/sql Developer、Toad等工具去看一个语句的执行计划,不过你可能对Rule、Choose、First rows、All rows这几项有疑问,因为我当初也是这样的,那时我也疑惑为什么选了以上的不同的项,执行计划就变了? 1、优化器的优化方式 Oracle的优化器共有两种的优化方式,即基于规则的优化方式(Rule-Based Optimization,简称为RBO)和基于代价的优化方式(Cost-Based Optimization,简称为CBO)。 A、RBO方式：优化器在分析SQL语句时,所遵循的是Oracle内部预定的一些规则。比如我们常见的,当一个where子句中的一列有索引时去走索引。 B、CBO方式：依词义可知,它是看语句的代价(Cost)<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778376/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778376/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 25 Nov 2008 22:25:00 +0800liuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/25/3373421.aspxliuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/25/3373421.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778376/1077667http://blog.csdn.net/liuya1985liuya/archive/2008/11/18/3326980.aspx<br /><br />一、关闭并卸载RedHat9.0自带的Openssh <br /><br />1.1 停止服务 <br /><br />#service sshd stop <br /><br />1.2 卸载Openssh <br /><br />#rpm -e openssh --nodeps <br />#rpm -e openssh-server --nodeps <br />#rpm -e openssh-clients --nodeps <br />#rpm -e openssh-askpass-gnome <br />#rpm -e openssh-askpass <br /><br />二、下载安装最新的openssl和openssh <br /><br />2.1 下载相关软件包至/usr/local/src目录  <br /><br />http://www.openssl.org/source/openssl-0.9.8e.tar.gz<br /><br />2.2 安装openssl <br /><br />#cd /<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778377/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778377/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 18 Nov 2008 16:46:00 +0800liuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/18/3326980.aspxliuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/18/3326980.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778377/1077667http://blog.csdn.net/liuya1985liuya/archive/2008/11/13/3294394.aspxos:Oracle-Enterprise-R5-U2-Server-i386<br />Oracle:linux_x86_11gR1_database<br /><br /><br />在Windows操作系统上,当在DOS命令窗口中运行SQL*Plus的时候,可以使用向上,向下键来跳回之前已经执行过的SQL语句.你可以根据需要修改他们,然后按Enter键重新提交执行.<br />然而,当在Linux Shell中运行SQL*Plus的时候,并不提供浏览历史命令行的功能.<br />为了在Linux中达到同样的目的,你可以安装rlwrap,这个程式本身是个Shell,可以运行任何你提供给它的命令包括参数,并添加命令历史浏览功能.The rlwrap program is under the GPL license.<br /><br /><br />一:安装readline<br />OS的安装光盘里提供了readline包.<br />[root@oracle11g ~]# rpm -Uvh readline*<br />error: Failed dependencies: lib<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778378/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778378/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 13 Nov 2008 22:50:00 +0800liuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/13/3294394.aspxliuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/13/3294394.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778378/1077667http://blog.csdn.net/liuya1985liuya/archive/2008/11/12/3285476.aspx<br />  做JAVA开发,想向DBA发展,一直学管理方面的东西,对存储过程一直以为都是编码,只是语法不同,今天做存储过程定制JOB的时候发现不是那么回事,看来还要好多要学呀!!!!!!!!<br /><br />说明: procedure 本身可以执行.但是放到job中执行错误<br />ORA-12012: 自动执行作业 187 出错<br />ORA-01031: 权限不足<br />ORA-06512: 在"EMMA.PACK_SMS", line 16<br />ORA-06512: 在"EMMA.PACK_SMS", line 36<br /><br /><br /><br />奇怪的就是proc本身能够执行,但是放到job中为什么不能执行了呢,查看proc ,发现里面存在 execute immediate create table ,<br />说明:在存储过程中使用的到系统权限不能通过rule来授权,需要显示授权,或者使用AUTHID CURRENT_USER<br />发现次存储过程使用了AUTHID CURRENT_USER ,所以存储过程能够执行.可是<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liuya1985liuya/441778379/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liuya1985liuya/441778379/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 12 Nov 2008 22:05:00 +0800liuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/12/3285476.aspxliuya1985liuyahttp://blog.csdn.net/liuya1985liuya/archive/2008/11/12/3285476.aspxhttp://blog.csdn.net/liuya1985liuya/feed.aspxcsdn.net/liuya1985liuya/~1077668/441778379/1077667