OpenVMS: ORA-401 On Startup Upgrade During Migration to 10gR1
(Doc ID 376323.1)
Last updated on APRIL 16, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.3 to 10.1.0.5 [Release 10.1]Oracle 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 perform a manual migration of an 8.1.7.4 database to 10.1.0.3, STARTUP UPGRADE fails:
When compatible = 10.0.0:
SQL> STARTUP UPGRADE
ORA-00401: the value for parameter compatible is not supported by this release
When compatible = 8.1.7.4.0:
SQL> STARTUP UPGRADE
ORACLE instance started.
Total System Global Area 247261064 bytes
Fixed Size 100232 bytes
Variable Size 226402304 bytes
Database Buffers 20480000 bytes
Redo Buffers 278528 bytes
Database mounted.
ORA-02288: invalid OPEN mode
SP2-1500: STARTUP with UPGRADE only valid with Oracle 9.2 or greater
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 |
| Cause |
| Solution |
| References |