<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[about database article]]></title><description><![CDATA[自己的一些东西]]></description><link>https://blog.youkuaiyun.com/aaaaaaaa2000</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; aaaaaaaa2000]]></copyright><item><title><![CDATA[oracle 一致读2]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/41693113</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/41693113</guid><author>aaaaaaaa2000</author><pubDate>Wed, 03 Dec 2014 10:06:38 +0800</pubDate><description><![CDATA[在上一篇文章中说的_db_block_max_cr_dba是对一个一个块中的同一行进行更新的时候最多生成的cr块，下面主要说一下对于同一块中的不同行同时更新时会产生多个cr块
SQL>  drop table clm.t1 purge;

Table dropped.

SQL> create table clm.t1    (c1 int, c2 char(700));

Table crea]]></description><category></category></item><item><title><![CDATA[oracle 一致读-1]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/41692515</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/41692515</guid><author>aaaaaaaa2000</author><pubDate>Wed, 03 Dec 2014 09:51:50 +0800</pubDate><description><![CDATA[这篇文章中主要演示oracle是如何创建一致读的当一个用户查询数据的时候，他想要查询的数据是跟他查询时候的scn有关的如果他要查询的数据不在buffer里	数据从磁盘读取，状态是xcur如果读取数据已经在buffer中存在一个或者多个clone	则晚于提交查询时间的那个clone块被选中，并应用undo信息来形成一致读，此时状态是cr如果读取的数据在buffer中并且已经被修改没有clone	那么]]></description><category></category></item><item><title><![CDATA[固定执行计划]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/9086111</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/9086111</guid><author>aaaaaaaa2000</author><pubDate>Thu, 13 Jun 2013 15:25:58 +0800</pubDate><description><![CDATA[在遭遇执行计划不稳定或者执行计划错误的情况下，通过baseline来固定SQL执行计划以确保执行计划稳定性、提高性能。baseline是oracle 11G提供的稳固sql执行计划的功能，是spm功能的一部分。
步骤如下:

SQL> set linesize 1000
SQL> col index_name for a40
SQL> col COLUMN_NAME for a20
SQL>]]></description><category></category></item><item><title><![CDATA[hadoop端口被占用]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7641340</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7641340</guid><author>aaaaaaaa2000</author><pubDate>Thu, 07 Jun 2012 11:49:21 +0800</pubDate><description><![CDATA[在启动hadoop的时候查看一个datanode没有起来，查看log发现


ERROR org.apache.hadoop.hdfs.server.datanode.DataNode: java.net.BindException: Problem binding to /0.0.0.0:50010 : Address already in use
50010端口是datanode的监听]]></description><category></category></item><item><title><![CDATA[Incompatible namespaceIDs]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7641310</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7641310</guid><author>aaaaaaaa2000</author><pubDate>Thu, 07 Jun 2012 11:33:02 +0800</pubDate><description><![CDATA[在启动hadoop的时候使用jps查看datanode节点上的服务并没有起来，此时去查看日志发现：
2012-06-07 09:41:37,812 INFO org.apache.hadoop.metrics2.impl.MetricsConfig: loaded properties from hadoop-metrics2.properties
2012-06-07 09:41:37,85]]></description><category></category></item><item><title><![CDATA[oracle11g 密码管理问题]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7620649</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7620649</guid><author>aaaaaaaa2000</author><pubDate>Thu, 31 May 2012 17:21:00 +0800</pubDate><description><![CDATA[oracle11g之后用户的密码已经不存储在dba_users中了
SQL> select *from v$version where rownum




BANNER
----------------------------------------------------------------------------------------------------
Oracl]]></description><category></category></item><item><title><![CDATA[oracle11 密码管理问题]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7620638</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7620638</guid><author>aaaaaaaa2000</author><pubDate>Thu, 31 May 2012 17:19:42 +0800</pubDate><description><![CDATA[SQL> create table t as select * from dba_objects;


Table created.


SQL> desc dba_segments;
 Name                                      Null?    Type
 -----------------------------------------]]></description><category></category></item><item><title><![CDATA[如何确定所打Patch是否需要停机]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7616820</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7616820</guid><author>aaaaaaaa2000</author><pubDate>Wed, 30 May 2012 16:29:10 +0800</pubDate><description><![CDATA[http://www.oracledatabase12g.com/archives/%E5%A6%82%E4%BD%95%E7%A1%AE%E5%AE%9A%E6%89%80%E6%89%93patch%E6%98%AF%E5%90%A6%E9%9C%80%E8%A6%81%E5%81%9C%E6%9C%BA.html

Oracle在11g中提出了online patching(也可以叫做h]]></description><category></category></item><item><title><![CDATA[oracle  patch conflict检查]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7616744</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7616744</guid><author>aaaaaaaa2000</author><pubDate>Wed, 30 May 2012 16:17:24 +0800</pubDate><description><![CDATA[$ opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir 

In this case the command

$ opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir $ORACLE_HOME/patches

Run the following]]></description><category></category></item><item><title><![CDATA[ORACLE PSU  AND OPATTCH UPGRADE]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7616541</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7616541</guid><author>aaaaaaaa2000</author><pubDate>Wed, 30 May 2012 15:36:37 +0800</pubDate><description><![CDATA[收到邮件说要打一下这个psu的补丁，所以就找了一个11.2.0.3的database做了一下，下面是步骤：


Database 11.2.0.3.2 PSU Patch 13696216


1、download  Patch 13696216
2、安装：
其实安装步骤在自许文件中都有，这里主要要说明的就是如何升级optch
[oracle@oracle11g-std 1369]]></description><category></category></item><item><title><![CDATA[imp时发生ora-01659的错误处理]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7613736</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7613736</guid><author>aaaaaaaa2000</author><pubDate>Tue, 29 May 2012 18:09:01 +0800</pubDate><description><![CDATA[IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace PSTATLOG_DATA_TB16
看到错误提示应该是没有办法自动扩展，将数据文件变为自动扩展之后问题解决
alter database datafile '/home/ora11g]]></description><category></category></item><item><title><![CDATA[Opatch打补丁]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7613672</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7613672</guid><author>aaaaaaaa2000</author><pubDate>Tue, 29 May 2012 18:02:54 +0800</pubDate><description><![CDATA[1、下载了oracle的一个cpu的补丁，想打一下这个补丁
cpu的自许文件中有安装的步骤：





3.2.1 Patch Installation Instructions
Follow these steps:


If you are using a Data Guard Physical Standby database, you must install thi]]></description><category></category></item><item><title><![CDATA[RMAN-06214: Datafile Copy]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7609224</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7609224</guid><author>aaaaaaaa2000</author><pubDate>Mon, 28 May 2012 14:45:10 +0800</pubDate><description><![CDATA[在使用rman备份的时候最后出现一个这样的错误：
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: Lis]]></description><category></category></item><item><title><![CDATA[ora-20242/rman-20242]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7609092</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7609092</guid><author>aaaaaaaa2000</author><pubDate>Mon, 28 May 2012 14:20:54 +0800</pubDate><description><![CDATA[[root@newadm ~]# more /home1/oracle/backup/sh/rman_backup.sh 
. $HOME/.bash_profile
export workdate=`date +"%Y%m%d"`
export begindate=`date +"%Y%m%d-%T"`


rman target  /
run{
  ALLOCATE CHANN]]></description><category></category></item><item><title><![CDATA[Linux下fstab参数配置详解]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7608725</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7608725</guid><author>aaaaaaaa2000</author><pubDate>Mon, 28 May 2012 11:55:54 +0800</pubDate><description><![CDATA[http://hi.baidu.com/duangonghua/blog/item/6bb3fb8fd212c9f3503d92dd.html


一、文件：/etc/fstab
二、示例：




fs_spec
fs_file
fs_type
fs_options
fs_dump
fs_pass


LABEL=/boot
/boot
ext3
defa]]></description><category></category></item><item><title><![CDATA[ORA-19625 ORA-27037]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7608623</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7608623</guid><author>aaaaaaaa2000</author><pubDate>Mon, 28 May 2012 11:54:37 +0800</pubDate><description><![CDATA[在进行rman备份的时候报ORA-19625 ORA-27037 这个错误，原因就是在os上直接删除了归档日志，而控制文件中还是有这些归档的信息
此时需要同步二者的状态


crosscheck archivelog all
用RMAN的备份中（Veritas等备份软件由于归档日志的异常导致归档日志备份失败）是经常碰到的，解决方法也是非常解单，就是执行2条RMAN的命令：
1. 进入r]]></description><category></category></item><item><title><![CDATA[ORA-03113 ORA-24324 ORA-01041]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7598467</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7598467</guid><author>aaaaaaaa2000</author><pubDate>Thu, 24 May 2012 15:18:22 +0800</pubDate><description><![CDATA[SQL> startup
ORA-03113: end-of-file on communication channel
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

SQL> 

此]]></description><category></category></item><item><title><![CDATA[ORA-12547: TNS:lost contact]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7598369</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7598369</guid><author>aaaaaaaa2000</author><pubDate>Thu, 24 May 2012 14:53:39 +0800</pubDate><description><![CDATA[环境是：
[oracle@localhost ~]$ uname -a
Linux localhost.localdomain 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 i686 i386 GNU/Linux
安装的是10.2.0.1
按照文档上发现自己的系统包少了compat-libstdc++-33/compat-]]></description><category></category></item><item><title><![CDATA[ORA-27123: unable to attach to shared memory segment]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7597557</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7597557</guid><author>aaaaaaaa2000</author><pubDate>Thu, 24 May 2012 11:01:10 +0800</pubDate><description><![CDATA[今天在安装一个oracle10g的数据库，使用dbca的slient方式来安装，但是在日志中报这个错误
ORA-27123: unable to attach to shared memory segment

看到这个就知道是跟系统参数mmax有关，查看kernel.shmmax = 4294967295--4g，但是系统版本是32位的
[root@localhost install]#]]></description><category></category></item><item><title><![CDATA[ORACLE11G 字符集更改]]></title><link>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7595133</link><guid>https://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7595133</guid><author>aaaaaaaa2000</author><pubDate>Wed, 23 May 2012 16:13:57 +0800</pubDate><description><![CDATA[更改步骤：1、用sysdba角色用户登录sqlplus: 命令行输入：sqlplus sys as sysdba
               2、输入口令，进入sqlplus：sql>---
               3、依次键入下面的命令行执行：
                    shutdown immediate;
                    STARTUP]]></description><category></category></item></channel></rss>