ORA-20000: Database is not open for MIGRATE. Shutdown and restart using MIGRATE.
ORA-20000: Database is not open for MIGRATE. Shutdown and restart using MIGRATE.
When using the DBCA to create a new database from the starter database, the following error message may occur:
PLS-00302: component 'VALIDATE_COMPONENTS' must be declared
This error can be ignored. However, the @?/rdbms/admin/catpatch.sql script must be run on the newly created database to upgrade it to 9.2.0.6 .
Example:
506 testserver:/home/oracle>sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Tue Apr 21 13:04:58 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
SQL> @?/rdbms/admin/catpatch.sql
DOC> BEGIN CATPATCH.SQL */
DECLARE
*
ERROR at line 1:
ORA-20000: Database is not open for MIGRATE. Shutdown and restart using MIGRATE.
ORA-06512: at line 15
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
507 testserver:/home/oracle>
Solution:
SQL> Shutdown immediate
SQL> startup migrate
SQL> @?/rdbms/admin/catpatch.sql