4 Replies Latest reply: May 27, 2010 9:03 AM by user11981603 RSS

    Installing PSU APR 2010 for Oracle 11.2.0.1 on AIX 5300-11-02-1007

    769569
      Hi
      I was able to install Oracle 11.2.0.1 database successfully. When I tried to install latest PSU for 11.2.0.1 (Patch #9352237) released by Oracle, It finished with warnings:

      I couldn't find anything related to this warnings on 11.2.0.1 database on AIX.

      WARNING:OUI-67215:
      OPatch found the word "error" in the stderr of the make command.
      Please look at this stderr. You can re-run this make command.
      Stderr output:
      ld: 0711-415 WARNING: Symbol ldxdts is already exported.
      ld: 0711-415 WARNING: Symbol ldxsto is already exported.
      ld: 0711-415 WARNING: Symbol lnxadd is already exported.
      ld: 0711-415 WARNING: Symbol lnxcopy is already exported.
      ld: 0711-415 WARNING: Symbol lnxmin is already exported.
      ld: 0711-415 WARNING: Symbol lnxmul is already exported.
      ld: 0711-415 WARNING: Symbol lnxnur is already exported.
      ld: 0711-415 WARNING: Symbol lnxren is already exported.
      ld: 0711-415 WARNING: Symbol lnxsca is already exported.
      ld: 0711-415 WARNING: Symbol lnxshift is already exported.
      ld: 0711-415 WARNING: Symbol lnxsni is already exported.
      ld: 0711-415 WARNING: Symbol lxgu2t is already exported.
      ld: 0711-415 WARNING: Symbol sldxgd is already exported.
      ld: 0711-224 WARNING: Duplicate symbol: __pthread_trace
      ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeout64
      ld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeout64
      ld: 0711-224 WARNING: Duplicate symbol: .aio_nwait64
      ld: 0711-224 WARNING: Duplicate symbol: aio_nwait64
      ld: 0711-224 WARNING: Duplicate symbol: fc_softc
      ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
      ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
      ld: 0711-319 WARNING: Exported symbol not defined: count__21TxsOqSourceDefinitionFP31TxsOqSourceDefinitionController
      ld: 0711-319 WARNING: Exported symbol not defined: cout__3std
      ld: 0711-319 WARNING: Exported symbol not defined: create11gMeasure__26TxsOqAWExpressionGeneratorFRC9xswstringPC18TxsOqAWMeasureInfoP25TxsOqSQLGenerationCont
      ext
      ld: 0711-319 WARNING: Exported symbol not defined: createAWDimensionColumn__27TxsOqSQLBaseSelectStatementFP24TxsOqMdmPrimaryDimensionP24TxsOqSQLBaseSelectCol
      umnP25TxsOqSQLGenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAWDimensionColumn__27TxsOqSQLBaseSelectStatementFP27TxsOqMdm10gPrimaryDimensionP24TxsOqSQLBaseSelect
      ColumnP25TxsOqSQLGenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAWLevelHierarchyHolder__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshotP22TxsOqGenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAWLevelHolder__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshotP22TxsOqGenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAWMeasureInfo__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshotP22TxsOqGenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAWOffsetHolder__23TxsOqAWGenerationHelperFPC19TxsOqSourceSnapshot20ExsOqMdm10gLevelTypeiP22TxsOqGene
      rationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAncestorsTableHolder__28TxsOqSQLAncestorsTableHolderFP33TxsOqSQLDimensionExpressionHolderP25TxsOqSQL
      GenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createAndMapLevel__25TxsOqLegacyMetadataReaderFPUcN61P24TxsOqMdmPrimaryDimensionP22TxsOqMdmLevelHierarchyP
      P17TxsOqSynBaseQueryPP25TxsOqMdmHierarchyLevelMapN31UiT15_
      ld: 0711-319 WARNING: Exported symbol not defined: createAttributeID__28TxsOqStdFormNamingConventionFR9xswstringRC9xswstringT2
      ld: 0711-319 WARNING: Exported symbol not defined: createBooleanListSource__31TxsOqSourceDefinitionControllerFRC10std_vectorXTs_
      ld: 0711-319 WARNING: Exported symbol not defined: createBranch__15TxsOqConnectionFv
      ld: 0711-319 WARNING: Exported symbol not defined: createConstantExpressionHolder__13TxsOqSQLQueryFP18TxsOqSQLExpressionP25TxsOqSQLGenerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createConstantExpression__13TxsOqSQLQueryFiRC36TxsOqDataOrSourceDefinitionListUnionR9xswstringP25TxsOqSQLG
      enerationContext
      ld: 0711-319 WARNING: Exported symbol not defined: createConstantExpression__15TxsOqGroupingIdCFP25TxsOqSQLGenerationContext

      ld: 0711-773 WARNING: Object /opt/oracle/product/11.2.0.1/lib//liboraolap11.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 /opt/oracle/product/11.2.0.1/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
      Symbol was expected to be local. Extra instructions
      are being generated to reference the symbol.
      ld: 0711-773 WARNING: Object /opt/oracle/product/11.2.0.1/lib//libordsdo11.a[mdowd.o], imported symbol ksudbrmseccnt_
      Symbol was expected to be local. Extra instructions
      are being generated to reference the symbol.
      ld: 0711-773 WARNING: Object /opt/oracle/product/11.2.0.1/lib//libordsdo11.a[mdidx.o], imported symbol ksudbrmseccnt_
      Symbol was expected to be local. Extra instructions
      are being generated to reference the symbol.
      ld: 0711-773 WARNING: Object /opt/oracle/product/11.2.0.1/lib//libordsdo11.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 /opt/oracle/product/11.2.0.1/lib//libordsdo11.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 /opt/oracle/product/11.2.0.1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
      Symbol was expected to be local. Extra instructions
      are being generated to reference the symbol.
      ld: 0711-783 WARNING: TOC overflow. TOC size: 219456 Maximum size: 65536
      Extra instructions are being generated for each reference to a TOC
      symbol if the symbol is in the TOC overflow area.

      INFO:--------------------------------------------------------------------------------
      SEVERE:OUI-67204:OPatch Session completed with warnings.


      ANY HELP WOULD BE APPRECIATED
        • 1. Re: Installing PSU APR 2010 for Oracle 11.2.0.1 on AIX 5300-11-02-1007
          769569
          One more thing: When I execute the command $ opatch lsinventory, it does show me that Patch is installed !

          OUTPUT OF THE COMMAND:


          INFO:
          Oracle Home : /opt/oracle/product/11.2.0.1
          Central Inventory : /opt/oracle/oraInventory
          from : /etc/oraInst.loc
          OPatch version : 11.2.0.1.2
          OUI version : 11.2.0.1.0
          OUI location : /opt/oracle/product/11.2.0.1/oui
          Log file location : /opt/oracle/product/11.2.0.1/cfgtoollogs/opatch/opatch2010-04-28_11-19-39AM.log

          INFO:Patch history file: /opt/oracle/product/11.2.0.1/cfgtoollogs/opatch/opatch_history.txt

          INFO:Starting LsInventorySession at Wed Apr 28 11:19:42 EST 2010
          INFO:PatchObject::createPatchObject() Patch location is /opt/oracle/product/11.2.0.1/inventory/oneoffs/9352237
          INFO:PatchObject::createPatchObject() patch location is /opt/oracle/product/11.2.0.1/inventory/oneoffs/9352237
          INFO:Lsinventory Output file location : /opt/oracle/product/11.2.0.1/cfgtoollogs/opatch/lsinv/lsinventory2010-04-28_11-19-39AM.txt

          INFO:--------------------------------------------------------------------------------
          INFO:Installed Top-level Products (1):

          INFO:Oracle Database 11g 11.2.0.1.0
          INFO:There are 1 products installed in this Oracle Home.

          INFO:
          INFO:Interim patches (1) :

          INFO:Patch 9352237 : applied on Tue Apr 27 13:45:53 EST 2010
          Unique Patch ID: 12345730
          Created on 30 Mar 2010, 06:40:56 hrs PST8PDT
          Bugs fixed:
          8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548
          8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974
          7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983
          9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535
          8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705
          8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784
          8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202
          8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328
          8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358
          9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385
          8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237
          8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736

          INFO:
          INFO:
          INFO:--------------------------------------------------------------------------------
          INFO:Finishing LsInventorySession at Wed Apr 28 11:19:43 EST 2010
          • 2. Re: Installing PSU APR 2010 for Oracle 11.2.0.1 on AIX 5300-11-02-1007
            Srini Chavali-Oracle
            Welcome to the forums !

            I have not applied this patch as yet - but this seems to be warnings only, not errors. Pl open an SR with Support to confirm that these warnings are normal.

            HTH
            Srini
            • 3. Re: Installing PSU APR 2010 for Oracle 11.2.0.1 on AIX 5300-11-02-1007
              Srini Chavali-Oracle
              network blip - posted twice

              Edited by: schavali on Apr 27, 2010 10:51 PM
              • 4. Re: Installing PSU APR 2010 for Oracle 11.2.0.1 on AIX 5300-11-02-1007
                user11981603
                Hello,

                The same problems are described in Metalink note 402945.1.:
                ================================================================

                Applies to:

                Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1.0.7
                IBM AIX Based Systems (64-bit)
                Symptoms

                You are trying to install an Interim/One-off Patch on AIX platform.
                You are encountering WARNINGs in the relinking stage of the Patch Apply.

                These are ignorable WARNINGs as discussed in :
                Note 245372.1 - TOC overflow Warning Can Safely Be Ignored

                Further Information:
                While installing One-off patches (except on 8.1.7.4) on an AIX system,
                you may see warning messages similar to the following when re-linking:
                ld: 0711-773 WARNING:
                ld: 0711-783 WARNING:
                ld: 0711-319 WARNING:
                ld: 0711-415 WARNING:
                ld: 0711-224 WARNING:
                ld: 0711-324 WARNING:
                ld: 0711-301 WARNING:
                ld: 0711-345
                These warning messages are not problematic if they are reported during relinking of any binary.