<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Paranoimer</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Paranoimer]]></copyright><item><title><![CDATA[【无标题】]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/121531218</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/121531218</guid><author>Paranoimer</author><pubDate>Thu, 25 Nov 2021 10:03:40 +0800</pubDate><description><![CDATA[error in invoking target ‘agent nmhs’ of make file ins_emagent.mk while installing Oracle 11.2.0.4 on Linux (文档 ID 2299494.1)
When installing Oracle database 11.2.0.4 software on some Linux x86-64 releases, such as SUSE12SP1, SUSE12SP2 or RHEL7, the below ]]></description><category></category></item><item><title><![CDATA[Upgrade Oracle 11.2.0.2 to 11.2.0.3]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936799</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936799</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:54:20 +0800</pubDate><description><![CDATA[1.11.2.0.3版本只提供outplace升级，在rac1、rac2上分别创建独立目录
mkdir /u02
chown -R oracle:oinstall /u02
chmod -R 775 /u02]]></description><category></category></item><item><title><![CDATA[更新11.2.0.2.12最新补丁集]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936765</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936765</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:51:56 +0800</pubDate><description><![CDATA[目标更新11.2.0.2.12最新补丁集

1.两节点上ORACLE_HOME与GRID_HOME目录opatch更新]]></description><category></category></item><item><title><![CDATA[Tengine 配置]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936733</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936733</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:50:32 +0800</pubDate><description><![CDATA[系统环境：CentOS 5.9 X86_64
Tengine 2.0.3下载地址:http://tengine.taobao.org/download/tengine-2.0.3.tar.gz

安装依赖 
yum -y install  pcre.i386 pcre.x86_64 pcre-devel.i386 pcre-devel.x86_64]]></description><category></category></item><item><title><![CDATA[install Oracle Database insilent]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936669</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936669</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:46:23 +0800</pubDate><description><![CDATA[一、OS:CENTOS 6.5 X86_64
二、更新必要的软件包
yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libgcc libgcc.i686 libstdc++ libs]]></description><category></category></item><item><title><![CDATA[Oracle回滚导致系统响应异常缓慢]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936635</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936635</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:44:29 +0800</pubDate><description><![CDATA[症状：
1）早上决策运算过程没有正常执行；
2）大量IO占用，且未出现下降；
3）客户端几乎无法连接数据库；
4）通过EM查看到有大量由于snmp、sysman在执行相关语句的阻塞。]]></description><category></category></item><item><title><![CDATA[oracle安装发生DefaultErrorAdvisor:37]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936603</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936603</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:42:10 +0800</pubDate><description><![CDATA[linux 系统中安装oracle 11g出现

root@OAdata OraInstall2014-02-18_11-02-11AM]# <em>cat oraInstall2014-02-18_11-02-11AM.err 
---# Begin Stacktrace #---------------------------
ID: oracle.install.commons.util.exceptio]]></description><category></category></item><item><title><![CDATA[LINUX 扩展逻辑卷]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936561</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936561</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:40:21 +0800</pubDate><description><![CDATA[一、添加逻辑卷
[root@OAdata VolGroup00]#fdisk /dev/sdc
n
p 
t
8e

[root@OAdata VolGroup00]#pvcreate /dev/sdc1
[root@OAdata VolGroup00]#pvdisplay

[root@OAdata VolGroup00]#vgcreate vg0 /dev/sdc1
[root@OAdata VolGroup00]]></description><category></category></item><item><title><![CDATA[CentOS 6.2配置桌面及VNCSERVER]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936459</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936459</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:34:43 +0800</pubDate><description><![CDATA[一、相关资源包检查与安装
```
1.查看是否安装相关包支持
yum groupinstall "Chinese Support"   --语言环境支持包
yum     groupinstall "Desktop"     --桌面支持包
2.系统语言配置
vi i18n
将LANG修改为"zh_CN.UTF-8"

3.查看VNCSERVER是否安装 
rpm -qa|grep tigervnc
4.如果尚未安装]]></description><category></category></item><item><title><![CDATA[linux 根据端口查找进程号]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936411</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936411</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:31:22 +0800</pubDate><description><![CDATA[在配置apache过程中，启动时发现:
```停止 httpd：[失败]
启动 httpd：(98)Address already in use: make_sock: could not bind to address 192.168.0.108:80
no listening sockets available, shutting down
Unable to open logs]]></description><category></category></item><item><title><![CDATA[Oracle user password has expired]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936353</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936353</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:26:35 +0800</pubDate><description><![CDATA[在日常数据运维过程 中，由于缺乏定期检查机制或数据库运维规范导致出现“the password has expired ”。 
解决办法一：直接修改口令

ALTER USER testuser IDENTIFIED BY password;
但是在调整11g sysman,dbsnmp帐户时，由于口令加密机制，不能直接以原来的密码更新，否则em等工具就无法正常启动]]></description><category></category></item><item><title><![CDATA[SQL语句性能调整一例]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936321</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936321</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:25:36 +0800</pubDate><description><![CDATA[公司开发同事发来一条语句，反应执行很慢，原语句如下：

SELECT COUNT(df.origrec)* it.scale AS pcount,
  it.invcode                       AS invcode,
  df.samplefrom                    AS rasclientid
FROM da_finance_pricesett df,
  dbs_db_]]></description><category></category></item><item><title><![CDATA[将指定SQL_ID 的执行计划 flush出shared pool]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44936283</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44936283</guid><author>Paranoimer</author><pubDate>Wed, 08 Apr 2015 09:22:26 +0800</pubDate><description><![CDATA[在调试某特定SQL时，为避免缓存带来的影响，常常需要先将原来 的缓存清空而需要使用下面命令：

SQL>ALTER SYSTEM FLUSH SHARED_POOL；
但是在生产系统中，使用上面命令对系统整体会有一个较大影响，如何将特定的SQL刷出缓存？

SQL>SELECT address,]]></description><category></category></item><item><title><![CDATA[升级到11.2.0.2后出现性能急剧下降(解决）]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44917493</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44917493</guid><author>Paranoimer</author><pubDate>Tue, 07 Apr 2015 10:53:09 +0800</pubDate><description><![CDATA[说明： 
数据库由11.1.0.6升级到11.2.0.2后不时出现系统整体性能急剧下降，查看系统系统顶级活动，发现因某条SQL语句并发度极高几乎占用所有的CPU资源，删除该语句执行计划系统恢复正常。原先以为执行计划选择不正确，调整系统收集样本量，创建执行计划基线，最后无效。 
通过STATSPACK发现cursor: mutex S、li]]></description><category></category></item><item><title><![CDATA[Oracle 诊断一例　ADDM Reports Significant Virtual Memory Paging]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44917423</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44917423</guid><author>Paranoimer</author><pubDate>Tue, 07 Apr 2015 10:48:23 +0800</pubDate><description><![CDATA[Oracle  　ADDM Virtual Memory Paging]]></description><category></category></item><item><title><![CDATA[EXPDP ORA-39083]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44917347</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44917347</guid><author>Paranoimer</author><pubDate>Tue, 07 Apr 2015 10:43:47 +0800</pubDate><description><![CDATA[Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "NC50"."SYS_IMPORT_SCHEMA_04]]></description><category></category></item><item><title><![CDATA[create as & insert into 语句性能分析]]></title><link>https://blog.youkuaiyun.com/Paranoimer/article/details/44917293</link><guid>https://blog.youkuaiyun.com/Paranoimer/article/details/44917293</guid><author>Paranoimer</author><pubDate>Tue, 07 Apr 2015 10:41:06 +0800</pubDate><description><![CDATA[SQL performance 性能]]></description><category></category></item></channel></rss>