<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[csub31890的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/csub31890</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; csub31890]]></copyright><item><title><![CDATA[正确停止数据泵进程]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270908</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270908</guid><author>csub31890</author><pubDate>Fri, 08 Dec 2017 09:51:01 +0800</pubDate><description><![CDATA[1、查看进程并关掉
ps -ef |grep expdp

2、查看试图dba_datapump_jobs,发现任务还在执行

select job_name,state from dba_datapump_jobs...]]></description><category></category></item><item><title><![CDATA[linux环境ftp搭建]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270909</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270909</guid><author>csub31890</author><pubDate>Thu, 07 Dec 2017 17:05:49 +0800</pubDate><description><![CDATA[1、检查vsftpd软件是否安装
[root@linux01 ~]# rpm -qa vsftpd
[root@linux01 ~]#
2、安装vsftpd
[root@linux01 media]# yum -y i...]]></description><category></category></item><item><title><![CDATA[更换mirror硬盘]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270905</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270905</guid><author>csub31890</author><pubDate>Thu, 07 Dec 2017 14:13:04 +0800</pubDate><description><![CDATA[mirror镜像硬盘更换
大致步骤：解镜像mirror——删除坏掉的硬盘——添加新的硬盘到rootvg——做镜像mirror做同步（一般自己会同步）
一、检查故障点
#lsvg -p rootvg
rootvg:
PV...]]></description><category></category></item><item><title><![CDATA[expdp通过db_link远程导出]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270910</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270910</guid><author>csub31890</author><pubDate>Tue, 05 Dec 2017 20:42:20 +0800</pubDate><description><![CDATA[环境：两台服务器都是linux，数据库版本都是11.2.0.4
node1:192.168.1.128 prod
node2 192.168.1.129 prod2
将节点1的t1用户远程导出到节点2上。
节点1：
[...]]></description><category></category></item><item><title><![CDATA[RAC中lsnrctl和srvctl的区别（监听状态异常）]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270903</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270903</guid><author>csub31890</author><pubDate>Mon, 04 Dec 2017 11:52:34 +0800</pubDate><description><![CDATA[案例：（环境：hp小机，10Grac）今天早上一客户发现连接不上数据库，反馈。
处理过程：
登录服务器发现有一台服务器集群监听处于关闭状态，lsnrctl status发现监听处于卡死状态，无法进行正常的关闭，重启...]]></description><category></category></item><item><title><![CDATA[ora-6000]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270902</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270902</guid><author>csub31890</author><pubDate>Tue, 28 Nov 2017 09:41:35 +0800</pubDate><description><![CDATA[http://www.360doc.com/content/15/0423/14/16250511_465434832.shtml
                                                ...]]></description><category></category></item><item><title><![CDATA[ORA-00845: MEMORY_TARGET not supported on this system]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270907</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270907</guid><author>csub31890</author><pubDate>Tue, 28 Nov 2017 09:25:09 +0800</pubDate><description><![CDATA[SQL&gt; alter system set memory_target=2G scope=spfile ; 


	


	System altered.


	


	SQL&...]]></description><category></category></item><item><title><![CDATA[SSH免密码登录]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270921</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270921</guid><author>csub31890</author><pubDate>Tue, 28 Nov 2017 09:18:29 +0800</pubDate><description><![CDATA[使用密钥文件，两台机器建立信任
这里假设主机A（192.168.100.3）用来获得主机B（192.168.100.4）的文件。
在主机A上执行如下命令来生成配对密钥：
ssh-keygen -t rsa
遇到提示回...]]></description><category></category></item><item><title><![CDATA[定时删除文件脚本]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270904</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270904</guid><author>csub31890</author><pubDate>Mon, 27 Nov 2017 09:24:00 +0800</pubDate><description><![CDATA[@echo off
set SrcDir=G:\log
set DaysAgo=90
forfiles /p %SrcDir% /s /m *.* /d -%DaysAgo% /c "cmd /c del @path"...]]></description><category></category></item><item><title><![CDATA[scp、rsync限速传输]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270899</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270899</guid><author>csub31890</author><pubDate>Thu, 16 Nov 2017 15:56:14 +0800</pubDate><description><![CDATA[rsync限速1M
rsync -avz --bwlimit=1000 /tmp/arch root@192.168.1.129:/tmp/
scp限速1M
scp -l 10000 -r /tmp/arch root@1...]]></description><category></category></item><item><title><![CDATA[window定时删除批处理]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270896</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270896</guid><author>csub31890</author><pubDate>Wed, 15 Nov 2017 10:27:39 +0800</pubDate><description><![CDATA[Windows下bat批处理，自动获取文件的最后修改时间，然后将指定多少天之前的文件删除，需要Windows支持forfiles命令，XP及以上系统都自带forfiles命令。
   删除指定目录下7天前的文件（目录...]]></description><category></category></item><item><title><![CDATA[归档大小日志计算]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270901</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270901</guid><author>csub31890</author><pubDate>Wed, 15 Nov 2017 09:16:24 +0800</pubDate><description><![CDATA[如果一个老库需要开启归档，我们可以通过日志切换频率推算出存放归档日志所需的空间，这样对存储规划有很好的指导意义。

	可以按照如下步骤完成归档日志空间规划预估任务。


	1.查看数据库日志文件的大小


	sy...]]></description><category></category></item><item><title><![CDATA[expdp导出报错：ORA-31626 ORA-31633 ORA-06512 ORA-01658]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270897</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270897</guid><author>csub31890</author><pubDate>Wed, 08 Nov 2017 09:17:42 +0800</pubDate><description><![CDATA[ORA-31626：JOBdoes not exist
ORA-31633:unable to create master table "NYFS.SYS_EXPORT_SCHEMA_49"
ORA-06512:at "S...]]></description><category></category></item><item><title><![CDATA[node1 has a disk HB，but no network HB]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270900</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270900</guid><author>csub31890</author><pubDate>Fri, 03 Nov 2017 16:28:41 +0800</pubDate><description><![CDATA[硬件环境：IBM服务器，IBM存储，心跳线通过交换机连接
软件环境：RAConenode 11.2.0.3
故障描述：客户更换机柜PDU，导致交换机意外掉电，重新拔插后，节点2集群服务出现异常（实例一直在节点1运行），...]]></description><category></category></item><item><title><![CDATA[/dev/shm大小修改]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270895</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270895</guid><author>csub31890</author><pubDate>Mon, 09 Oct 2017 16:48:47 +0800</pubDate><description><![CDATA[修改/etc/fstab的这行： 默认的：
tmpfs /dev/shm tmpfs defaults 0 0
改成：
tmpfs /dev/shm tmpfs defaults,size=10G 0 0
size参数也...]]></description><category></category></item><item><title><![CDATA[ORA-00600，服务器断电导致日志丢失]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270892</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270892</guid><author>csub31890</author><pubDate>Wed, 30 Aug 2017 10:39:30 +0800</pubDate><description><![CDATA[一套跑在Linux机器上的11gR2单实例数据库，由于服务器异常断电导致的故障，遭遇到这个ORA-600的错误

[oracle@os5 ~]$ sqlplus / as sysdba
SQL*Plus: Release ...]]></description><category></category></item><item><title><![CDATA[RAC下新增控制文件]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270891</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270891</guid><author>csub31890</author><pubDate>Wed, 16 Aug 2017 10:23:03 +0800</pubDate><description><![CDATA[一、查看控制文件和spfile文件位置
[root@node1 ~]# su - oracle
[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2....]]></description><category></category></item><item><title><![CDATA[在Linux下安装oracle11g，在安装grid时，密码框中不能输入任何信息]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270889</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270889</guid><author>csub31890</author><pubDate>Wed, 26 Jul 2017 18:02:37 +0800</pubDate><description><![CDATA[1、在Linux下安装oracle11g，在安装grid时，密码框中不能输入任何信息


	


	在当前用户下执行三条命令即可：


	


	xprop  -root  -remove  ...]]></description><category></category></item><item><title><![CDATA[xmanager 连接hp unix]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270894</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270894</guid><author>csub31890</author><pubDate>Tue, 18 Jul 2017 14:25:08 +0800</pubDate><description><![CDATA[xmanager远程步骤
 一、打开xbrowser

 二、点击选项(options)，在XDMCP一栏，在search里面add要远程的ip，点击确定

 三、找到新建成的图标，右键修改属性

四、打开新建立的...]]></description><category></category></item><item><title><![CDATA[VNC Cut & Paste on Solaris 10]]></title><link>https://blog.youkuaiyun.com/csub31890/article/details/100270887</link><guid>https://blog.youkuaiyun.com/csub31890/article/details/100270887</guid><author>csub31890</author><pubDate>Tue, 04 Jul 2017 12:53:04 +0800</pubDate><description><![CDATA[$ vncconfig
No VNC extension on display :1.0


When I hit the problem again, I found my way back to one of my ...]]></description><category></category></item></channel></rss>