<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuiquan3171的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuiquan3171</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuiquan3171]]></copyright><item><title><![CDATA[free -m 解释]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403194</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403194</guid><author>cuiquan3171</author><pubDate>Thu, 28 Jul 2011 09:55:40 +0800</pubDate><description><![CDATA[参考http://bbs.chinaunix.net/thread-2208066-1-1.html[root@Linux /tmp]# free             total       used       free ...]]></description><category></category></item><item><title><![CDATA[ORA-03113，windows修改参数后无法启动]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403187</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403187</guid><author>cuiquan3171</author><pubDate>Tue, 19 Jul 2011 17:20:34 +0800</pubDate><description><![CDATA[ORA-03113，windows修改参数后无法启动起因：alter system set sga_max_size=10240M;重启报错，超过最大内存，无法启动修改database目录下的initorcl.ora，添加sga...]]></description><category></category></item><item><title><![CDATA[ORA-00904]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403189</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403189</guid><author>cuiquan3171</author><pubDate>Tue, 19 Jul 2011 09:02:33 +0800</pubDate><description><![CDATA[公司客户DB数据库查询报错select * from t where t.pre客户='22';ERROR 位于第 1 行:ORA-00904: "ID": 无效的标识符方案:输入有效的列名。一个有效的列名必须是以字母开头，小于...]]></description><category></category></item><item><title><![CDATA[解决win2003 SQL SERVER 64bit 在SQL server management studio里使用导入导出向导报错]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403184</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403184</guid><author>cuiquan3171</author><pubDate>Wed, 13 Jul 2011 11:01:33 +0800</pubDate><description><![CDATA[在SQL SERVER 2008端使用Management studio里的导入功能（右键--》任务--》导入数据）将ORACLE的数据导入时报错如下：===================================出现一...]]></description><category></category></item><item><title><![CDATA[冷备全库异地恢复]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403191</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403191</guid><author>cuiquan3171</author><pubDate>Sat, 02 Jul 2011 11:50:48 +0800</pubDate><description><![CDATA[源服务器：1、停库2、备份数据文件、控制文件、日志文件、参数文件、密码文件目标服务器：1.创建数据文件、控制文件、日志文件所在目录2.创建bdump,cdump,udump目录3.将备份的数据文件、控制文件、日志文件复制...]]></description><category></category></item><item><title><![CDATA[.net 连接 oracle 9201 提示：System.Data.OracleClient requires Oracle client software version 8.1.7 or gre...]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403188</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403188</guid><author>cuiquan3171</author><pubDate>Sat, 02 Jul 2011 11:42:38 +0800</pubDate><description><![CDATA[近日迁移一个库到windows 2003下，虽然通过sqlplus连接成功，但在IIS应用里死活连不上，报错：System.Data.OracleClient requires Oracle client softwar...]]></description><category></category></item><item><title><![CDATA[ORA-01031 本地账户adminstrator使用sys无法登陆ORACLE]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403190</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403190</guid><author>cuiquan3171</author><pubDate>Thu, 23 Jun 2011 15:22:04 +0800</pubDate><description><![CDATA[事因：业务部门让帮忙解决操作系统反应缓慢问题，经查看是由于ORACLE占用内存过多造成，想登陆SYS查看，但提示ORA-01031分析：1、查看administrator用户是否在ora_dba组里；2、查看sqlnet...]]></description><category></category></item><item><title><![CDATA[ORA-19809，ORA-00312，默认的归档路径（在闪回区）的2g大小限制造成错误]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403181</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403181</guid><author>cuiquan3171</author><pubDate>Mon, 20 Jun 2011 17:25:13 +0800</pubDate><description><![CDATA[事因：将公司数据导入新库做好备份策略并启用归档后，，第三天数据库报错：Archive process error: ORA-16038: log 1 sequence# 317 cannot be archivedORA...]]></description><category></category></item><item><title><![CDATA[Oracle RMAN show,list,crosscheck,delete命令整理]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403183</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403183</guid><author>cuiquan3171</author><pubDate>Thu, 16 Jun 2011 09:47:27 +0800</pubDate><description><![CDATA[内容转自网络 
。。。1、SHOW命令：   显示rman配置： RMAN&gt; show 
all;2、REPORT命令：   2.1、RMAN&gt; report schema        
    ...]]></description><category></category></item><item><title><![CDATA[逻辑备exp及保留7天备份脚本]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403178</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403178</guid><author>cuiquan3171</author><pubDate>Thu, 16 Jun 2011 09:38:34 +0800</pubDate><description><![CDATA[迁移库后，做了个简单的逻辑备脚本，保留7天备份source ~/.bash_profileexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_SID=orclex...]]></description><category></category></item><item><title><![CDATA[Oracle 用户自动被锁]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403182</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403182</guid><author>cuiquan3171</author><pubDate>Thu, 16 Jun 2011 09:30:03 +0800</pubDate><description><![CDATA[事由：昨日迁移一库后，开发同事说有用户被自动锁定，总是人为去解锁也不是个办法；解决方法：初步分析应该是由于库还未加入DMZ区，防火墙未开启，导致有人恶意错误密码登陆10次+，导致用户被锁。查看profileselect ...]]></description><category></category></item><item><title><![CDATA[dmp文件字符集受客户端session字符集环境变量NLS_LANG影响]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403180</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403180</guid><author>cuiquan3171</author><pubDate>Tue, 07 Jun 2011 16:29:03 +0800</pubDate><description><![CDATA[今天迁移公司的客户关系数据库，正好碰到了字符集的问题，做了个实验验证dmp文件的字符集受什么影响，实验如下：本机系统windows 7 64bit修改客户端session字符集环境变量NLS_LANGset NLS_LA...]]></description><category></category></item><item><title><![CDATA[dmp导入，字符集问题的处理]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403186</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403186</guid><author>cuiquan3171</author><pubDate>Tue, 07 Jun 2011 15:31:20 +0800</pubDate><description><![CDATA[dmp文件字符集与当前oracle server端字符集不同，导入失败。处理方式如下：一.修改dmp文件字符集与Oracle Server字符集相同1.查看当前Oracle server端字符集select useren...]]></description><category></category></item><item><title><![CDATA[表空间相关]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403176</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403176</guid><author>cuiquan3171</author><pubDate>Tue, 31 May 2011 14:57:29 +0800</pubDate><description><![CDATA[create tablespace demo2 datafile '/home/oracle/demo2.dbf' size 20m;//没有指定字段定义的情况下，不会自动扩展数据文件，表空间为本地管理，段空间为自动管理，区为自...]]></description><category></category></item><item><title><![CDATA[SQL SERVER 2005开始镜像时 报错]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403175</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403175</guid><author>cuiquan3171</author><pubDate>Fri, 20 May 2011 17:53:10 +0800</pubDate><description><![CDATA[在主库实例上开始镜像时可能会遇到此错误，错误信息如下：
镜像数据库 "dbName" 包含的事务日志数据不足，无法保留主体数据库的日志备份链。如果没有从主体数据库进行日志备份或者没有在镜像数据库上还原日志备份，则可能会出现这种...]]></description><category></category></item><item><title><![CDATA[SQL SERVER 2005无法远程连接域里的其他实例]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403179</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403179</guid><author>cuiquan3171</author><pubDate>Fri, 20 May 2011 17:14:44 +0800</pubDate><description><![CDATA[需要先在各服务器的SQL SERVER配置里开起TCP/IP，设置方法

如下：在开始菜单里选择Microsoft SQL SERVER 2005--&amp;gt配置工具--&amp;gtSQL SERVER
Confi...]]></description><category></category></item><item><title><![CDATA[SQL SERVER2005备份还原出错]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403177</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403177</guid><author>cuiquan3171</author><pubDate>Fri, 20 May 2011 14:58:52 +0800</pubDate><description><![CDATA[又是一次小改动造成的低级错误！！！！！！还是上一篇文章提到的，干微软的活，除了仔细认真，没别的了。。具体问题如下：我使用主库的备份文件到备库进行还原时，提示：System.Data.SqlClient.SqlError: 媒体集...]]></description><category></category></item><item><title><![CDATA[SQL Server 2005 无法登陆问题(修改域账号密码引发)]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403172</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403172</guid><author>cuiquan3171</author><pubDate>Fri, 20 May 2011 12:02:05 +0800</pubDate><description><![CDATA[今天，由于管理员提示我，我的域账号密码过于简单，出于安全考虑早上我做了修改。。快到中午时，我开始处理昨日剩下的SQL Server镜像配置，，结果怎么配置怎么出错（完全忘记了使用了域账号验证），无奈之下在vCenter里把虚拟机...]]></description><category></category></item><item><title><![CDATA[SQL Server 2005 镜像配置（基于VM sphere企业级虚拟设备和WINDOWS域环境）]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403173</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403173</guid><author>cuiquan3171</author><pubDate>Thu, 19 May 2011 19:06:56 +0800</pubDate><description><![CDATA[最近需要写一份SQL Server的镜像配置报告，由于之前没怎么接触过SQL Server的高可用方面的东西，所以这次算第一次实操。在VM sphere上虚拟了三台WIN2003后即开始。一开始直接在第一台虚拟设备上按照文档开始...]]></description><category></category></item><item><title><![CDATA[sys登陆提示权限不足]]></title><link>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403169</link><guid>https://blog.youkuaiyun.com/cuiquan3171/article/details/100403169</guid><author>cuiquan3171</author><pubDate>Fri, 06 May 2011 11:45:24 +0800</pubDate><description><![CDATA[同事在使用SYS用户登陆数据库时，提示权限不足目前所接触到的，一般有两种情况：一种是没有加as sysdbasqlplus sys/oracle 改为 sqlplus sys/oracle as sysdba另一种是密码文件出现...]]></description><category></category></item></channel></rss>