<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[gHost241的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/gHost241</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; gHost241]]></copyright><item><title><![CDATA[Oracle 日常巡检]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/50537358</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/50537358</guid><author>gHost241</author><pubDate>Mon, 18 Jan 2016 16:06:41 +0800</pubDate><description><![CDATA[1. 检查数据库基本状况


包含：检查Oracle实例状态，检查Oracle服务进程，检查Oracle监听进程，共三个部分。


1.1. 检查Oracle实例状态


select instance_name,host_name,startup_time,status,database_status from v$instance;


其中“STATUS”表示Orac]]></description><category></category></item><item><title><![CDATA[ORA-02080:database link is in use]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/50537305</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/50537305</guid><author>gHost241</author><pubDate>Mon, 18 Jan 2016 16:01:59 +0800</pubDate><description><![CDATA[ORA-02080:
database link is in use
Cause: a transaction is active or a cursor is open on the database link given in the alter session close database link  command.
Action: commit or rollback, and c]]></description><category></category></item><item><title><![CDATA[ORA-01555: 快照过旧: 回退段号 31 (名称为 "_SYSSMU31$") 过小]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/50537063</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/50537063</guid><author>gHost241</author><pubDate>Mon, 18 Jan 2016 15:37:37 +0800</pubDate><description><![CDATA[错误原因：
SQL语句执行时间太长，或者UNDO表空间过小，或者事务量过大，或者过于频繁的提交，导致执行SQL过程中进行一致性读时，SQL执行后修改的 前镜像（即UNDO数据）在UNDO表空间中已经被覆盖，不能构造一致性读块（CR blocks）。  这种情况最多。

解决办法：
 第1种情况解决的办法：

（1）增加UNDO表空间大小
（2）增加undo_retention 时间，]]></description><category></category></item><item><title><![CDATA[修改session,processes,transactions参数]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/50354677</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/50354677</guid><author>gHost241</author><pubDate>Fri, 18 Dec 2015 22:59:34 +0800</pubDate><description><![CDATA[--Version:Oracle 11.2.0.4
--Processes 设为500
--根据公式：sessions=1.5*500+22=772
--          transactions=1.1*sessions=850

--alter system set processes=500 scope=spfile;

--alter system set sessions=772 sc]]></description><category></category></item><item><title><![CDATA[扩展undo表空间容量]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/49962611</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/49962611</guid><author>gHost241</author><pubDate>Sat, 21 Nov 2015 10:48:23 +0800</pubDate><description><![CDATA[查看表空间使用情况
SELECT a.tablespace_name,
         ROUND (a.total_size) "total_size(MB)",
         ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",
         ROUND (b.free_size, 3) "free_size(M]]></description><category></category></item><item><title><![CDATA[UNDO表空间100%诊断]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/49850111</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/49850111</guid><author>gHost241</author><pubDate>Sun, 15 Nov 2015 16:41:32 +0800</pubDate><description><![CDATA[http://blog.itpub.net/24966341/viewspace-1123671/]]></description><category></category></item><item><title><![CDATA[Linux 下扩充根分区分区的大小]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/6955872</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/6955872</guid><author>gHost241</author><pubDate>Thu, 10 Nov 2011 13:47:28 +0800</pubDate><description><![CDATA[系统环境：RedHat 5.5 64bit
系统情况：采用操作系统默认分区（LV）
事件原由：扩充根分区大小
操作记录：
[root@node1 ~]# fdisk /dev/sdb 
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS]]></description><category></category></item><item><title><![CDATA[修改Orace RAC+ASM下归档日志路径]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/6955853</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/6955853</guid><author>gHost241</author><pubDate>Thu, 10 Nov 2011 13:40:33 +0800</pubDate><description><![CDATA[软件环境：Orace 11G R2 RAC+ASM
软件事件：修改RAC环境下归档日志路径
操作过程：
1、查看当前环境下归档日志路径
SQL> show parameter db_recovery
NAME         TYPE  VALUE
------------------------------------ ----------- --------------------]]></description><category></category></item><item><title><![CDATA[ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/6955817</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/6955817</guid><author>gHost241</author><pubDate>Thu, 10 Nov 2011 13:34:32 +0800</pubDate><description><![CDATA[系统环境： Oracle 11G R2 RAC
RAC事件：修改Oracle RAC 归档日志路径参数，导致数据库实例无法正常启动
错误提示：ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
处理方法：
1、复制数据库初始化文件参数文件init.ora.81720111857]]></description><category></category></item><item><title><![CDATA[ORA-01105: mount is incompatible with mounts by other instances]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/6954878</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/6954878</guid><author>gHost241</author><pubDate>Thu, 10 Nov 2011 09:57:45 +0800</pubDate><description><![CDATA[Oracle 11G R2 RAC环境
今天启动其中一个节点报错，提示如下：
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
解决方法：
根据ORA-19808提示，应该为调整Oracle某个参数导致，两个节]]></description><category></category></item><item><title><![CDATA[Oracle(表空间) 数据文件自动增加]]></title><link>https://blog.youkuaiyun.com/gHost241/article/details/6954682</link><guid>https://blog.youkuaiyun.com/gHost241/article/details/6954682</guid><author>gHost241</author><pubDate>Thu, 10 Nov 2011 09:42:32 +0800</pubDate><description><![CDATA[--------执行此脚本之前需要创建名称为 datafile_no 的序列 最小值为1 增长量为1 最大值为 10000000
 --------默认为在表空间HIS_DATA下创建数据文件。
 --------过程创建之后需要进行编译，编译成功后，创建job进行调用。间隔时间为 trunc(sysdate+1,'DD')+1/24 每天调用。
 --------并且调用时间必须在同步数据]]></description><category></category></item></channel></rss>