DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: 9i dbua hanging

  1. #1
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102

    9i dbua hanging

    Hi folks. I've an issue where the 9i dbua process seems to hang at the end of the upgrade process (8.1.7 to 9.2.0.5). It appears to be where dbua tries to shutdown and restart the database, after this part of the upgrade log:

    SELECT comp_name, status, substr(version,1,10) as version from dba_registry;
    Oracle9i Catalog Views VALID 9.2.0.5.0
    Oracle9i Packages and Types VALID 9.2.0.5.0
    JServer JAVA Virtual Machine VALID 9.2.0.5.0
    Oracle9i Java Packages VALID 9.2.0.5.0

    4 rows selected.


    /*
    DOC>================================================================
    DOC> The above query lists the components in the database, along
    DOC> with their current version and status. Consult Oracle9i
    DOC> Database Migration for instructions to upgrade any
    DOC> remaining components to the current release:
    DOC>
    DOC> Oracle interMedia
    DOC> Oracle Spatial
    DOC> Oracle Text
    DOC> Oracle Ultra Search
    DOC> Oracle Visual Information Retrieval
    DOC>
    DOC>================================================================
    DOC>*/
    Rem *************************************************************************
    /*
    DOC> END Component Upgrades CMPDBMIG.SQL */
    Rem *************************************************************************
    Connected.
    "
    Connected.
    Connected.
    1
    This is a Solaris 8 system and I have previously upgraded a test system for the same database without any issues. Any ideas gratefully received.
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by KenCunningham
    Hi folks. I've an issue where the 9i dbua process seems to hang at the end of the upgrade process (8.1.7 to 9.2.0.5). It appears to be where dbua tries to shutdown and restart the database, after this part of the upgrade log:

    /*
    DOC>================================================================
    DOC> The above query lists the components in the database, along
    DOC> with their current version and status. Consult Oracle9i
    DOC> Database Migration for instructions to upgrade any
    DOC> remaining components to the current release:
    DOC>
    DOC> Oracle interMedia
    DOC> Oracle Spatial
    DOC> Oracle Text
    DOC> Oracle Ultra Search
    DOC> Oracle Visual Information Retrieval
    DOC>
    DOC>================================================================
    DOC>*/
    Rem *************************************************************************
    /*
    DOC> END Component Upgrades CMPDBMIG.SQL */
    Rem *************************************************************************
    1
    This is a Solaris 8 system and I have previously upgraded a test system for the same database without any issues. Any ideas gratefully received.
    Upgrade failing could be many reasons. Have you set enough space on shared pool, Java pool, system tablespace, RBS tablespace?

    When components are not loading space is the major issue? check.
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    I had something similar, on Solaris - dbua got to the end and then hit an ora-600. Happened every time. I ended up doing the upgrade by hand (at Oracle's suggestion).
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

  4. #4
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Thanks folks. Our vendor also suggests I use the import/export method. Frustrating, however, as dbua worked on the other box. Space isn't an issue - I've sized everything appropriately as far as I can tell.
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    tried running the scipts manually?

  6. #6
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Thanks Davy - I'll be doing the import/export stuff next week and will report back.
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width