9.2.0.6.0又遇600错误

  今天接到客户电话，说EBS不能用了，现在不能登录。登上服务器检查了一遍，没发现什么问题。检查ORACLE告警日志的时候发现了问题所在：ORA-00600: 鍐呴儴閿欒?浠ｇ爜锛屽弬鏁? [kqrfrpo], [0x70000006DF9E898], [11], [], [], [], [], []
上METALINK一搜，看来十有八九是BUG。先不管开TAR获得ORACLE SUPPORT的确认再说。得到确认后，在测试机上准备打PATCH了。关闭INSTANCE，监听后，上传补丁，解压，设置OPAtch的path，然后就开始动工了。

 

$ cd patch
$ ls
4070181                     p3835429_9206_AIX64-5L.zip
$ cd 4070181
$ ls
README.txt  etc         files
$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.52
Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = /u01/oradev/devdb/9.2.0
Location of Oracle Universal Installer components = /u01/oradev/devdb/9.2.0/oui
Location of OraInstaller.jar  = "/u01/oradev/devdb/9.2.0/oui/jlib"
Oracle Universal Installer shared library = /u01/oradev/devdb/9.2.0/oui/lib/aix/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /u01/oradev/devdb/9.2.0/inventory
Path to Java = /u01/oradev/devdb/9.2.0/jre/1.4.2/bin/java
Log file = /u01/oradev/devdb/9.2.0/.patch_storage//*.log

Backing up comps.xml ...

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

Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/oradev/devdb/9.2.0)
Is this system ready for updating?
Please respond Y|N >
Y
Patching...
Printing stderr to output (from /u01/oradev/devdb/9.2.0/.patch_storage/4070181/make_local.stderr)
ld: 0711-415 WARNING: Symbol lxscop is already exported.

ld: 0711-415 WARNING: Symbol ociepgoe is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_ADT is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_CHAR is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_DATETIME is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_INDEXED is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_INTERVAL is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_LOB is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_OBJREF is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_OPQ is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_SSCALAR is already exported.

ld: 0711-415 WARNING: Symbol pevm_INMDH_INDEXED_UROWID is already exported.

ld: 0711-415 WARNING: Symbol plzcls is already exported.

ld: 0711-415 WARNING: Symbol plzexe is already exported.

ld: 0711-415 WARNING: Symbol plzopn is already exported.

ld: 0711-415 WARNING: Symbol plzosq is already exported.

ld: 0711-415 WARNING: Symbol pevm_ENTER is already exported.

ld: 0711-415 WARNING: Symbol pevm_MOVX is already exported.

ld: 0711-415 WARNING: Symbol peslcl2 is already exported.

ld: 0711-415 WARNING: Symbol ldxdts is already exported.

ld: 0711-415 WARNING: Symbol ldxsto is already exported.

ld: 0711-415 WARNING: Symbol lxgu2t is already exported.

ld: 0711-415 WARNING: Symbol sldxgd is already exported.

ld: 0711-319 WARNING: Exported symbol not defined: pen_PIPE

ld: 0711-319 WARNING: Exported symbol not defined: pevm_MOVCADT

ld: 0711-319 WARNING: Exported symbol not defined: pevm_MOVL

ld: 0711-319 WARNING: Exported symbol not defined: pevm_MOVS

ld: 0711-319 WARNING: Exported symbol not defined: pifi_i

