<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[halley333的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/halley333</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; halley333]]></copyright><item><title><![CDATA[用Linux命令行获取本机外网IP地址]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/87914134</link><guid>https://blog.youkuaiyun.com/halley333/article/details/87914134</guid><author>halley333</author><pubDate>Mon, 25 Feb 2019 11:37:06 +0800</pubDate><description><![CDATA[ 

?


			1

			2

			3

			4

			5

			6

			7

			8

			9

			10

			11

			12

			13

			14

			15

			16

			17

			18

			19

			20

			21

			22

			23

			24

			25

			26

			27

			28

			29
...]]></description><category></category></item><item><title><![CDATA[centos7 3 升级内核到4]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/85615066</link><guid>https://blog.youkuaiyun.com/halley333/article/details/85615066</guid><author>halley333</author><pubDate>Wed, 02 Jan 2019 14:38:08 +0800</pubDate><description><![CDATA[虽然很多人都认为Linux是一个完整的操作系统，但是确切的来讲，Linux仅仅指的是内核本身。另一方面，不同的发行版本是在内核基础上提供不同应用软件及库文件的完整功能系统。

在操作系统的全部操作中，内核主要负责以下两项重要任务：

充当系统应用软件和硬件的接口
	尽可能有效的管理系统资源
为此，内核可以通过现有驱动程序或特定模块来同主机硬件进行通信。例如，主机的某一个应用需要使用无线网络，那么这...]]></description><category></category></item><item><title><![CDATA[关于linux中oracle用户进程占用内存猜测]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/80693159</link><guid>https://blog.youkuaiyun.com/halley333/article/details/80693159</guid><author>halley333</author><pubDate>Thu, 14 Jun 2018 15:09:47 +0800</pubDate><description><![CDATA[本文是针对linux下面显示oracle用户进程占用大量内存的一个猜想性说明,希望各位专家和我一起继续探讨该问题ORACLE用户进程占用私有内存分析top命令结果[oracle@ora02 31500]$ top -c top - 12:13:16 up 254 days, 12:14,  2 users,  load average: 1.53, 1.62, 1.33Tasks: 293 tot...]]></description><category></category></item><item><title><![CDATA[docker 安装nexus]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/80423694</link><guid>https://blog.youkuaiyun.com/halley333/article/details/80423694</guid><author>halley333</author><pubDate>Wed, 23 May 2018 17:55:15 +0800</pubDate><description><![CDATA[Sonatype Nexus3 Docker: sonatype/nexus3A Dockerfile for Sonatype Nexus Repository Manager 3, based on CentOS.Contribution GuidlinesRunningBuilding the Nexus Repository Manager imageChef Solo for Runti...]]></description><category></category></item><item><title><![CDATA[vsftpd]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/80238126</link><guid>https://blog.youkuaiyun.com/halley333/article/details/80238126</guid><author>halley333</author><pubDate>Tue, 08 May 2018 13:10:36 +0800</pubDate><description><![CDATA[vsftpd.conf配置文件讲解#监听端口
listen_port=21
#允许写入
write_enable=YES
#设置umask
local_umask=022
#启用日志
xferlog_enable=YES
#设置日志路径
xferlog_file=/var/log/vsftpd.log
#指定FTP使用20端口进行数据传输，默认值为YES。
connect_from_port_20...]]></description><category></category></item><item><title><![CDATA[oracle dg 状态检查]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/80149984</link><guid>https://blog.youkuaiyun.com/halley333/article/details/80149984</guid><author>halley333</author><pubDate>Mon, 30 Apr 2018 16:51:11 +0800</pubDate><description><![CDATA[先检查备库的归档日志同步情况 SELECT NAME,applied FROM v$archived_log; alter database recover managed standby database cancel;select thread#,sequence#,standby_dest,archived,applied,status from v$archived_log order b...]]></description><category></category></item><item><title><![CDATA[docker-ce安装——centos]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/79950018</link><guid>https://blog.youkuaiyun.com/halley333/article/details/79950018</guid><author>halley333</author><pubDate>Sun, 15 Apr 2018 15:59:46 +0800</pubDate><description><![CDATA[第一种 使用清华源镜像

如果你之前安装过 docker，请先删掉

 


sudo yum remove docker docker-common docker-selinux docker-engine

 


sudo yum install -y yum-utils device-mapper-persistent-data lvm2


根据你的发行版下载repo文件: CentOS...]]></description><category></category></item><item><title><![CDATA[docker 安装升级redmine]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/79461691</link><guid>https://blog.youkuaiyun.com/halley333/article/details/79461691</guid><author>halley333</author><pubDate>Tue, 06 Mar 2018 18:03:00 +0800</pubDate><description><![CDATA[redmine docker 安装参考https://docs.docker.com/samples/library/redmine/#run-redmine-with-sqlite31 首先安装docker 略过2 docker 启动一个数据库 启动mysqldocker run -d --name redminemysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD...]]></description><category></category></item><item><title><![CDATA[mysql 导出CSV文件 并带表头or字段]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/78647030</link><guid>https://blog.youkuaiyun.com/halley333/article/details/78647030</guid><author>halley333</author><pubDate>Mon, 27 Nov 2017 17:18:21 +0800</pubDate><description><![CDATA[今天在使用mysql的into outfile命令将数据库数据导出为csv时，发现数据可以导出，但是列名却没有，但是却可以通过修改sql语句的方法加上表头，具体实现方法是在查找数据的时候并上列名： 



#!/bin/bash
#提示输入要导出数据的月份
read -n 2 -p "请输入要导出的数据的月份必须两位,如1月请输入01,10月输入10:" mon
if [ ! -d ]]></description><category></category></item><item><title><![CDATA[oracle收集统计信息]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/78269572</link><guid>https://blog.youkuaiyun.com/halley333/article/details/78269572</guid><author>halley333</author><pubDate>Wed, 18 Oct 2017 09:53:29 +0800</pubDate><description><![CDATA[date=`date +%Y%m%d -d "-740 days"`
date1=`date +%Y%m%d -d "-1 days"`
sqlplus -s '/ as sysdba' 
set feed off
set linesize 100
set pagesize 200
exec dbms_stats.gather_schema_stats(ownname => user']]></description><category></category></item><item><title><![CDATA[shell 1-9 转换01到09 批量压缩文件]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/78266046</link><guid>https://blog.youkuaiyun.com/halley333/article/details/78266046</guid><author>halley333</author><pubDate>Tue, 17 Oct 2017 20:43:35 +0800</pubDate><description><![CDATA[#!/bin/bash
for i in  `seq 30`
do 
num=`printf "%02d\n" $i`
echo $num
done]]></description><category></category></item><item><title><![CDATA[exp/imp导入对象无效]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/78228018</link><guid>https://blog.youkuaiyun.com/halley333/article/details/78228018</guid><author>halley333</author><pubDate>Fri, 13 Oct 2017 16:44:51 +0800</pubDate><description><![CDATA[BEGIN
  DBMS_UTILITY.compile_schema('SCOTT'); --重新编译用户下所有的程序
END ;



BEGIN
SYS.UTL_RECOMP.recomp_parallel(threads =>8 ,schema =>'SCOTT' );--重新编译用户下所有的程序
END ;]]></description><category></category></item><item><title><![CDATA[sqlldr的使用]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/78106422</link><guid>https://blog.youkuaiyun.com/halley333/article/details/78106422</guid><author>halley333</author><pubDate>Tue, 26 Sep 2017 20:20:01 +0800</pubDate><description><![CDATA[收到一个任务，需要往oracle库里导入很多excel文件，而且excel文件很大，每个都在500M左右，最后考虑采用sqlldr。先来了解下sqlldr



[oracle@linux ~]$ sqlldr  
  
SQL*Loader: Release 11.2.0.1.0 - Production on 星期四 3月 1 13:15:47 2012  
  
Copyri]]></description><category></category></item><item><title><![CDATA[生成循环建索引sql]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/77967542</link><guid>https://blog.youkuaiyun.com/halley333/article/details/77967542</guid><author>halley333</author><pubDate>Wed, 13 Sep 2017 16:16:17 +0800</pubDate><description><![CDATA[set serveroutput on;
declare
 vsql varchar(4000);
 
begin
 for i in 1..28
 loop
select 'CREATE INDEX HYPTRAW.IDX_TRANS_VEH_LOCATE_201702'||lpad(i,2,0)||' ON HYPTRAW.TRANS_VEHICLE_LOCATE_201702']]></description><category></category></item><item><title><![CDATA[ogg配置记录]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/77574273</link><guid>https://blog.youkuaiyun.com/halley333/article/details/77574273</guid><author>halley333</author><pubDate>Fri, 25 Aug 2017 15:46:17 +0800</pubDate><description><![CDATA[ogg配置这里不详细介绍了，可以参考下面两篇文章。
http://blog.youkuaiyun.com/linucle/article/details/13505939

http://blog.youkuaiyun.com/miyatang/article/details/10220827

我主要记录下我配置过程过遇到的问题及解决方法
1 ogg ddl过滤
我要同步所有ddl，但部分表的drop不同]]></description><category></category></item><item><title><![CDATA[expdp/impdp优化]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/77539982</link><guid>https://blog.youkuaiyun.com/halley333/article/details/77539982</guid><author>halley333</author><pubDate>Thu, 24 Aug 2017 19:08:38 +0800</pubDate><description><![CDATA[ssd固态+impdp system/oracle@pdbbi directory=DATA_PUMP_DIR remap_schema=BI:BI remap_tablespace=bi_backup:bi,bi:bi,BI_PARTITION:bi,BI_INDEX:bi exclude=function  parallel=10 TRANSFORM=DISABLE_ARCHIVE_LOGGI]]></description><category></category></item><item><title><![CDATA[一个简单的循环rsync是否同步完成脚本]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/77097378</link><guid>https://blog.youkuaiyun.com/halley333/article/details/77097378</guid><author>halley333</author><pubDate>Fri, 11 Aug 2017 14:43:44 +0800</pubDate><description><![CDATA[用rsync来同步文件，有时会碰到网络等问题同步未完成，写了个简单的循环判断，若同步失败则每隔5分钟再去同步
#!/bin/bash
date=`date +%F`
rsynclog=/home/data/log/rsync$date.log
echo `date` >> $rsynclog
/usr/bin/rsync -azP -e ssh *.*.*.*:/data/wd/HYZX]]></description><category></category></item><item><title><![CDATA[使用netstat和awk命令来统计网络连接数]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/77008139</link><guid>https://blog.youkuaiyun.com/halley333/article/details/77008139</guid><author>halley333</author><pubDate>Wed, 09 Aug 2017 18:03:37 +0800</pubDate><description><![CDATA[统计连接数
netstat -n|awk '/^tcp/{++S[$NF]} END {for(a in S) print a,"\t",S[a]}'
会得到类似下面的结果，具体数字会有所不同：

LAST_ACK         1
SYN_RECV         14
ESTABLISHED      79
FIN_WAIT1        28
FIN_WAIT2]]></description><category></category></item><item><title><![CDATA[jvm优化]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/76180589</link><guid>https://blog.youkuaiyun.com/halley333/article/details/76180589</guid><author>halley333</author><pubDate>Thu, 27 Jul 2017 12:21:44 +0800</pubDate><description><![CDATA[JAVA_OPTS="$JAVA_OPTS -server -Xms4096m -Xmx4096m -Xmn1536m -XX:PermSize=128M -XX:MaxPermSize=256M -XX:SurvivorRatio=1 -XX:+PrintGCD
etails -XX:+PrintGCDateStamps -XX:+PrintGCTimeStamps -XX:+PrintHea]]></description><category></category></item><item><title><![CDATA[java.net.MalformedURLException: Local host name unknown: java.net.UnknownHostException]]></title><link>https://blog.youkuaiyun.com/halley333/article/details/72867522</link><guid>https://blog.youkuaiyun.com/halley333/article/details/72867522</guid><author>halley333</author><pubDate>Mon, 05 Jun 2017 15:19:44 +0800</pubDate><description><![CDATA[最近碰到一个问题奇怪，通过jdbc 连接池连数据库第一次连接初始化很慢，每次都要超过1分钟左右，由于oracle默认连接超过60秒就会拒绝，因此导致程序连不上数据库，虽然后期调了数据库连接限制，但每次重启连接数据库都很慢。检查网络，其他都正常。一直找不到原因，直到一次重启tomcat时日志报如下错误，才明白是dns解析问题，主机名没法解析到IP。


Error: Exception thr]]></description><category></category></item></channel></rss>