<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cko82679的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cko82679</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cko82679]]></copyright><item><title><![CDATA[系统运维 查找可以清理的文件]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222503</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222503</guid><author>cko82679</author><pubDate>Fri, 16 Dec 2011 11:44:13 +0800</pubDate><description><![CDATA[AIX 查找相应文件夹中大于10M文件并且按照大小倒排序
find /var -size +10000000c | sort -n -k5,6

HPUX 查找相应文件夹中大于10M文件并且按照大小倒排序
find /...]]></description><category></category></item><item><title><![CDATA[Linux RHEL6.0 系统安装后默认账户]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222507</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222507</guid><author>cko82679</author><pubDate>Wed, 14 Dec 2011 17:45:10 +0800</pubDate><description><![CDATA[RHEL6.0 系统安装后默认账户

root:x:0:0:root:/root:/bin/bashbin:x:1:1:bin:/bin:/sbin/nologindaemon:x:2:2:daemon:/sbin:/sb...]]></description><category></category></item><item><title><![CDATA[Solaris 查看系统配置]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222562</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222562</guid><author>cko82679</author><pubDate>Tue, 13 Dec 2011 21:32:29 +0800</pubDate><description><![CDATA[切换用户：
su - root

进入命令行：
bash

输入命令：
format
df -g

1、如何查看cup的状态？ 作者:南非蜘蛛　 # psrinfo -v # mpstat 可以列出多c...]]></description><category></category></item><item><title><![CDATA[双机软件 AIX启动/关闭双机hacmp]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222504</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222504</guid><author>cko82679</author><pubDate>Mon, 12 Dec 2011 09:32:03 +0800</pubDate><description><![CDATA[启动：
smit hacmpchoose "System Mangement(C-SPOC)"choose "Manage HACMP Services"choose "Start Cluster Services"

...]]></description><category></category></item><item><title><![CDATA[系统运维 挂载/卸载NFS]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222604</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222604</guid><author>cko82679</author><pubDate>Mon, 12 Dec 2011 09:28:28 +0800</pubDate><description><![CDATA[AIX
例如：
df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
rbwdev1:/usr/sap/trans 17...]]></description><category></category></item><item><title><![CDATA[系统运维 账户管理]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222500</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222500</guid><author>cko82679</author><pubDate>Fri, 02 Dec 2011 14:30:50 +0800</pubDate><description><![CDATA[注意：普通用户切换到root应输入：su - root或者su -

AIX:

添加账号：
输入：smit user
选择：Add user
在图像界面中添加账号

设置密码：
passwd 用户名...]]></description><category></category></item><item><title><![CDATA[EXCEL VBA 事件]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222497</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222497</guid><author>cko82679</author><pubDate>Fri, 11 Nov 2011 15:26:01 +0800</pubDate><description><![CDATA[事件1. 有触发条件2. 自动执行3. 工作表级14个，工作薄级36个(包含所有工作表级)，应用程序级43个(包含所有工作薄，工作表级)
如下代码会产生递归调用问题：Private Sub Worksheet_Change(B...]]></description><category></category></item><item><title><![CDATA[EXCEL VBA 常量变量]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222496</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222496</guid><author>cko82679</author><pubDate>Fri, 11 Nov 2011 14:56:13 +0800</pubDate><description><![CDATA[定义变量：dim 变量名 as 类型:模块级或过程级 类似privatepublic 变量名 as 类型:多个模块使用static 变量名 as 类型：静态变量，只有关闭工作薄后释放
手工释放变量 set a = nothi...]]></description><category></category></item><item><title><![CDATA[ORACLE 查看脚本执行计划]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222598</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222598</guid><author>cko82679</author><pubDate>Mon, 31 Oct 2011 15:24:02 +0800</pubDate><description><![CDATA[三种查看方式：
1. EXPLAIN
2. AUTOTRACE;
3. PL/SQL工具

EXPLAIN:
1. 安装：
UNIX: $ORACLE_HOME/rdbms/admin\ultxplan.sql...]]></description><category></category></item><item><title><![CDATA[ORACLE 定位sql脚本]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222493</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222493</guid><author>cko82679</author><pubDate>Mon, 31 Oct 2011 15:22:10 +0800</pubDate><description><![CDATA[1. 通过用户名查询SQL_ID：
select SQL_ID from v$session a where USERNAME ='HR' AND ACTION='SQL Window - New' 

2. 通过SQ...]]></description><category></category></item><item><title><![CDATA[ORACLE 软解析硬解析]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222547</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222547</guid><author>cko82679</author><pubDate>Mon, 31 Oct 2011 15:13:51 +0800</pubDate><description><![CDATA[ORACLE 解析过程：
1、语法检查(syntax check) 检查此sql的拼写是否语法。2、语义检查(semantic check) 诸如检查sql语句中的访问对象是否存在及该用户是否具备相应的权限。3、对sql语句进...]]></description><category></category></item><item><title><![CDATA[Linux Samba 错误处理]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222489</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222489</guid><author>cko82679</author><pubDate>Tue, 25 Oct 2011 11:20:07 +0800</pubDate><description><![CDATA[注意事项：1. 防火墙和selinux：开启samba端口2. 主机名：避免重名3. 建立samba用户4. 用户的权限5. 目录的权限6. 其他事项
samba映射账户vi /etc/samba/smbuserstom = ...]]></description><category></category></item><item><title><![CDATA[Linux Samba 搭建]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222498</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222498</guid><author>cko82679</author><pubDate>Tue, 25 Oct 2011 10:29:42 +0800</pubDate><description><![CDATA[Linux 服务器端 + windows 客户端
匿名服务：1. 检查linux上防火墙设置setupSElinux disableSamba enable重启防火墙：/etc/init.d/iptables restart...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 备份策略]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222548</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222548</guid><author>cko82679</author><pubDate>Wed, 19 Oct 2011 09:50:01 +0800</pubDate><description><![CDATA[主库：备份控制文件；定期清理归档日志；
备库：全库备份包括归档日志并删除；

RHEL平台
主库脚本：
1. RMAN设置：RMAN&gt;configure controlfile autobackup on;RM...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 主备库角色切换]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222486</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222486</guid><author>cko82679</author><pubDate>Tue, 18 Oct 2011 10:36:34 +0800</pubDate><description><![CDATA[主备库切换原因：
1. switch：用户主动切换；
2. failover：主库出现故障，强行切换；

switch切换过程：先主库再备库

主库
1. 查看switchover_status：select ...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 备库模式切换]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222550</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222550</guid><author>cko82679</author><pubDate>Tue, 18 Oct 2011 10:23:51 +0800</pubDate><description><![CDATA[备库模式分类：
1. 自动管理模式
2. 手动管理模式（可以做数据文件增加和重命名操作的）
3. 只读模式

查看备库目前模式：
select * from dba_ojbects;
如果可以查看：为只读模式；...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 保护模式切换]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222545</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222545</guid><author>cko82679</author><pubDate>Tue, 18 Oct 2011 09:56:21 +0800</pubDate><description><![CDATA[保护模式：最大可用：主库上的交易一定需要在在线redo，或者一个备库中更新好了才能提交；如果网络中断，会自动切换成最大性能模式；网络恢复再切换回来。
最大性能：默认模式。不影响主库性能的情况下，尽最大可能保护数据。
最大保护...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 错误]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222495</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222495</guid><author>cko82679</author><pubDate>Mon, 17 Oct 2011 15:19:17 +0800</pubDate><description><![CDATA[ORA-16143 
原因：使用了"recover managed standby database finish;"

解决方法：
1. 在主库创建备库控制文件：
alter database create sta...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 关闭启动]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222492</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222492</guid><author>cko82679</author><pubDate>Mon, 17 Oct 2011 14:08:36 +0800</pubDate><description><![CDATA[关闭：先主库后备库

主库：
关闭监听器：
lsnrctl stop

关闭数据库：
su - oracle
sqlplus / as sysdba
alter system archive log cur...]]></description><category></category></item><item><title><![CDATA[ORACLE DataGuard 物理备库搭建]]></title><link>https://blog.youkuaiyun.com/cko82679/article/details/100222494</link><guid>https://blog.youkuaiyun.com/cko82679/article/details/100222494</guid><author>cko82679</author><pubDate>Mon, 17 Oct 2011 10:13:04 +0800</pubDate><description><![CDATA[试验环境：
Hyper-v 6.0.7601
RHEL 5.3
ORACLE 10gr2
VNC 4.1.3 (用于图像化界面)

主库：
ORACLE_SID: dgtest
DB_UNIQUE_NAME: ...]]></description><category></category></item></channel></rss>