<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuishilong1820的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuishilong1820</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuishilong1820]]></copyright><item><title><![CDATA[某数据库系统升级流水账记录]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482577</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482577</guid><author>cuishilong1820</author><pubDate>Sat, 08 Dec 2012 07:11:42 +0800</pubDate><description><![CDATA[RAC环境迁移升级，9.2.0.8升到11g

12月4日下午3点到达客户现场并了解情况
之前只是告知9i的库升级到11g，客户也不清楚具体版本，好像是9206。当时去之前已经想好最恶劣的从用10g软件挂载11gASM磁...]]></description><category></category></item><item><title><![CDATA[dest_2参数与using current controlfile及standby log相互关系测试]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482607</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482607</guid><author>cuishilong1820</author><pubDate>Sat, 27 Oct 2012 23:26:44 +0800</pubDate><description><![CDATA[环境：oracle11.2.0.3/Linux5.5
结论：
当dest_参数为lgwr时，需要配置standby redolog，否则会报错；为arch时，则不需要配置。
当恢复命令发起为alter database r...]]></description><category></category></item><item><title><![CDATA[用户连接数据库:ORA-01033:正在初始化或者关闭//ora-600 [2252]]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482581</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482581</guid><author>cuishilong1820</author><pubDate>Thu, 21 Jun 2012 10:59:26 +0800</pubDate><description><![CDATA[环境：windows 2003，ORACLE 10.2.0.1现象：SQL*Plus无法连接，显示以下错误： ORA-01033 : ORACLE initialization or shutdown in progress s...]]></description><category></category></item><item><title><![CDATA[数据库lock锁阻塞查询测试报告]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482573</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482573</guid><author>cuishilong1820</author><pubDate>Wed, 23 May 2012 14:09:26 +0800</pubDate><description><![CDATA[数据库lock锁阻塞查询测试报告

一、模拟产生锁阻塞的情况
会话一：yyj普通用户登录，创建表t，insert数据，提交，之后update该行，但不进行提交。
SQL&gt; create table t (a va...]]></description><category></category></item><item><title><![CDATA[设置oracle数据库IP访问限制(IP白名单黑名单)]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482570</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482570</guid><author>cuishilong1820</author><pubDate>Fri, 18 May 2012 08:44:13 +0800</pubDate><description><![CDATA[可以通过修改sqlnet.ora文件来限制某些IP地址的访问，修改完成后，可能需重启监听生效。(可以lsnrctl reload)如果$ORACLE_HOME/network/admin/目录下没有sqlnet.ora文件，可以...]]></description><category></category></item><item><title><![CDATA[tnsping命令对tnsname.ora文件的使用]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482583</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482583</guid><author>cuishilong1820</author><pubDate>Tue, 10 Apr 2012 16:00:41 +0800</pubDate><description><![CDATA[先写结论，tnsping命令只识别到tnsname.ora文件中的ip和端口号，而对之后的service_name或者sid不进行识别，因此tnsping能ping通并不意味着sqlplus **/**@tnsname一定能登录...]]></description><category></category></item><item><title><![CDATA[Linux LVM工具(VG和LV)]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482576</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482576</guid><author>cuishilong1820</author><pubDate>Wed, 08 Feb 2012 09:46:22 +0800</pubDate><description><![CDATA[一、 安装LVM 首先确定系统中是否安装了lvm工具： [root@www root]# rpm –qa|grep lvm lvm-1.0.3-4 如果命令结果输入类似于上例，那么说明系统已经安装了LVM管理工具；如果命...]]></description><category></category></item><item><title><![CDATA[oracle中Alter system 命令的总结]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482575</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482575</guid><author>cuishilong1820</author><pubDate>Tue, 17 Jan 2012 11:24:57 +0800</pubDate><description><![CDATA[Alter system archive log [start|stop|all|...]
alter system archive log all;
alter system archive log next;
alte...]]></description><category></category></item><item><title><![CDATA[ORACLE import工具参数]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482565</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482565</guid><author>cuishilong1820</author><pubDate>Wed, 21 Dec 2011 09:31:19 +0800</pubDate><description><![CDATA[import工具

windows中文界面：
C:\Documents and Settings\yeyj&gt;imp -help
Import: Release 10.2.0.1.0 - Production on...]]></description><category></category></item><item><title><![CDATA[ORACLE export 工具参数]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482574</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482574</guid><author>cuishilong1820</author><pubDate>Tue, 20 Dec 2011 10:57:46 +0800</pubDate><description><![CDATA[export工具：windows中文界面：C:\Documents and Settings\yeyj&gt;exp -helpExport: Release 10.2.0.1.0 - Production on 星期一 12月...]]></description><category></category></item><item><title><![CDATA[9i升级patchset后dbca建库报错bug]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482572</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482572</guid><author>cuishilong1820</author><pubDate>Fri, 16 Dec 2011 14:41:56 +0800</pubDate><description><![CDATA[环境操作系统：linux RHEL4.7数据库软件版本：9.2.0.8
dbca建库，选择自定义数据库，在创建数据字典时一直报错(如图)，$ORACLE_BASE/admin/{ORACLE_SID}/create/Creat...]]></description><category></category></item><item><title><![CDATA[global_names与dblink]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482571</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482571</guid><author>cuishilong1820</author><pubDate>Mon, 05 Dec 2011 14:18:07 +0800</pubDate><description><![CDATA[global_names:默认为false改为true时，主要影响dblink，需要名字与目标数据库global_name相同，否则本机数据库通过dblink连接带目标数据库失败在global_names=true的情况下如果当...]]></description><category></category></item><item><title><![CDATA[关于10g和11gR2的dba_users视图password列的区别以及判断用户名密码相同的方法]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482563</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482563</guid><author>cuishilong1820</author><pubDate>Tue, 22 Nov 2011 19:56:10 +0800</pubDate><description><![CDATA[ORACLE数据库用户名密码被加密过我们看不懂，因此很多时候我们在检查测试用户名和密码相同的情况会采用先从dba_users视图取用户password值
SQL&gt; select username,password fro...]]></description><category></category></item><item><title><![CDATA[11gR2关于exp问题]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482569</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482569</guid><author>cuishilong1820</author><pubDate>Tue, 22 Nov 2011 17:55:36 +0800</pubDate><description><![CDATA[数据库版本：11.2.0.2客户端版本：11.2.0.1
做个测试，新建一张test1，插入数据，另外再建1张空表test2
exp用户导出报错. . 正在导出表 test1导出了5 行EXP-00008: 遇到 ORAC...]]></description><category></category></item><item><title><![CDATA[直接使用FTP在原有DG的情况下克隆或迁移DG]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482562</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482562</guid><author>cuishilong1820</author><pubDate>Sat, 05 Nov 2011 14:08:12 +0800</pubDate><description><![CDATA[直接使用FTP在原有DG的情况下克隆或迁移DG
本章讲的是利用ftp直接传输DG进行DG的克隆或迁移在备库DG数据文件放在文件系统的情况下，ftp来直接传输可以简化重新搭建DG的过程，尤其是当主库使用ASM存储的情况。如果是克...]]></description><category></category></item><item><title><![CDATA[使用rman duplicate搭建data guard]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482567</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482567</guid><author>cuishilong1820</author><pubDate>Sat, 05 Nov 2011 14:07:22 +0800</pubDate><description><![CDATA[这里主要讲的是利用rman duplicate来进行备机数据的恢复的过程。rman进行备份恢复往往常用于ASM磁盘组和RAC环境。事实上，感觉rman duplicate和rman 备份出来再手工恢复相比无非就是少了步set n...]]></description><category></category></item><item><title><![CDATA[RAC环境的DataGuard配置]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482561</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482561</guid><author>cuishilong1820</author><pubDate>Tue, 18 Oct 2011 14:05:22 +0800</pubDate><description><![CDATA[搭建DG要求主备库数据库版本一致RAC+DG / Linux 5.7(64-bit) /数据库版本：11.2.0.2
首先主库RMAN进行全库备份，FTP到备机$rman target /RMAN&gt; backup for...]]></description><category></category></item><item><title><![CDATA[向CRS添加资源]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482559</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482559</guid><author>cuishilong1820</author><pubDate>Thu, 08 Sep 2011 14:04:32 +0800</pubDate><description><![CDATA[由于需要重建crs，其余的没有任何修改，CRS装完后当前的资源为[root@node1 node1]# crs_stat -tName Type Target State Host————————————————————ora....]]></description><category></category></item><item><title><![CDATA[使用FTP访问ASM磁盘组]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482564</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482564</guid><author>cuishilong1820</author><pubDate>Tue, 30 Aug 2011 14:03:07 +0800</pubDate><description><![CDATA[首先需要数据库已经安装XML Database (XDB) 组件可以在dbca图形界面里configure database，也可根据metalink手动刷组件
1) As root check that ftp servic...]]></description><category></category></item><item><title><![CDATA[ARC0: Media recovery disabled]]></title><link>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482560</link><guid>https://blog.youkuaiyun.com/cuishilong1820/article/details/100482560</guid><author>cuishilong1820</author><pubDate>Fri, 19 Aug 2011 14:00:11 +0800</pubDate><description><![CDATA[查看alert日志发现报大量
ARC0: Media recovery disabled
每分钟都会报1条这样的信息，尽管对数据库本身不会造成太大影响，但告警日志会随着时间的变化越来越大。查其原因：当前数据库为非归档状态，...]]></description><category></category></item></channel></rss>