11.2 migration AIX - DST error - ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading
- From: "DIANNA GIBBS" <DIANNA.GIBBS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 09 Apr 2010 14:21:29 -0500
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
</pre> <span style="color: rgb(0, 160, 0); font-weight: bold;">Please consider
the environment before printing this e-mail</span><br />
<br />
<span style="font-size: 8pt;">This e-mail, facsimile, or letter and any
files or attachments transmitted with it contains<br />
information that is confidential and privileged. This
information is intended only for the use of the <br />
individual(s) and entity(ies) to whom it is addressed. If you
are the intended recipient, further <br />
disclosures are prohibited without proper authorization. If you
are not the intended recipient, any <br />
disclosure, copying, printing, or use of this information is
strictly prohibited and possibly a <br />
violation of federal or state law and regulations. If you have
received this information in error, <br />
please notify Children's Medical Center Dallas immediately at
214-456-4444 or via e-mail at <br />
privacy@xxxxxxxxxxxxxx Children's Medical Center Dallas and its
affiliates hereby claim all <br />
applicable privileges related to this information.</span><br />
<br />
</html>
Other related posts:
