<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[yanjian_0809的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/yanjian_0809</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yanjian_0809]]></copyright><item><title><![CDATA[Clickhouse用户管理及登陆]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/112257186</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/112257186</guid><author>yanjian_0809</author><pubDate>Wed, 06 Jan 2021 11:45:30 +0800</pubDate><description><![CDATA[打开users.xml



Install vim编辑器：


root@b9c8a34c7b70:/# apt-get update
root@b9c8a34c7b70:/# apt-get install vim

授权可读写权限：


root@b9c8a34c7b70:/etc/clickhouse-server# chmod 777 users.xml 
//可写可读可执行

添加用户yanfang


&lt;yanfang&gt;
                    
&lt;passw]]></description><category></category></item><item><title><![CDATA[Docker安装ClickHouse]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/112240944</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/112240944</guid><author>yanjian_0809</author><pubDate>Tue, 05 Jan 2021 16:39:38 +0800</pubDate><description><![CDATA[1. 安装 Docker

2. 下载clickhouse代码：https://github.com/tlightsky/clickhouse-on-cluster

3. docker-compose.yaml中的version 改成3.1

4. 在代码所在路径下：make

5. 完成后输入以下命令：


localhost~:clickhouse-on-cluster-master yanfang$ docker ps
CONTAINER ID        IMAGE               ]]></description><category></category></item><item><title><![CDATA[Oracle 报错笔记]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/97267079</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/97267079</guid><author>yanjian_0809</author><pubDate>Mon, 18 Nov 2019 14:48:43 +0800</pubDate><description><![CDATA[1、ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

原因1：端口号不一样

登陆到DB后：


SQL&gt; show parameter local_listener

NAME                 TYPE
------------------------------------ -------------------...]]></description><category></category></item><item><title><![CDATA[使用VirtualBox打开虚拟机报错：Raw-mode is unavailable courtesy of Hyper-V]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/103079445</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/103079445</guid><author>yanjian_0809</author><pubDate>Fri, 15 Nov 2019 09:52:10 +0800</pubDate><description><![CDATA[报错界面如下：



为了使VirtualBox能够启动虚拟机，必须在Windows 10中关闭Hyper-V。

1、检查Hyper-V设置

管理员模式启动cmd，输入命令：



bcdedit


执行后看到 hypervisorlaunchtype值为‘Auto’：



2、关闭 hypervisorlaunchtype

管理员身份cmd下执行命令：



bcdedit / set...]]></description><category></category></item><item><title><![CDATA[Linux下卸载自带Java并手动安装]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/98180535</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/98180535</guid><author>yanjian_0809</author><pubDate>Fri, 02 Aug 2019 12:34:48 +0800</pubDate><description><![CDATA[1、查看自带Java版本


[root@localhost /]# java -version
openjdk version "1.8.0_161"
OpenJDK Runtime Environment (build 1.8.0_161-b14)
OpenJDK 64-Bit Server VM (build 25.161-b14, mixed mode)


2、查询OpenJDK


...]]></description><category></category></item><item><title><![CDATA[安装图形化SUSE11]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/95627838</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/95627838</guid><author>yanjian_0809</author><pubDate>Fri, 12 Jul 2019 17:17:00 +0800</pubDate><description><![CDATA[选择Installation，F6选择yes



OK，回车



Back，回车









Next



Next



Next



选择时区，Next



Next



分区（/boot，/root，swap三个分区）

点击Partitioning



Custom Parttitioning，Next



双击Hard Disks--点击sda--点击下方Ad...]]></description><category></category></item><item><title><![CDATA[Linux下搭建本地邮件服务器EwoMail]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/88049332</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/88049332</guid><author>yanjian_0809</author><pubDate>Fri, 01 Mar 2019 10:22:23 +0800</pubDate><description><![CDATA[一、安装EwoMail邮件服务器

系统要求：centos6/7系统（需能连接网络，虚拟机/物理机均可）

1.、检查swap是否开启，如没启动需要配置启动swap

fdisk -l  查看分区



free  查看swap分区是否生效



若有swap信息，说明已启动swap

若没有swap信息，则需要启动：


格式化swap分区：  mkswap /dev/sd...]]></description><category></category></item><item><title><![CDATA[Linux下Oracle安装完成后配置及使用]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/85067687</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/85067687</guid><author>yanjian_0809</author><pubDate>Tue, 18 Dec 2018 16:38:10 +0800</pubDate><description><![CDATA[一、创建数据库

在oracle用户的图形界面终端输入dbca：

[oracle@localhost ~]$ dbca

回车弹出如下界面：





这里选第一行和第二行都可以











不勾选specify flash recovery area



去掉不常用的模块 

















二、配置监听及本地网络服务

[oracle@localhost ~]$ ...]]></description><category></category></item><item><title><![CDATA[Linux系统启动Oracle数据库报错问题集锦]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/85060706</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/85060706</guid><author>yanjian_0809</author><pubDate>Tue, 18 Dec 2018 10:19:40 +0800</pubDate><description><![CDATA[1、报错：could not open parameter file '/data/oracle/product/11.2.0/db_1/dbs/initorcl.ora'

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 17 17:19:08 2018

Copyr...]]></description><category></category></item><item><title><![CDATA[Linux Redhat6.4 安装Oracle数据库]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84972723</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84972723</guid><author>yanjian_0809</author><pubDate>Mon, 17 Dec 2018 16:42:05 +0800</pubDate><description><![CDATA[一、安装图形化桌面环境

yum -y groupinstall Desktop

yum -y groupinstall &quot;X Window System&quot;

yum -y groupinstall &quot;KDE Desktop&quot;  

二、安装配置JDK

1、卸载自带openJDK：

[root@localhost ~]# rpm -aq|grep java | xargs rpm -e --...]]></description><category></category></item><item><title><![CDATA[Linux输入命令报错：command not found...]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84998940</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84998940</guid><author>yanjian_0809</author><pubDate>Fri, 14 Dec 2018 10:25:44 +0800</pubDate><description><![CDATA[[oracle@zoe ~]$ ls
-bash: ls: command not found
[oracle@zoe ~]$ vi /home/oracle/.bash_profile
-bash: vi: command not found

以上输入基础命令系统报错，说明环境变量出现问题，重新配置PATH参数：
[oracle@zoe ~]$ export PATH=/usr/local/s...]]></description><category></category></item><item><title><![CDATA[VMware中Linux启动时出现：Host SMBus controller not enabled]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84987596</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84987596</guid><author>yanjian_0809</author><pubDate>Thu, 13 Dec 2018 14:12:28 +0800</pubDate><description><![CDATA[出现问题如下： 



解决：

[root@localhost ~]# lsmod|grep i2c_piix4
i2c_piix4              22106  0
i2c_core               40325  2 drm,i2c_piix4
[root@localhost modprobe.d]# vi /etc/modprobe.d/blacklist.conf

...]]></description><category></category></item><item><title><![CDATA[Linux Redhat7 修改主机名]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84983463</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84983463</guid><author>yanjian_0809</author><pubDate>Thu, 13 Dec 2018 11:00:50 +0800</pubDate><description><![CDATA[linux重启系统后主机名自动变成了aca832a3：


[root@aca832a3 ~]#


在配置文件 /etc/sysconfig/network中也只有如下内容：


# Created by anaconda


修改配置文件，vi /etc/sysconfig/network：


# Created by anaconda
HOSTNAME=localhost
NETWORKI...]]></description><category></category></item><item><title><![CDATA[yum update]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84973036</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84973036</guid><author>yanjian_0809</author><pubDate>Wed, 12 Dec 2018 15:36:28 +0800</pubDate><description><![CDATA[[root@localhost ~]# yum update
Loaded plugins: langpacks, product-id, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subsc
ription-manager to regist...]]></description><category></category></item><item><title><![CDATA[Linux下解决网卡重启失败：Job for network.service failed because the con trol process exited with error code]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84973230</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84973230</guid><author>yanjian_0809</author><pubDate>Wed, 12 Dec 2018 15:06:02 +0800</pubDate><description><![CDATA[[root@localhost ~]#  service network restart
Restarting network (via systemctl):  Job for network.service failed because the con
trol process exited with error code. See &quot;systemctl status network.serv...]]></description><category></category></item><item><title><![CDATA[报错initscripts conflicts with redhat-release-server-7.0-1.el7.x86_64]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84972264</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84972264</guid><author>yanjian_0809</author><pubDate>Wed, 12 Dec 2018 14:49:12 +0800</pubDate><description><![CDATA[
Error: initscripts conflicts with redhat-release-server-7.0-1.el7.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest


解决：

删除冲突...]]></description><category></category></item><item><title><![CDATA[Linux下VNC安装与配置（含解决xhost:unable to open display）]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84957551</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84957551</guid><author>yanjian_0809</author><pubDate>Tue, 11 Dec 2018 16:46:50 +0800</pubDate><description><![CDATA[1、检查是否安装VNC

[root@localhost ~]# yum install -y vnc vnc-server

2、[root@localhost ~]# chmod 777 root/.vnc/xstartup

3、修改vnc 分辨率:


vi /usr/bin/vncserver：

$geometry = &quot;1200x700&quot;


4、修改 /root/.vnc/xsta...]]></description><category></category></item><item><title><![CDATA[VMWare下Linux系统使用SFTP传输文件]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84941438</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84941438</guid><author>yanjian_0809</author><pubDate>Mon, 10 Dec 2018 16:20:13 +0800</pubDate><description><![CDATA[一、物理机连接Linux

1、创建sftp组： groupadd sftp

      创建用户sftpuser：useradd -g sftp -s /bin/false sftpuser

      设置sftpuser用户的密码：passwd sftpuser

      创建一个sftp的上传目录：mkdir /fang/sftpfiles

      修改用户sftpuser所...]]></description><category></category></item><item><title><![CDATA[VMWare虚拟机设置桥接网络]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/84936473</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/84936473</guid><author>yanjian_0809</author><pubDate>Mon, 10 Dec 2018 13:23:33 +0800</pubDate><description><![CDATA[一、进入虚拟机设置界面



设置桥接网络：



二、进入编辑—&amp;gt;虚拟机网络编辑器



刚安装完VMWare后找不到VMnet0，需要进入用管理员权限进入更改设置界面



设置VMnet0为桥接，选择物理本机使用的无线网卡，点击apply。可在控制面板-网络与共享中心查看现在使用的无线网卡。





三、配置网络设置文件

进入Linux系统，修改/etc/sysconfig/net...]]></description><category></category></item><item><title><![CDATA[Windows10自动安装打印机步骤]]></title><link>https://blog.youkuaiyun.com/yanjian_0809/article/details/82685337</link><guid>https://blog.youkuaiyun.com/yanjian_0809/article/details/82685337</guid><author>yanjian_0809</author><pubDate>Thu, 13 Sep 2018 11:31:19 +0800</pubDate><description><![CDATA[1、打开网络共享，可以选择使用已连接的专用网络内部共享。前提：电脑连接的wifi须与之对应，即连接专用网络

2、查看共享内是否能找到目标打印机，若找不到，打开网络和共享中心-网络和共享中心-更改高级共享设置，在专用网络下，选中“启动文件和打印机共享”，点击确定

3、进入控制面板，设备和打印机-添加打印机，正常情况下能够自动搜索到网络内的目标打印机，选中后点击下一步，Windows10系统自动搜...]]></description><category></category></item></channel></rss>