<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[bbccaaac的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/bbccaaac</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; bbccaaac]]></copyright><item><title><![CDATA[k3s pod无法访问外部网络]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/130486977</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/130486977</guid><author>bbccaaac</author><pubDate>Thu, 04 May 2023 15:02:53 +0800</pubDate><description><![CDATA[操作系统：centos7内核：3.10.0-957.el7.x86_64k3s版本： v1.25.7+k3s1。]]></description><category></category></item><item><title><![CDATA[oracle审计管理]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/112553254</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/112553254</guid><author>bbccaaac</author><pubDate>Wed, 13 Jan 2021 09:23:17 +0800</pubDate><description><![CDATA[适用于11g r2及以上版本，通过DBMS_AUDIT_MGMT包来管理审计记录
查看mgmt配置参数：
SELECT * FROM dba_audit_mgmt_config_params;
PARAMETER_NAME		       PARAMETER_VALUE		      AUDIT_TRAIL
------------------------------ ------------------------------ ----------------------------
DB AUDIT T]]></description><category></category></item><item><title><![CDATA[systemd记录]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/111668086</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/111668086</guid><author>bbccaaac</author><pubDate>Fri, 25 Dec 2020 11:45:30 +0800</pubDate><description><![CDATA[对于支持systemd的软件，通过rpm安装时，会自动在/usr/lib/systemd/system目录中添加一个相应的配置文件。
如果需要让软件开机时启动，以mysqld为例，执行：
[root@cisqjserver system]# systemctl enable mysqld
ln -s ‘/usr/lib/systemd/system/mysqld.service’ ‘/etc/systemd/system/multi-user.target.wants/mysqld.service’
此命令]]></description><category></category></item><item><title><![CDATA[tomcat数据库连接不释放（二）]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/111554336</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/111554336</guid><author>bbccaaac</author><pubDate>Tue, 22 Dec 2020 15:38:48 +0800</pubDate><description><![CDATA[之前写过《tomcat数据库连接不释放》排查过程及方法，数据库sql是一个原因，另一个原因则可能是网络问题，当应用程序正在读取数据库数据时，网络由于不稳定或其他一些未知原因出现问题时，可能导致应用服务器的数据库TCP连接hang住（但此连接在应用服务器上存在，数据库中实际已经不存在），从而阻塞tomcat连接池的清理线程。因此如果能够手动kill掉应用服务器上的TCP连接或者配置read timeout是不是就解决了此问题？经过查询资料和测试，目前有了以下的解决方法：
一、KILL TCP连接(此方法未经测]]></description><category></category></item><item><title><![CDATA[socat返回permission denied排查记录]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/108360374</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/108360374</guid><author>bbccaaac</author><pubDate>Wed, 02 Sep 2020 13:44:19 +0800</pubDate><description><![CDATA[操作系统版本：Centos 7 2003

开发人员反馈通过socat做正向代理，连接socat代理返回permission denied，根据日志查看发现执行connect函数时返回EACCES，即permission denied。注：程序是root用户执行的

man connect查看返回错误可能原因：

EACCES For Unix domain sockets, which are identified by pathname: Write permission is denied on th]]></description><category></category></item><item><title><![CDATA[Mysql Transportable Tablespaces]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/105853598</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/105853598</guid><author>bbccaaac</author><pubDate>Thu, 30 Apr 2020 08:37:57 +0800</pubDate><description><![CDATA[https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
]]></description><category></category></item><item><title><![CDATA[LGWR SYNC步骤]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/105093610</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/105093610</guid><author>bbccaaac</author><pubDate>Wed, 25 Mar 2020 13:58:48 +0800</pubDate><description><![CDATA[LGWR SYNC redo transport is a synchronous process that causes the database to delay acknowledgment of user commits until the following actions have been completed:

LGWR writes redo to the online redo...]]></description><category></category></item><item><title><![CDATA[tomcat数据库连接不释放]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/104988046</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/104988046</guid><author>bbccaaac</author><pubDate>Fri, 20 Mar 2020 13:56:00 +0800</pubDate><description><![CDATA[最近几个月，某项目的应用系统总是会出现tomcat数据库连接池耗尽的情况，此问题也一直困扰着我，连接池相关参数设置如下：


maxActive=200;

logAbandoned=true;

abandonWhenPercentageFull=50;

removeAbandoned=true;

removeAbandonedTimeout=60


当连接池耗尽后，

从数据库层面排查，...]]></description><category></category></item><item><title><![CDATA[[WARNING] Failed to getClass for org.apache.maven.plugin.source.SourceJarMojo]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/104797873</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/104797873</guid><author>bbccaaac</author><pubDate>Wed, 11 Mar 2020 15:48:55 +0800</pubDate><description><![CDATA[使用jenkins通过maven构建项目时出现警告信息：

[WARNING] Failed to getClass for org.apache.maven.plugin.source.SourceJarMojo

jenkinsmaven插件报错位置：https://github.com/jenkinsci/maven-plugin/blob/1b30d831d13ce8dce87d2b55...]]></description><category></category></item><item><title><![CDATA[openssh远程升级及rpm包构建操作]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103922033</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103922033</guid><author>bbccaaac</author><pubDate>Fri, 10 Jan 2020 11:54:20 +0800</pubDate><description><![CDATA[一、openssh升级

环境：centos7

1、为防止挂掉，先启用telnet
[root@cisqjserver openssh-8.1p1]# yum install -y xinetd.x86_64 telnet-server zlib-devel openssl-devel pam-devel

[root@cisqjserver openssh-8.1p1]# systemctl...]]></description><category></category></item><item><title><![CDATA[oracle 11.2.0.4 rac静默安装]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103870070</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103870070</guid><author>bbccaaac</author><pubDate>Tue, 07 Jan 2020 10:40:01 +0800</pubDate><description><![CDATA[具体可参考：https://www.cnblogs.com/hmwh/p/8484696.html
一、静默安装grid
1、通过参数形式传入  此方式推荐使用自动安装时使用如使用ansible自动化安装时可使用该方式
/dbsoftware/tools/oracle_11g/grid/runInstaller -silent -force -waitforcompletion -ignoresy...]]></description><category></category></item><item><title><![CDATA[VB程序逆向常用的函数]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103693598</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103693598</guid><author>bbccaaac</author><pubDate>Wed, 25 Dec 2019 09:46:13 +0800</pubDate><description><![CDATA[VB程序逆向常用的函数

1) 数据类型转换:

a) __vbaI2Str 将一个字符串转为8 位（1个字节）的数值形式(范围在 0 至 255 之间) 或2 个字节的数值形式(范围在 -32,768 到 32,767 之间)。
b)__vbaI4Str 将一个字符串转为长整型(4个字节)的数值形式(范围从-2,147,483,6482,147,483,647)
c)__vbar4St...]]></description><category></category></item><item><title><![CDATA[英语句子]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103456588</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103456588</guid><author>bbccaaac</author><pubDate>Mon, 09 Dec 2019 13:50:16 +0800</pubDate><description><![CDATA[1、五种基本句型：

主谓句型：主语+不及物动词

主系表句型：主语+系动词+表语

主谓宾句型：主语+及物动词+宾语

主谓双宾句型：主语+及物动词+间宾(人)+直宾(物)

主谓宾补句型：主语+及物动词+宾语+补语



2、句子种类（按结构）

简单句：只有一个主语或并列主语+一个谓语或并列谓语

并列句：把两个或几个简单句用并列连词或分号连接起来，就是一个并列句。常用的并列连词如：平行并...]]></description><category></category></item><item><title><![CDATA[redis配置与不宕机升级建议]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103416600</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103416600</guid><author>bbccaaac</author><pubDate>Fri, 06 Dec 2019 09:34:06 +0800</pubDate><description><![CDATA[来自
1、建议部署在linux操作系统上，redis的压力测试在linux上测得比较多
2、在/etc/sysctl.conf中设置linux内核参数vm.overcommit_memory=1。该内核参数含义（参考Documentation/sysctl/vm.txt）：When this flag is 1, the kernel pretends there is always enough...]]></description><category></category></item><item><title><![CDATA[mysql相关指标监控]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103232390</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103232390</guid><author>bbccaaac</author><pubDate>Mon, 25 Nov 2019 09:10:49 +0800</pubDate><description><![CDATA[#! /bin/bash
# *******作者：        payne                             
# *******创建时间：  2019/11/21                           
# *******功能：     用于监控mysql相关状态          
# *******版本：			v1.0						
# *******说...]]></description><category></category></item><item><title><![CDATA[shell 颜色显示]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103199258</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103199258</guid><author>bbccaaac</author><pubDate>Fri, 22 Nov 2019 13:31:52 +0800</pubDate><description><![CDATA[#!/bin/sh
# *******作者：        payne                                    *********
# *******创建时间：  2018/7/27                                  *********
# *******功能：      带颜色的回显                         ...]]></description><category></category></item><item><title><![CDATA[Python struct使用简介]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/103164672</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/103164672</guid><author>bbccaaac</author><pubDate>Wed, 20 Nov 2019 15:56:04 +0800</pubDate><description><![CDATA[#!/usr/bin/python
# -*- coding: utf-8 -*-

# @version: v1.0
# @author: payne fu
# @email: bbccaaac@163.com
# @file name: test.py 
# @created time: 2019/11/20 14:31
import struct

import struct
# 详细使用...]]></description><category></category></item><item><title><![CDATA[oracle 11g rac打补丁步骤及注意事项]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/102918615</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/102918615</guid><author>bbccaaac</author><pubDate>Tue, 05 Nov 2019 16:28:22 +0800</pubDate><description><![CDATA[一、检查opatch的版本
$ /u01/app/11.2.0/grid/OPatch/opatch version
二、检查 Inventory有效性：
$ /u01/app/11.2.0/grid/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
三、用root用户在/u01/app/11.2.0/grid/OPatch/ocm/bin/下，...]]></description><category></category></item><item><title><![CDATA[LVM扩容]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/102913779</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/102913779</guid><author>bbccaaac</author><pubDate>Tue, 05 Nov 2019 13:14:06 +0800</pubDate><description><![CDATA[显示物理卷
[root@cim-kfxt-test02 /]# pvdisplay
— Physical volume —
PV Name               /dev/sda2
VG Name               vg_cimtest
PV Size               19.51 GiB / not usable 3.00 MiB
Allocatable        ...]]></description><category></category></item><item><title><![CDATA[oracle账号不过期问题]]></title><link>https://blog.youkuaiyun.com/bbccaaac/article/details/102779667</link><guid>https://blog.youkuaiyun.com/bbccaaac/article/details/102779667</guid><author>bbccaaac</author><pubDate>Mon, 28 Oct 2019 13:43:15 +0800</pubDate><description><![CDATA[今天查看账号状态发现一个奇怪的现象：

SQL&gt; select username,account_status,EXPIRY_DATE,LOCK_DATE from dba_users;

KFZ账号过期日期是19年6月11日，但现在是10月份，该账号居然没过期，没被锁，密码策略设置如下：

SQL&gt; select * from dba_profiles;



90天过期，但6月份到...]]></description><category></category></item></channel></rss>