<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lucky-laoA]]></title><description><![CDATA[每天进步一点点......]]></description><link>https://blog.youkuaiyun.com/linux_wang130</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; linux_wang130]]></copyright><item><title><![CDATA[ORA-39002/ORA-29070/ORA-29283/ORA-06512/ORA-29283错误]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/40302521</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/40302521</guid><author>linux_wang130</author><pubDate>Mon, 20 Oct 2014 16:41:59 +0800</pubDate><description><![CDATA[C:\Documents and Settings\Administrator>expdp bizdata/bizdata@bzdata schemas=biz
data directory=dd dumpfile=test.dmp

Export: Release 10.2.0.1.0 - Production on 星期四, 30 7月, 2009 16:37:12

Copyrig]]></description><category></category></item><item><title><![CDATA[数据库ORA-01196(ORA-10458/ORA-01110)错误解决方法]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/38870363</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/38870363</guid><author>linux_wang130</author><pubDate>Wed, 27 Aug 2014 14:42:24 +0800</pubDate><description><![CDATA[赞比亚的一个项目，主要做主从数据库同步]]></description><category></category></item><item><title><![CDATA[ORA-01659: unable to allocate MINEXTENTS beyond 10]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/18794783</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/18794783</guid><author>linux_wang130</author><pubDate>Sun, 26 Jan 2014 13:49:12 +0800</pubDate><description><![CDATA[cmd>impdp导入数据的时候的错误提示是:


;;; 
Import: Release 11.2.0.3.0 - Production on Sat Jan 25 21:07:22 2014


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connect]]></description><category></category></item><item><title><![CDATA[ORA-20001错误]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/17027751</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/17027751</guid><author>linux_wang130</author><pubDate>Fri, 29 Nov 2013 17:29:12 +0800</pubDate><description><![CDATA[APPLIES TO:
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 16-Feb-201]]></description><category></category></item><item><title><![CDATA[S000常用的SQL语句]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/16888513</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/16888513</guid><author>linux_wang130</author><pubDate>Fri, 22 Nov 2013 17:42:20 +0800</pubDate><description><![CDATA[S001A:
使用advice分析buffer cache size大小：
SELECT size_for_estimate "Cache Size (MB)",size_factor,buffers_for_estimate "Buffers",
estd_physical_read_factor est_read_factor,
estd_physical_reads estd_phy]]></description><category></category></item><item><title><![CDATA[S001buffer cache的调整]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/16888361</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/16888361</guid><author>linux_wang130</author><pubDate>Fri, 22 Nov 2013 17:38:22 +0800</pubDate><description><![CDATA[1、Oracle Buffer Cache大小调整：
在OLTP系统中，对于DB_CACHE_SIZE的设置，推荐配置是：
DB_CACHE_SIZE = SGA_MAX_SIZE/2～ SGA_MAX_SIZE*2/3
使用advice来确认buffer cache的大小


S001A:
SELECT size_for_estimate "Cache Size (MB)",siz]]></description><category></category></item><item><title><![CDATA[oracle自动内存共享管理测试。修改 oracle 11g SGA_MAX_SIZE。]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/13016219</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/13016219</guid><author>linux_wang130</author><pubDate>Fri, 25 Oct 2013 09:56:40 +0800</pubDate><description><![CDATA[目的，使用oracle 自动内存共享管理 基本都是修改过程。如需整理，请留言
 
SQL>show parameters target;
NAME                                 TYPE        VALUE
------------------------------------ ----------- -------
archive_lag_ta]]></description><category></category></item><item><title><![CDATA[日志切换 redo log 频繁]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/13002865</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/13002865</guid><author>linux_wang130</author><pubDate>Thu, 24 Oct 2013 18:00:27 +0800</pubDate><description><![CDATA[2011-09-02 11:37:24|  分类： oracle学习 |  标签：redo日志  切换频繁  |字号 订阅







最近发现日志服务器切换redo log太频繁了,大概一分钟一次，如此过于
频繁也不是个办法，
于是加大日志大小和增加日志组的数量来解决。

另外除了日志切换频繁以外，还有Thread 1 cannot allocate new log、]]></description><category></category></item><item><title><![CDATA[sh脚本异常：/bin/sh^M:bad interpreter: No such file or directory]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12912581</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12912581</guid><author>linux_wang130</author><pubDate>Mon, 21 Oct 2013 16:25:42 +0800</pubDate><description><![CDATA[sh脚本异常：/bin/sh^M:bad interpreter: No such file or directory




在Linux中执行.sh脚本，异常/bin/sh^M: bad interpreter: No such file or directory。 
分析：这是不同系统编码格式引起的：在windows系统中编辑的.sh文件可能有不可见字符，所以在Linux系统下执]]></description><category></category></item><item><title><![CDATA[ORA-600错误-进程丢失]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12838259</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12838259</guid><author>linux_wang130</author><pubDate>Thu, 17 Oct 2013 15:44:58 +0800</pubDate><description><![CDATA[问题描述：
oracle的alert日志信息如下：
Thu Oct 17 10:17:54 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1]]></description><category></category></item><item><title><![CDATA[ORA-00020错误]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12833239</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12833239</guid><author>linux_wang130</author><pubDate>Thu, 17 Oct 2013 10:33:26 +0800</pubDate><description><![CDATA[ORA-00020错误
问题描述：测试组的Oracle数据库老是挂掉，于是乎检查了一下oracle的alert日志，具体错误信息如下：
Tue Oct 15 18:55:12 2013
ORA-00020: maximum number of processes 150 exceeded
ORA-20 errors will not be written to the alert log]]></description><category></category></item><item><title><![CDATA[tomcat远程管理系统雏形]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12655565</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12655565</guid><author>linux_wang130</author><pubDate>Sat, 12 Oct 2013 18:00:37 +0800</pubDate><description><![CDATA[一、Vsftpd搭建
1、软件安装
yum –y install  vsftpd*
2、配置服务
vim /etc/vsftpd/vsftpd.conf     




chroot_local_user=YES
         anonymous_enable=NO #非匿名访问方式
         user_deny=YES #开启白名单
         use]]></description><category></category></item><item><title><![CDATA[ORA-00257 archiver error. 错误的处理方法]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12655353</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12655353</guid><author>linux_wang130</author><pubDate>Sat, 12 Oct 2013 17:43:57 +0800</pubDate><description><![CDATA[archive log 日志已满
ORA-00257: archiver error. Connect internal only, until freed 错误的处理方法
1. 用sys用户登录
  sqlplus sys/pass@tt as sysdba
2. 看看archiv log所在位置
SQL> show parameter log_archive_dest;
NAME]]></description><category></category></item><item><title><![CDATA[java  jdbc连接oracle的三种方法]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12168063</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12168063</guid><author>linux_wang130</author><pubDate>Sun, 29 Sep 2013 16:26:41 +0800</pubDate><description><![CDATA[一、方法



Oracle JDBC 连接ServiceName
jdbc:oracle:thin:@//:/
例：jdbc:oracle:thin@//10.1.112.110:1521/Health
注：@后面有//。这种格式主要针对集群，每个节点的SID不同，但是SERVICE_NAME可以包含所有节点。


Oracle JDBC 连接 ServiceID
jdbc]]></description><category></category></item><item><title><![CDATA[mysql数据库检查、数据库表导出、数据库表修复]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12165405</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12165405</guid><author>linux_wang130</author><pubDate>Sun, 29 Sep 2013 15:39:11 +0800</pubDate><description><![CDATA[问题描述：在导mysql数据库的时候，遇到了一个错误，无法导出，于是就写了如下脚本将数据库里面的正常的表导出到指定的文件里面，当文件导完之后，就会提示坏表信息，在使用命令进行修复，数据库恢复正常。
#!/bin/bash
mysqldump=/opt/lampp/bin/mysqldump
mysqldb=bbs_fmzh
username=root
password=rootroot]]></description><category></category></item><item><title><![CDATA[mysql书库表检查]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12165299</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12165299</guid><author>linux_wang130</author><pubDate>Sun, 29 Sep 2013 15:31:13 +0800</pubDate><description><![CDATA[#!/bin/bash
#此脚本的主要用途是检测mysql服务器上所有的db或者单独db中的坏表
#变量说明 pass mysql账户口令 name mysql账号名称 data_path mysql目录路径 directory_list 目录列表 file_list文件列表 db_name 数据库名称 repair_count单库中待修复的表总数
#变量说明 repair_count_al]]></description><category></category></item><item><title><![CDATA[检查mysql是否存在坏表]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12160019</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12160019</guid><author>linux_wang130</author><pubDate>Sun, 29 Sep 2013 13:06:58 +0800</pubDate><description><![CDATA[1. [图片] mysql_1.png    



2. [代码][Shell/批处理]代码     







01

#!/bin/bash









02

#此脚本的主要用途是检测mysql服务器上所有的db或者单独db中的坏表









03

#变量说明
 pass mysql账户口令]]></description><category></category></item><item><title><![CDATA[linux route命令详解]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12105561</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12105561</guid><author>linux_wang130</author><pubDate>Fri, 27 Sep 2013 17:41:12 +0800</pubDate><description><![CDATA[为了让设备能访问另一个子网，需要在设备里增加路由到子网络，下面是一些资料。基本操作如下：

一般来说，都是为了能访问别的子网才设置路由的，比如说，你的主机处于192.168.10.0/24，而你想访问192.168.20.0/24网的主机，当然你知道一个网关IP，例如192.168.10.1（必须和你主机处于同一子网），那么，你可以这样配置路由。

添加路由

route add -n]]></description><category></category></item><item><title><![CDATA[expdp:ORA-31634: job already exists]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/12104885</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/12104885</guid><author>linux_wang130</author><pubDate>Fri, 27 Sep 2013 17:29:35 +0800</pubDate><description><![CDATA[测试通过：expdp:ORA-31634: job already exists




问题描述：
使用数据泵进行全备,由于user的表空间不足导致备份失败,添加user表空间,清理空间后再次进行备份报如下错误:
 
With the Partitioning, OLAP and Data Mining options
ORA-31634: job already exists]]></description><category></category></item><item><title><![CDATA[shell中的for循环]]></title><link>https://blog.youkuaiyun.com/linux_wang130/article/details/11966593</link><guid>https://blog.youkuaiyun.com/linux_wang130/article/details/11966593</guid><author>linux_wang130</author><pubDate>Tue, 24 Sep 2013 10:58:12 +0800</pubDate><description><![CDATA[关于shell中的for循环用法很多，一直想总结一下，今天网上看到上一篇关于for循环用法的总
结，感觉很全面，所以就转过来研究研究，嘿嘿…
1、 for((i=1;i
2、在shell中常用的是 for i in $(seq 10)
3、for i in `ls`
4、for i in ${arr[@]}
5、for i in $* ; do
6、for File in /proc]]></description><category></category></item></channel></rss>