关于10.2.0.5 agent无法连接9i (9.2.0.6)的问题

Posted on May 19, 2010

升级GC到10.2.0.5后，在给9i(9.2.0.6)数据库配置Agent时，主机监控可以顺利配置，但数据库连接总是无法配置成功。查看agent日志显示：

ERROR vpxoci: ORA-03113: end-of-file on communication channel
WARN  vpxoci: Login 0x27fa600 failed, error=ORA-03113: end-of-file on communication channel

事实上，不论是test connection，还是在服务器上用sqlplus做测试，都是没有问题的。那么，估计会是个agent的程序bug。翻遍Metalink[ID 828464.1]才最终发现这样一个补丁信息：升级RDBMS到9.2.0.8，或者应用agent补丁到10.2.0.5.2。

就像选数据库，总是倾向于最新主版本号的上一个版本，因为相对稳定，GC也是如此。Bug不可免，立此存照，以备后用。

bash-3.00$ opatch apply
Invoking OPatch 10.2.0.4.5

Oracle Interim Patch Installer version 10.2.0.4.5
Copyright (c) 2008, Oracle Corporation.  All rights reserved.

Oracle Home       : /u02/agent10g
Central Inventory : /var/opt/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 10.2.0.4.5
OUI version       : 10.2.0.5.0
OUI location      : /u02/agent10g/oui
Log file location : /u02/agent10g/cfgtoollogs/opatch/opatch2010-05-19_10-28-09AM.log

Patch history file: /u02/agent10g/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '9162498' to OH '/u02/agent10g'

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u02/agent10g')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '9162498' for restore. This might take a while...
Backing up files affected by the patch '9162498' for rollback. This might take a while...

Patching component oracle.sysman.top.agent, 10.2.0.5.0...
Updating archive file "/u02/agent10g/sysman/lib32/libnmec.a"  with "sysman/lib32/libnmec.a/nmecmc.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmehu.a"  with "sysman/lib32/libnmehu.a/nmehum.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmedt.a"  with "sysman/lib32/libnmedt.a/nmedt.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmee.a"  with "sysman/lib32/libnmee.a/nmeeps.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmefsql.a"  with "sysman/lib32/libnmefsql.a/nmefsql.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmefsqlt.a"  with "sysman/lib32/libnmefsqlt.a/nmefsqlt.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmeoci.a"  with "sysman/lib32/libnmeoci.a/vpxoci.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmeoci.a"  with "sysman/lib32/libnmeoci.a/vpxoci_ctx.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmeoci.a"  with "sysman/lib32/libnmeoci.a/vpxoci_que.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmeoci.a"  with "sysman/lib32/libnmeoci.a/vpxoci_stmt.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmec.a"  with "sysman/lib32/libnmec.a/nmecmgr.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmec.a"  with "sysman/lib32/libnmec.a/nmectc.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmee.a"  with "sysman/lib32/libnmee.a/nmeeamgv.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmee.a"  with "sysman/lib32/libnmee.a/nmeeamgb.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmee.a"  with "sysman/lib32/libnmee.a/nmeeamr.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmee.a"  with "sysman/lib32/libnmee.a/nmeece.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmee.a"  with "sysman/lib32/libnmee.a/nmeegd.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmevq.a"  with "sysman/lib32/libnmevq.a/nmevqd.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmec.a"  with "sysman/lib32/libnmec.a/nmeckc.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmedm.a"  with "sysman/lib32/libnmedm.a/nmedmm.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmevr.a"  with "sysman/lib32/libnmevr.a/nmevrm.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmec.a"  with "sysman/lib32/libnmec.a/nmecc.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmedm.a"  with "sysman/lib32/libnmedm.a/nmedmtd.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmehl.a"  with "sysman/lib32/libnmehl.a/nmehl.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmeps.a"  with "sysman/lib32/libnmeps.a/nmepstr.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmeu.a"  with "sysman/lib32/libnmeu.a/nmeumx.o"
Updating archive file "/u02/agent10g/sysman/lib32/libnmevsp.a"  with "sysman/lib32/libnmevsp.a/nmevsp.o"
Copying file to "/u02/agent10g/sysman/lib32/libnmemso.def"
Copying file to "/u02/agent10g/sysman/lib32/libnmevsp.def"
Copying file to "/u02/agent10g/sysman/admin/scripts/parse-log1.pl"
Copying file to "/u02/agent10g/bin/EMAgent.pm"
Copying file to "/u02/agent10g/sysman/admin/scripts/emdiscoveryhelper.pm"
Copying file to "/u02/agent10g/sysman/admin/metadata/oracle_bi_ans.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/oracle_bi_cc.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/oracle_bi_ps.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/oracle_bi_sch.xml"
Copying file to "/u02/agent10g/sysman/admin/scripts/biutil.pm"
Copying file to "/u02/agent10g/sysman/admin/default_collection/weblogic_j2eeserver.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/weblogic_j2eeserver.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/database.xmlp"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/dbclone/db_clone.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/ob/ob_common.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/sgastart.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/streams/pstats.pl"
Copying file to "/u02/agent10g/sysman/admin/default_collection/database.xmlp"
Copying file to "/u02/agent10g/sysman/admin/default_collection/instance.xmlp"
Copying file to "/u02/agent10g/sysman/admin/default_collection/oracle_database.xml"
Copying file to "/u02/agent10g/sysman/admin/default_collection/rac_database.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/cluster.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/dyn_props.xmlp"
Copying file to "/u02/agent10g/sysman/admin/metadata/instance.xmlp"
Copying file to "/u02/agent10g/sysman/admin/metadata/oracle_database.xml"
Copying file to "/u02/agent10g/sysman/admin/metadata/rac_database.xml"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/dbresp.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/dg/dgutil.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/direct_access.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/db/getHangTraces.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/rac/clsInterconn.pl"
Copying file to "/u02/agent10g/bin/HAConfigCmds.pm"
Copying file to "/u02/agent10g/sysman/admin/scripts/osm/ecmPatchDatabase.pl"
Copying file to "/u02/agent10g/sysman/admin/scripts/osm/ecmCloneHome.pl"
Running make for target libnmemso
Running make for target libnmefsql
Running make for target libnmefsqlt
Running make for target libnmeoci
Running make for target libnmevq
Running make for target libnmevsp
ApplySession adding interim patch '9162498' to inventory

