OpenVMS: ORA-401 On Startup Upgrade During Migration to 10gR1 (Doc ID 376323.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.3 to 10.1.0.5 [Release 10.1]
HP OpenVMS Alpha
***Checked for relevance on 09-Apr-2013***


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms