Disclaims:

Always study and research the information here first before use! UAYOR!

ORA-20000: Database is not open for MIGRATE. Shutdown and restart using MIGRATE.

How to solve:
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

0 comments:

  © Blogger template 'A Click Apart' by Ourblogtemplates.com 2008

Back to TOP