Verifying the update...
Inventory check OK: Patch ID 9162498 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9162498 are present in Oracle Home.

The local system has been patched and can be restarted.

OPatch succeeded.

之后在emd.properties中添加参数AvoidOCIPing=1。

Related Posts

1. 关于RepositoryPatchUpgrade失败

» Filed Under Enterprise Management  Print This Post

Comments

• About Me

  Zeeno
  Oracle ERP Consultant
  Fantastic Fiction Fans
  - Oracle Certified Professional (OCP)
  - Oracle Certified Expert on EBS 11i
  More...

• Pages

  • About
  • Resources

• Categories

  • APEX
  • Database
  • E-Business Suite
  • Enterprise Management
  • Review
  • Uncategorized
  • UPK
  • Workflow

• Recent Posts

  • APEX 上传xls文件
  • APEX 4 中的文件上传功能
  • 迎接变化
  • EBS 11i升级到R12
  • EBS 11i数据库升级(9i->10g)几点事项
  • 关闭功能顾问的那些诊断模式
  • 计划管理器(Planning Manager)技术概要
  • Planning Manager诊断过程和10046事件
  • 我们需要监控什么？
  • 关于10.2.0.5 agent无法连接9i (9.2.0.6)的问题

• Archives

  Select Month August 2010 July 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009 July 2009 June 2009 May 2009 April 2009 March 2009 February 2009 January 2009 December 2008 November 2008 October 2008 September 2008 August 2008 July 2008 June 2008 May 2008 April 2008 March 2008 February 2008 January 2008 December 2007 November 2007 October 2007 September 2007 August 2007 July 2007 May 2007 April 2007 March 2007 December 2006 November 2006 October 2006 September 2006 August 2006
• 本站文章均为原创

• Search