RE: 11.2 migration AIX - DST error - ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <DIANNA.GIBBS@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Apr 2010 13:46:27 -0600
Have you checked MOS 977512.1?
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DIANNA GIBBS
Sent: Friday, April 09, 2010 1:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 11.2 migration AIX - DST error - ORA-56920: a prepare or
upgrade window or an on-demand or datapump-job loading
Migrated database from 11.1.0.7 to 11.2. During DST steps
have encountered this error. Error is documented but cannot
determine how to get past it. Any ideas?
From doc:
error if a previous (prepare) window was not ended:
SQL> EXEC DBMS_DST.BEGIN_UPGRADE(11);
BEGIN DBMS_DST.BEGIN_UPGRADE(11); END;
*
ERROR at line 1:
ORA-56920: a prepare or upgrade window or an on-demand or datapump-job
loading
of a secondary time zone data file is in an active state
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 1054
ORA-06512: at line 1
Please consider the environment before printing this e-mail
This e-mail, facsimile, or letter and any files or attachments
transmitted with it contains
information that is confidential and privileged. This information is
intended only for the use of the
individual(s) and entity(ies) to whom it is addressed. If you are the
intended recipient, further
disclosures are prohibited without proper authorization. If you are not
the intended recipient, any
disclosure, copying, printing, or use of this information is strictly
prohibited and possibly a
violation of federal or state law and regulations. If you have received
this information in error,
please notify Children's Medical Center Dallas immediately at
214-456-4444 or via e-mail at
privacy@xxxxxxxxxxxxxx Children's Medical Center Dallas and its
affiliates hereby claim all
applicable privileges related to this information.
Other related posts:
