mtownbound
Technical User
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!!!
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!!!