<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[yongzai666的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/yongzai666</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yongzai666]]></copyright><item><title><![CDATA[mysql安装时的重置密码语句]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/89348754</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/89348754</guid><author>yongzai666</author><pubDate>Wed, 17 Apr 2019 08:47:59 +0800</pubDate><description><![CDATA[sql&gt;alter user 'root'@'localhost' identified by 'new password';
]]></description><category></category></item><item><title><![CDATA[volatile详解]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/87857397</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/87857397</guid><author>yongzai666</author><pubDate>Thu, 21 Feb 2019 11:13:21 +0800</pubDate><description><![CDATA[volatile详解：http://www.cnblogs.com/dolphin0520/p/3920373.html]]></description><category></category></item><item><title><![CDATA[kettle集群的搭建]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/87182670</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/87182670</guid><author>yongzai666</author><pubDate>Wed, 13 Feb 2019 14:59:54 +0800</pubDate><description><![CDATA[http://www.kettle.net.cn/1601.html]]></description><category></category></item><item><title><![CDATA[建立有dba权限的用户]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/86493269</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/86493269</guid><author>yongzai666</author><pubDate>Tue, 15 Jan 2019 15:18:41 +0800</pubDate><description><![CDATA[1.用有dba权限的用户登录：sys用户

2.创建一个新用户：create user EXCHANGE identified by EXCHANGE;
          create user U_FRONT2GPS identified by FRONT2GPS;
3.授予DBA权限： grant connect,resource,dba to EXCHANGE; grant connect...]]></description><category></category></item><item><title><![CDATA[查看端口是否被占用]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/86489678</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/86489678</guid><author>yongzai666</author><pubDate>Tue, 15 Jan 2019 11:21:57 +0800</pubDate><description><![CDATA[输入命令：netstat -ano，查看所有端口号。
输入命令：netstat -aon|findstr &quot;端口号&quot; ,查看某个端口及被占用端口对应的PID。
一般解决方法：重启服务器。]]></description><category></category></item><item><title><![CDATA[tomcat配置参数]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/86489455</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/86489455</guid><author>yongzai666</author><pubDate>Tue, 15 Jan 2019 11:12:19 +0800</pubDate><description><![CDATA[1.内存参数调优

说明：tomcat初始堆内存8G;最大堆内存16G;新生代内存为最大堆内存的3/8,这里是6G;持久化内存默认82M,项目中使用月100M，必须重设，可以考虑256M或者更多，这个设置的2G，最大设置的是4G;
存活比率默认是2:8，这里使用的默认设置8，不宜调太小，避免垃圾回收过于频繁;-XX:+UseConcMarkSweepGC，垃圾并行回收，加快垃圾回收速率;


注意...]]></description><category></category></item><item><title><![CDATA[Oracle密码过期处理方法]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/86489324</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/86489324</guid><author>yongzai666</author><pubDate>Tue, 15 Jan 2019 11:06:28 +0800</pubDate><description><![CDATA[以Oracle用户登陆，输入以下命令查询密码有效期
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
然后修改密码期限
alter profile default  limit password_life_time unlimited;
commit;
再次查询
se...]]></description><category></category></item><item><title><![CDATA[cmd数据库重启]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/86489289</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/86489289</guid><author>yongzai666</author><pubDate>Tue, 15 Jan 2019 11:04:39 +0800</pubDate><description><![CDATA[（1） 以oracle身份登录数据库，命令：su –oracle  (如果需要指定实例：export ORACLE_SID=user_test --user_test为数据库)
（2） 进入Sqlplus控制台，命令：sqlplus / as sysdba
（3） 启动数据库，命令：startup
（4） 如果是关闭数据库，命令：shutdown immediate
（5） 退出sqlplus控制...]]></description><category></category></item><item><title><![CDATA[bat文件实现ftp上传和下载]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/86488761</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/86488761</guid><author>yongzai666</author><pubDate>Tue, 15 Jan 2019 10:44:40 +0800</pubDate><description><![CDATA[1、FTP上传和下载的bat脚本。

脚本分为两部分：可执行bat脚本和ftp命令文件；

可执行bat脚本：


			1

			2
			
			
			@echo off

			ftp -s:D:\ftp\ftp.txt
			
		 ftp命令ftp.txt：


			1

			2

			3

			4

			5

			6

			7

			8

			9

			10

...]]></description><category></category></item><item><title><![CDATA[下载系统盘]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82856885</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82856885</guid><author>yongzai666</author><pubDate>Wed, 26 Sep 2018 17:47:11 +0800</pubDate><description><![CDATA[https://msdn.itellyou.cn/

复制链接到迅雷下载]]></description><category></category></item><item><title><![CDATA[db2修改字段长度及表死锁后的reorg table 如何在DbVisualizer执行]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82704393</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82704393</guid><author>yongzai666</author><pubDate>Fri, 14 Sep 2018 15:58:34 +0800</pubDate><description><![CDATA[alter table 表名alter column 字段名 set data type varchar(300)
CALL SYSPROC.ADMIN_CMD('REORG table 表名') ;]]></description><category></category></item><item><title><![CDATA[oracle dba给普通用户授权]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82426074</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82426074</guid><author>yongzai666</author><pubDate>Wed, 05 Sep 2018 16:25:57 +0800</pubDate><description><![CDATA[grant resource to 用户名；]]></description><category></category></item><item><title><![CDATA[cmd oracle导入sql文件]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82388661</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82388661</guid><author>yongzai666</author><pubDate>Tue, 04 Sep 2018 19:06:22 +0800</pubDate><description><![CDATA[登录到dba：sqlplus / as sysdba
sql文件的存放地址：@D:\*.sql；]]></description><category></category></item><item><title><![CDATA[表格中sql语句的批量生成（wps不行）]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82379350</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82379350</guid><author>yongzai666</author><pubDate>Tue, 04 Sep 2018 10:23:49 +0800</pubDate><description><![CDATA[ 

=&quot; update 表名 set 字段='&quot;&amp;amp;单元格标号&amp;amp;&quot;'   where 字段名='&quot;&amp;amp;单元格标号&amp;amp;&quot;'  ;&quot;

写好后按住单元格的右下角往下拉。]]></description><category></category></item><item><title><![CDATA[USERS没有权限，给数据库权限]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82252156</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82252156</guid><author>yongzai666</author><pubDate>Fri, 31 Aug 2018 10:16:08 +0800</pubDate><description><![CDATA[ 

alter user 数据库名 quota unlimited on USERS;]]></description><category></category></item><item><title><![CDATA[Warning:  Cannot read drop down range Unrecognized token]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82116003</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82116003</guid><author>yongzai666</author><pubDate>Mon, 27 Aug 2018 17:12:51 +0800</pubDate><description><![CDATA[        WorkbookSettings workbooksetting = new WorkbookSettings();
        workbooksetting .setCellValidationDisabled(true);//去掉验证数据有效性
        Workbook workbook = Workbook.getWorkbook(uploadfile,work...]]></description><category></category></item><item><title><![CDATA[Oracle修改某字段的长度]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82022848</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82022848</guid><author>yongzai666</author><pubDate>Fri, 24 Aug 2018 17:36:18 +0800</pubDate><description><![CDATA[alter table 表名 modify （列名 数据类型（新长度））；]]></description><category></category></item><item><title><![CDATA[Oracle数据库查询条件为日期类型的字段]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/82022741</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/82022741</guid><author>yongzai666</author><pubDate>Fri, 24 Aug 2018 17:35:03 +0800</pubDate><description><![CDATA[SELECT
    *
FROM
    abc
WHERE
    TRANS_TIME 
        BETWEEN 
            &quot;TO_DATE&quot;('2018-04-23 10:38:00', 'yyyy-mm-dd hh24:mi:ss')
        AND
            &quot;TO_DATE&quot; ('2018-04-23 10:40:00','yyyy-mm...]]></description><category></category></item><item><title><![CDATA[Oracle修改字段类型]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/81535058</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/81535058</guid><author>yongzai666</author><pubDate>Thu, 09 Aug 2018 13:30:35 +0800</pubDate><description><![CDATA[1、假设字段数据为空，则不管改为什么字段类型，可以直接执行：
alter table tb modify (name nvarchar2(20));2、假设字段有数据，则改为nvarchar2(20)可以直接执行：
alter table tb modify (name nvarchar2(20));3、假设字段有数据，则改为varchar2(40)执行时会弹出：“ORA-01439:要更改数据类...]]></description><category></category></item><item><title><![CDATA[varchar2和nvarchar2的不同点]]></title><link>https://blog.youkuaiyun.com/yongzai666/article/details/81535011</link><guid>https://blog.youkuaiyun.com/yongzai666/article/details/81535011</guid><author>yongzai666</author><pubDate>Thu, 09 Aug 2018 13:27:39 +0800</pubDate><description><![CDATA[具体到NVARCHAR2和VARCHAR2的区别，从使用角度来看区别在于：NVARCHAR2在计算长度时和字符集相关的，例如数据库是中文字符集时以长度10为例，则

1、NVARCHAR2(10)是可以存进去10个汉字的，如果用来存英文也只能存10个字符。

2、而VARCHAR2(10)的话，则只能存进5个汉字，英文则可以存10个。...]]></description><category></category></item></channel></rss>