ld: 0711-319 WARNING: Exported symbol not defined: puisun_SetUserName

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[sxstime.o], imported symbol timezone

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol kslltt_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol ksupro_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//libordsdo9.a[mdowd.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//libordsdo9.a[mdidx.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressOlapiDataSourceModule_s.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressConnectionModule_s.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressOlapiDataSourceModule.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressOlapiDataCursorModule.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressMdmModule.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressConnectionModule.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[ExpressModule.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsoqoes.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsknx.o], imported symbol ksuitpr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//libordsdo9.a[mdrcr.o], imported symbol kcbstdbz_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//libordsdo9.a[mdrt.o], imported symbol kcbstdbz_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[update.o], imported symbol kcmshr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol kxfpxser_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpcc_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpccdata_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpccerep_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpcdqr_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsdbpc.o], imported symbol xsdbpcdqe_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[update.o], imported symbol xspgcco_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xscalcflw1_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xscalcflw2_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xscalcflw3_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xssinfoflw1_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsft.o], imported symbol xssinfoflw2_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawsga_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawSGAlopen_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawSGAlclose_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-773 WARNING: Object /u01/oradev/devdb/9.2.0/lib//liboraolap9.a[xsawsga.o], imported symbol xsawst_

        Symbol was expected to be local. Extra instructions

        are being generated to reference the symbol.

ld: 0711-783 WARNING: TOC overflow. TOC size: 101536    Maximum size: 65536

        Extra instructions are being generated for each reference to a TOC

        symbol if the symbol is in the TOC overflow area.

Updating inventory...
Backing up comps.xml ...

OPatch succeeded.
$ opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.52
Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = /u01/oradev/devdb/9.2.0
Location of Oracle Universal Installer components = /u01/oradev/devdb/9.2.0/oui
Location of OraInstaller.jar  = "/u01/oradev/devdb/9.2.0/oui/jlib"
Oracle Universal Installer shared library = /u01/oradev/devdb/9.2.0/oui/lib/aix/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /u01/oradev/devdb/9.2.0/inventory
Path to Java = /u01/oradev/devdb/9.2.0/jre/1.4.2/bin/java
Log file = /u01/oradev/devdb/9.2.0/.patch_storage//*.log

Result:

  Installed Patch List:
  =====================
  1) Patch 4070181 applied on Wed Mar 12 09:39:58 GMT+08:00 2008
      [ Base Bug(s): 3835429  ]
  2) Patch 2701372 applied on Wed Jul 13 14:25:16 GMT+08:00 2005
      [ Base Bug(s): 2701372  ]
  3) Patch 4081980 applied on Wed Jul 13 14:24:49 GMT+08:00 2005
      [ Base Bug(s): 4081980  ]
  4) Patch 4385803 applied on Wed Jul 13 14:24:20 GMT+08:00 2005
      [ Base Bug(s): 4385803  ]
  5) Patch 4252938 applied on Wed Jul 13 14:23:46 GMT+08:00 2005
      [ Base Bug(s): 4252938 3787344 3669454  ]
  6) Patch 4167403 applied on Wed Jul 13 14:23:08 GMT+08:00 2005
      [ Base Bug(s): 4167403  ]
  7) Patch 3691672 applied on Wed Jul 13 14:22:33 GMT+08:00 2005
      [ Base Bug(s): 3691672  ]
  8) Patch 3682068 applied on Wed Jul 13 14:22:04 GMT+08:00 2005
      [ Base Bug(s): 3682068  ]
  9) Patch 3202151 applied on Wed Jul 13 14:21:29 GMT+08:00 2005
      [ Base Bug(s): 3202151  ]
  10) Patch 4430748 applied on Wed Jul 13 14:20:56 GMT+08:00 2005
      [ Base Bug(s): 4161400 4193295 3949307 4141415 4161315 4017526 4049345 4430748 4199440  ]
  11) Patch 4155285 applied on Wed Jul 13 14:15:56 GMT+08:00 2005
      [ Base Bug(s): 3900237  ]
  12) Patch 4140446 applied on Wed Jul 13 14:15:23 GMT+08:00 2005
      [ Base Bug(s): 3794402  ]
  13) Patch 4145742 applied on Wed Jul 13 14:14:50 GMT+08:00 2005
      [ Base Bug(s): 3467622  ]
  14) Patch 4121240 applied on Wed Jul 13 14:14:16 GMT+08:00 2005
      [ Base Bug(s): 2785957  ]

 

OPatch succeeded.