-
-
-
超过十年Oracle数据库管理经验,擅长Oracle数据库诊断、优化。擅长产品包括 Oracle Database,RAC,RAT,ADG,Exadata,EM12c等
Gtalk&Mail: ricky.zhu#gmail.com Meta
-
Recent
Archive
- March 2016 (1)
- January 2016 (1)
- January 2014 (1)
- November 2013 (1)
- October 2013 (1)
- August 2013 (1)
- July 2013 (1)
- June 2013 (1)
- April 2013 (1)
- March 2013 (1)
- January 2013 (1)
- December 2012 (1)
- August 2012 (1)
- June 2012 (2)
- March 2012 (1)
- February 2012 (1)
- January 2012 (1)
- December 2011 (4)
- November 2011 (5)
- October 2011 (1)
- September 2011 (2)
- August 2011 (1)
- June 2011 (1)
- May 2011 (2)
- January 2011 (2)
- November 2010 (2)
- October 2010 (3)
- September 2010 (2)
- August 2010 (2)
- July 2010 (5)
- June 2010 (1)
- May 2010 (6)
- April 2010 (3)
- March 2010 (4)
- February 2010 (2)
- January 2010 (4)
- December 2009 (4)
- November 2009 (6)
- October 2009 (6)
- September 2009 (8)
- August 2009 (3)
- July 2009 (7)
- June 2009 (5)
- May 2009 (2)
- April 2009 (7)
- March 2009 (9)
- February 2009 (8)
- January 2009 (3)
- December 2008 (4)
- November 2008 (5)
- October 2008 (8)
- September 2008 (9)
- August 2008 (8)
- July 2008 (3)
- June 2008 (11)
- May 2008 (6)
- April 2008 (4)
- March 2008 (5)
- February 2008 (12)
- January 2008 (15)
- December 2007 (14)
- November 2007 (21)
- October 2007 (15)
- September 2007 (11)
- August 2007 (19)
- July 2007 (17)
- June 2007 (18)
- May 2007 (39)
- April 2007 (43)
- March 2007 (61)
- February 2007 (32)
- January 2007 (11)
- December 2006 (15)
Category
Oracle相关网站
博客圈子
数据库圈子
测试圈子
测试网站
Visitor
Monthly Archives: June 2012
ODI connect DB2
今天下午花了老鼻子劲把Oracle Data Integrator (ODI)连接DB2给搞定了,感谢weilin和Henry,感谢北京的shuoji,上海的ricky等童鞋。 后来发现不是ODI的问题,而是DB2服务端的问题,在这个问题搞定之后,通过SQL Developer也可以连接成功了。 首先第一步是从DB2的安装文件中把驱动文件copy到ODI的目录,两个文件分别是: db2jcc.jar db2jcc_license_cu.jar 然后把这两个驱动文件放到ODI的driver文件目录: C:\Documents and Settings\< 用户名>\Application Data\odi\oracledi\userlib 或者目录是(~/.odi/oracledi/userlib,在Unix系统上) D:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\drivers (odi home) 在ODI的物理技术中配置一个UDB DB2,然后使用Universal JDBC driver,详细配置如下: com.ibm.db2.jcc.DB2Driver jdbc:db2://:60000/ 问题就出在这里的端口60000,可是登陆到服务器发现60000端口根本没有监听。 netstat -an | grep 60000 无任何返回 确定db2是启动的,而且通过本地的db2 connect to dbname 是可以成功连接到实例和数据库。 检查了下db2的dbm也就是实例的配置参数,发现TCP的服务配置是空。 $db2 get … Continue reading
Post rootupgrade.sh for 11gR2 upgrade
When you upgrade Grid Infrastructure from pre 11.2.0.3 to 11.2.0.3, after execute rootupgrade.sh and lost you OUI windows by incident says: first node reboot. You might be confused what was missed and need to do afterward. After rootupgrade.sh successfully executed … Continue reading