-
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.
-
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"
-
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
-
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.
-
tried running the scipts manually?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|