2 Replies Latest reply: Dec 31, 2008 5:02 AM by 452455 RSS

    Oracle database 9.2.0.8 patchset upgrade from 9.2.0.3

    452455
      Hi,

      i have a situation where i upgraded the Oracle software with database as per metalink documentation from 9.2.03 to patchset 9.2.0.8 (Oracle9i Patch Set Release 2 (9.2.0.8) Patch Set 7 for HP-UX PA-RISC (64-Bit) ) (README for 4547809 )
      but i could see the $ORACLE_HOME/bin binaries are still at 9.2.0.3, and so v$version dba_registry pointing to same.

      i have pasted few lines of patch installation log from Inventory

      <------snip----------->

      Oracle Universal Installer version is 10.1.0.5.0

      Setting variable 'PREREQ_CONFIG_LOCATION' to ''. Received the value from variable association.

      *** Welcome Page***
      Initializing install inventory
      Setting up install inventory

      *** Specify File Locations Page***
      Setting the 'SourceLocation ( FROM_LOCATION )' property to '/u01/h3a/h3a_ora2/9208/Disk1/stage/products.xml'. Received the value from the UI p
      age.
      Setting the 'OracleHome ( ORACLE_HOME )' property to '/h3a/h3a_ora2/oracle/product/9.2.0'. Received the value from the UI page.
      Setting the 'OracleHomeName ( ORACLE_HOME_NAME )' property to 'OUIHome3'. Received the value from the UI page.
      Warning:*** Alert: You have specified a non-empty directory to install this product. It is recommended to specify either an empty or a non-exi
      stent directory. You may, however, choose to ignore this message if the directory contains Operating System generated files or subdirectories
      like lost+found.
      Do you want to proceed with installation in this Oracle Home? ***
      User Selected: Yes/OK

      Initializing OUI access setup
      Setting variable 'ORACLE_HOME' to '/h3a/h3a_ora2/oracle/product/9.2.0'. Received the value from the UI page.
      Setting the PROD_HOME variable of 'oracle.java.jdbc.thin14_9.2.0.1.0' to '/h3a/h3a_ora2/oracle/product/9.2.0/oracle_java_jdbc_thin14'. Receive
      d the value from the variable calculation.
      Setting the PROD_HOME variable of 'oracle.swd.jre_1.4.2.0.0' to '/h3a/h3a_ora2/oracle/product/9.2.0/jre/1.4.2'. Received the value from the va
      riable calculation.
      Setting the PROD_HOME variable of 'oracle.swd.opatch_10.1.0.5.0' to '/h3a/h3a_ora2/oracle/product/9.2.0/OPatch'. Received the value from the v
      ariable calculation.
      Setting the PROD_HOME variable of 'oracle.swd.oui_10.1.0.5.0' to '/h3a/h3a_ora2/oracle/product/9.2.0/oui'. Received the value from the variabl
      e calculation.
      Setting the PROD_HOME variable of 'oracle.swd.oui.core_10.1.0.5.0' to '/h3a/h3a_ora2/oracle/product/9.2.0/oui'. Received the value from the va
      riable calculation.
      Unable to read /h3a/h3a_ora2/oracle/product/9.2.0/inventory/ContentsXML/comps.xml. Some inventory information may be lost.
      # The patch iSQL*Plus Patch 9.2.0.8.0 has not been selected for installation because the base component is neither installed nor in the stagi
      ng area.
      # The patch oracle.apache.isqlplus 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for installat
      ion.
      # The patch Oracle Text Patch 9.2.0.8.0 has not been selected for installation because the base component is neither installed nor in the sta
      ging area.
      # The patch oracle.cartridges.context 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for instal
      lation.
      # The patch Oracle interMedia Locator Patch 9.2.0.8.0 has not been selected for installation because the base component is neither installed
      nor in the staging area.
      # The patch oracle.cartridges.locator 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for instal
      lation.
      # The patch Oracle JDBC Development Drivers Patch 9.2.0.8.0 has not been selected for installation because the base component is neither inst
      alled nor in the staging area.
      # The patch oracle.java.jdbc.jdbc_dev 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for instal
      lation.
      # The patch JDBC/OCI Common Files Patch 9.2.0.8.0 has not been selected for installation because the base component is neither installed nor
      in the staging area.
      # The patch oracle.java.jdbc.oci_common 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for inst
      allation.
      Performing operation for OUI access setup
      CRS clusterware not found. Defaulting to vendor clusterware.
      Vendor clusterware is not detected.
      This is not a cluster system.
      Node selection page will not be shown.
      Setting variable 'CLUSTER_NODES' to ''. Received the value from a code block.

      *** Select a Product to Install Page***
      Setting the 'TopLevelComp ( ToplevelComp )' property to 'oracle.server, 9.2.0.8.0, >9.2.0.8.0, [ ][OH:2]'. Received the value from the default
      settings.

      *** Select Installation Type Page***
      Setting the 'InstallType ( DEP_MODE )' property to 'Custom'. Received the value from the default settings.
      Setting the 'TopLevelInstallType ( TLDepModes )' property to 'Custom,'. Received the value from the default settings.
      No prerequisite checks specified for this installation.
      # The patch oracle.options.ano.nis 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for installation.
      # The patch could not be found in the staging area.
      # The patch Authentication and Encryption Patch 9.2.0.8.0 has not been selected for installation because the base component is neither instal
      led nor in the staging area.
      # The patch oracle.options.ano.sns 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for installat
      ion.
      # The patch Oracle Wallet Manager Patch 9.2.0.8.0 has not been selected for installation because the base component is neither installed nor
      in the staging area.
      # The patch oracle.options.ano.ssl.owm 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for insta
      llation.
      # The patch Oracle interMedia Client Compatibility Files Patch 9.2.0.8.0 has not been selected for installation because the base component is
      neither installed nor in the staging area.
      # The patch oracle.options.intermedia.imclient.imclicompat 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not bee
      n selected for installation.
      # The patch Oracle interMedia Common Files Patch 9.2.0.8.0 has not been selected for installation because the base component is neither insta
      lled nor in the staging area.
      # The patch oracle.options.intermedia.imcom 9.2.0.8.0, which is part of patch set Oracle 9iR2 Patch Set 9.2.0.8.0 , has not been selected for
      installation.
      # The patch Oracle interMedia Java Advanced Imaging Patch 9.2.0.8.0 has not been selected for installation because the base component is neit
      her installed nor in the staging area.

      <--------------->

      OPatch lsinventory for upgraded ORACLE_HOME returns

      PRODUCT NAME VERSION

      ============ =======

      Installer SDK Component 10.1.0.5.0
      Oracle 9iR2 Patch Set 9.2.0.8.0
      Oracle Universal Installer 10.1.0.5.0

      There are 3 components installed.

      There is no Interim Patch



      any idea what went wrong here?

      regards
      Deepak.