Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

9.2.0.7 Catpatch.sql Hangs

Status
Not open for further replies.

mtownbound

Technical User
Jan 28, 2002
293
US
Windows 2000
9.2.0.1


I've applied the 9.2.0.7 to my db successfully, but when I run catpatch.sql in migrate mode, the system gets to a certain point and hangs. I thought maybe since the db was a 15G db restored from a cold backup that maybe it was a db size issue, but I let it run for well over 30 hours and no dice. If I reboot the server to see if it processed, this is what I get:

SQL> column comp_id format a15
SQL> column status format a10
SQL> column version format a10
SQL> column comp_name format a35
SQL> select comp_id, status, version, comp_name from dba_registry order by 1;

COMP_ID STATUS VERSION COMP_NAME
--------------- ---------- ---------- -----------------------------------
AMD INVALID 9.2.0.1.0 OLAP Catalog
APS LOADED 9.2.0.1.0 OLAP Analytic Workspace
CATALOG VALID 9.2.0.1.0 Oracle9i Catalog Views

CATJAVA VALID 9.2.0.1.0 Oracle9i Java Packages
CATPROC INVALID 9.2.0.1.0 Oracle9i Packages and Types
CONTEXT VALID 9.2.0.1.0 Oracle Text
JAVAVM VALID 9.2.0.1.0 JServer JAVA Virtual Machine
ODM LOADED 9.2.0.1.0 Oracle Data Mining
ORDIM LOADED 9.2.0.1.0 Oracle interMedia
OWM VALID 9.2.0.1.0 Oracle Workspace Manager
SDO LOADED 9.2.0.1.0 Spatial

COMP_ID STATUS VERSION COMP_NAME
--------------- ---------- ---------- -----------------------------------
WK VALID 9.2.0.1.0 Oracle Ultra Search
XDB INVALID 9.2.0.1.0 Oracle XML Database
XML VALID 9.2.0.2.0 Oracle XDK for Java
XOQ LOADED 9.2.0.1.0 Oracle OLAP API

15 rows selected.


However, if I create a new empty 9.2.0.1 db, I can patch that to 9.2.0.7 and run catpatch with no problems. I've upgraded before with no issues, so I don't know what the problem is now. Thanks for any help!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top