Ora-00443 database fails to start during startup upgrade
(Doc ID 601435.1)
Last updated on AUGUST 01, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
HP OpenVMS Alpha
Symptoms
When attempting to startup upgrade an 8.1.7.4 database under 10.2.0.2, an ora-443 error is returned
and the database fails to start.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jun 3 17:02:54 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup upgrade
ORA-00443: background process "MMON" did not start
The alert log shows"
3-JUN-2008 16:07:32.43:
Process startup failed, error stack:
RECO started with pid=9, OS id=20c004f2
3-JUN-2008 16:07:32.52:
Errors in file $1$DGA2000:[ORACLE10202.ADMIN.XYZBASE.UDUMP]TEST1_XYZ_FG_ORACLE_000.TRC;:
ORA-27300: OS system dependent operation:skgpspawn_error failed with status: 10804
ORA-27301: OS failure message: error 10804
ORA-27302: failure occurred at: skgpspawn3
3-JUN-2008 16:07:32.52:
Process MMON died, see its trace file
USER: terminating instance due to error 443
Instance terminated by USER, pid = 20c004ea
The associated trace file shows the following information:
KSTDUMP: In-memory trace dump
TIME:SEQ# ORAPID SID EVENT OP DATA
========================================================================
7063BE0D:0000008C 399 0 10254 40 KSBS1P: spawn succeeded ospid = 54945508
6
7063BE0D:0000008D 399 0 10254 50 KSBS1P: out of loop: process is up and r
unning
7063BE0D:0000008E 399 0 10254 34 KSBS1P: process USER trying to start bac
kground DBW1
7063BE0D:0000008F 399 0 10254 36 KSBS1P: process DBW1 already running or
not enabled
7063BE0D:00000090 399 0 10254 34 KSBS1P: process USER trying to start bac
kground DBW2
7063BE0D:00000091 399 0 10254 36 KSBS1P: process DBW2 already running or
not enabled
7063BE0D:00000092 399 0 10254 34 KSBS1P: process USER trying to start bac
kground DBW3
7063BE0D:00000093 399 0 10254 36 KSBS1P: process DBW3 already running or
not enabled
7063BE0D:00000094 399 0 10254 34 KSBS1P: process USER trying to start bac
kground DBW4
7063BE0D:00000095 399 0 10254 36 KSBS1P: process DBW4 already running or
not enabled
7063BE0D:00000096 399 0 10254 34 KSBS1P: process USER trying to start bac
kground DBW5
Changes
Attempting to startup upgrade a database for upgrade from 8.1.7.4 to 10.2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |