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

Create Table

Oracle® Database SQL Language Reference
11g Release 1 (11.1)

Part Number B28286-05


http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_7002.htm




CREATE TABLE USER.TABLE_NAME
(
RECORD_KEY NUMBER NOT NULL,
JOB_NO NUMBER NOT NULL,
USERNAME VARCHAR2(300 BYTE),
USER_ACTION VARCHAR2(100 BYTE),
ACTION_DATE DATE
)
TABLESPACE USER_TBL
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;

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

Back to TOP