<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Sharon--start focusing on Oracle]]></title><description><![CDATA[Dave said 'The important thing in life is to have a great aim and the determination to attain it'.]]></description><link>https://blog.youkuaiyun.com/sharqueen</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sharqueen]]></copyright><item><title><![CDATA[linux平台Informatica通过odbc连接达梦数据库]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/102731431</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/102731431</guid><author>sharqueen</author><pubDate>Thu, 24 Oct 2019 20:46:37 +0800</pubDate><description><![CDATA[版权声明：本文为优快云博主「Sharqueen」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.youkuaiyun.com/sharqueen/article/details/102731431



一、安装客户端

1. 创建安装用户

为了减少对操作系统的影响，用户不应该以root系统用户来安装和运行DM。用户可以在安装之...]]></description><category></category></item><item><title><![CDATA[【RAC】修改private ip]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/51314550</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/51314550</guid><author>sharqueen</author><pubDate>Wed, 04 May 2016 14:46:20 +0800</pubDate><description><![CDATA[上一篇写了如何修改public ip和virtual ip，那如何修改private ip呢？
承接上篇博文，继续写如何修改private ip。

1.修改privateIP（只需在一个节点上操作即可） （此次无需修改）


--确认网卡配置



$ oifcfg getif -global
en5  10.10.10.0 global  cluster_intercon]]></description><category></category></item><item><title><![CDATA[【RAC】修改public IP&VIP]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/51314226</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/51314226</guid><author>sharqueen</author><pubDate>Wed, 04 May 2016 14:10:22 +0800</pubDate><description><![CDATA[好久没更新了，今天来一发，就写下最近做的一个操作，修改11g RAC的public ip 以及 virtual ip，命令同样适用于10g。
一.         IP 信息




原IP地址


新IP地址


说明




192.168.131.11


192.168.130.11


scan ip




192.168.131]]></description><category></category></item><item><title><![CDATA[【Troubleshooting】用户组/权限_导致grid日志不轮循清理_Bug 9595783]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/45668011</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/45668011</guid><author>sharqueen</author><pubDate>Tue, 12 May 2015 12:56:39 +0800</pubDate><description><![CDATA[Bug 9595783  Owner and permission problemsafter applying a patch to an 11.2.0.1 Grid Infrastructure Home
 This note givesa brief overview of bug 9595783. 
 The content was last updated on: 02-DEC-20]]></description><category></category></item><item><title><![CDATA[【DB】SYSAUX表空间使用率高问题处理]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/44957259</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/44957259</guid><author>sharqueen</author><pubDate>Thu, 09 Apr 2015 11:18:53 +0800</pubDate><description><![CDATA[一般来讲除开业务数据存放的表空间，DBA要着重关注SYSTEM,SYSAUX,UNDO,TEMP表空间，SYSTEM表空间的大小一般是衡定的，UNDO和TEMP表空间的大小由数据库的业务情况决定，而SYSAUX表空间在默认条件下你如果不做任何配置，随着时间的推移，会膨胀的越来越大！SYSAUX表空间做为SYSTEM表空间的辅助表空间，主要存放EM相关的内容以及表统计信息，AWR快照，审计信息等，个]]></description><category></category></item><item><title><![CDATA[【SQL】子查询中有rownum，导致全表扫描，效率极]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/42105477</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/42105477</guid><author>sharqueen</author><pubDate>Tue, 23 Dec 2014 17:35:59 +0800</pubDate><description><![CDATA[现象：

视图中有rownum，导致在条件查询视图时用不到索引。
如视图：




CREATE OR
REPLACE FORCE 
VIEW V_BILL
(
   ID,
   VSLNAME,
   VOYAGE,
   BLNO,
   WEIGHT,
   PACKAGE
)
AS
   SELECT 
rownum,
vslname,]]></description><category></category></item><item><title><![CDATA[【ASYNC IO】HP-UNIX_ORACLE10G_ASYNC IO ERROR]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/41745695</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/41745695</guid><author>sharqueen</author><pubDate>Fri, 05 Dec 2014 11:52:29 +0800</pubDate><description><![CDATA[今天无意中开发数据库下的udump产生大量的trace文件，内容如下：

[EPDEV]/u01/oracle/admin/epdev/udump$more epdev_ora_25840.trc
/u01/oracle/admin/epdev/udump/epdev_ora_25840.trc
Oracle Database 10g Enterprise Edition Release ]]></description><category></category></item><item><title><![CDATA[【exp】11g新特性——exp不导出空表]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/41286845</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/41286845</guid><author>sharqueen</author><pubDate>Wed, 19 Nov 2014 20:01:21 +0800</pubDate><description><![CDATA[11g exp 导出会忽略 0 rows 的表，即kong]]></description><category></category></item><item><title><![CDATA[【SQL】Oracle 数据库的绑定变量特性及应用]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/39473557</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/39473557</guid><author>sharqueen</author><pubDate>Mon, 22 Sep 2014 10:51:38 +0800</pubDate><description><![CDATA[Oracle 数据库的绑定变量特性及应用
关键词:
绑定变量(binding variable),共享池(shared buffer pool),SGA(system global area);
在开发一个数据库系统前,有谁对Oracle 系统了解很多,尤其是它的特性,好象很少吧;对初学者来讲,这更是不可能的事情;仅仅简单掌握了SQL的写法,就开始了数据库的开发,其结果只能是开发一个没有效率]]></description><category></category></item><item><title><![CDATA[【Troubleshooting】外键不建索引易导致死锁]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/39183189</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/39183189</guid><author>sharqueen</author><pubDate>Wed, 10 Sep 2014 16:48:14 +0800</pubDate><description><![CDATA[1.外键不建索引，更新外键字段会锁住父表，易导致死锁
父表：P_TABLE
子表：F_TABLE
外键字段：object_id
 
未建索引：
session1:

SQL>update f_table set object_id='10000' where object_id=116053;
 
1 rowupdated.

 
session2:

SQL>upd]]></description><category></category></item><item><title><![CDATA[toad、oracle client、oracle DB版本问题，ora-12705错误]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/39051173</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/39051173</guid><author>sharqueen</author><pubDate>Thu, 04 Sep 2014 13:56:36 +0800</pubDate><description><![CDATA[最近升级了数据库到11.2.0.4，后]]></description><category></category></item><item><title><![CDATA[【ORA-600】[kcratr_nab_less_than_odr] 异常宕机后的实例恢复during Instance Recovery after Database Crash]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/37876369</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/37876369</guid><author>sharqueen</author><pubDate>Wed, 16 Jul 2014 13:46:28 +0800</pubDate><description><![CDATA[由于操作系统异常变为只读操作系统，不能读写数据文件，导致实例异常终止。从而导致实例重启时，在open阶段，报ORA-600 [kcratr_nab_less_than_odr]错误。
ORA-600 [kcratr_nab_less_than_odr] during Instance Recovery after Database Crash (文档 ID 1299564.1)



]]></description><category></category></item><item><title><![CDATA[【DG】ORA-1 Occurring on Logical Standby (文档 ID 257356.1)]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/30461867</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/30461867</guid><author>sharqueen</author><pubDate>Fri, 13 Jun 2014 10:36:19 +0800</pubDate><description><![CDATA[Problem Description
-------------------

During SQL Apply operations on the logical standby you see the following
messages in the alert log:

 LOGSTDBY stmt: alter table test add constraint test_pk pr]]></description><category></category></item><item><title><![CDATA[【Gateway安装】Linux下 已存在DB10gR2 安装Gateway11gR2 for sybase]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/30244317</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/30244317</guid><author>sharqueen</author><pubDate>Thu, 12 Jun 2014 14:13:12 +0800</pubDate><description><![CDATA[在已装有Oracle DB 10gR2的windows 环境下安装 gateway 11g for sybase

1.建立安装目录

[oracle@QGYT01~]$ mkdir /u03/gateway

 
2.使用OUI安装

[oracle@QGYT01gateways]$ ./runInstaller

 


注意：由于数据库版本与gateway版本不同]]></description><category></category></item><item><title><![CDATA[【Gateway安装】Windows 下 已存在DB10gR2 安装Gateway11gR2 for sybase]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/30238743</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/30238743</guid><author>sharqueen</author><pubDate>Thu, 12 Jun 2014 13:13:04 +0800</pubDate><description><![CDATA[1.建立安装目录

 
2.使用OUI安装

注意：win7下安装要使用管理员身份、兼容模式运行程序，否则会报“程序异常终止”的错误。
 


注意：由于数据库版本与gateway版本不同，因此不能在原oracle_home目录下安装gateway，要使用新目录，否则bin下的程序会被覆盖，导致oracle软件不可用。
 




 

此处是配置监听，由于我之前]]></description><category></category></item><item><title><![CDATA[【Gateway】11g常见错误]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/30237371</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/30237371</guid><author>sharqueen</author><pubDate>Thu, 12 Jun 2014 12:43:53 +0800</pubDate><description><![CDATA[How to Resolve Common Errors Encountered while using Database Gateways (DG4IFMX, Dg4MSQL, DG4SYBS), DG4ODBC or GenericConnectivity (文档 ID 234517.1)

APPLIES TO:

Oracle Database - Enterprise Editi]]></description><category></category></item><item><title><![CDATA[小心小心再小心！！！——误操作删除rac一节点的安装目录]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/29845495</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/29845495</guid><author>sharqueen</author><pubDate>Tue, 10 Jun 2014 15:39:55 +0800</pubDate><description><![CDATA[昨天发生了我职业生涯中的首次事故——u01安装的crs、oracle目录]]></description><category></category></item><item><title><![CDATA[【OGG】extract 异常恢复 BR – BOUNDED RECOVERY]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/27349865</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/27349865</guid><author>sharqueen</author><pubDate>Wed, 28 May 2014 16:59:53 +0800</pubDate><description><![CDATA[BR – BOUNDED RECOVERY
适用于 Extract 进程（仅适用于 Oracle数据库）
使用 BR 参数可以控制 GoldenGate 的 Bounded Recovery (BR) 功能。Bounded Recovery 功能仅支持 Oracle 数据库。
Bounded Recovery 是通用 Extract 检查点工具的组件之一，可以保证当Extract 进程出于任]]></description><category></category></item><item><title><![CDATA[【OGG-01161】源端表结构发生变化导致replicat进程abend]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/26448325</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/26448325</guid><author>sharqueen</author><pubDate>Wed, 21 May 2014 10:08:01 +0800</pubDate><description><![CDATA[错误日志如下：

2014-05-21 09:31:34  ERROR   OGG-01161 Oracle GoldenGate Delivery for Oracle, r54gh1.prm:  Bad column index (35) specified for tableGH.APP_INFO, max columns = 35.
2014-05-21 09:31:34  ERRO]]></description><category></category></item><item><title><![CDATA[【OGG-01414】extract abend CACHEMGR: tran id: 0 length memtran]]></title><link>https://blog.youkuaiyun.com/sharqueen/article/details/25629709</link><guid>https://blog.youkuaiyun.com/sharqueen/article/details/25629709</guid><author>sharqueen</author><pubDate>Mon, 12 May 2014 16:10:30 +0800</pubDate><description><![CDATA[GoldenGate Extract abends:OGG-01414 CACHEMGR: tran id: 0 length memtran: 0x0000000103cba020. (文档 ID1555670.1)
rac一节点配置了OGG，在启动extract进程不久后报错：OGG-01414CACHEMGR: tran id: 0 length memtran: 0x0000000103]]></description><category></category></item></channel></rss>