Forum Stats

  • 3,780,652 Users
  • 2,254,421 Discussions
  • 7,879,408 Comments

Discussions

Upgrade from XE10 to XE11

717136
717136 Member Posts: 66
Hello,

i tried to do this as described:

EXPORT:
mkdir /usr/lib/oracle/DUMP_DIR
chown -R oracle:dba /usr/lib/oracle/DUMP_DIR

DUMP_DIR=/usr/lib/oracle/DUMP_DIR
export DUMP_DIR

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus sys/<passwd> as sysdba @gen_inst.sql

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus sys/<passwd> as sysdba @export_data.sql

expdp system/<passwd> full=Y EXCLUDE=SCHEMA:\"LIKE \'APEX_%\'\",SCHEMA:\"LIKE \'FLOWS_%\'\" directory=DUMP_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
expdp system/<passwd> TABLES=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$ directory=DUMP_DIR dumpfile=DB10G2.dmp logfile=expdpDB10G2.log

export_data.sql:
CREATE DIRECTORY DUMP_DIR AS '/usr/lib/oracle/DUMP_DIR';
GRANT read, write ON DIRECTORY DUMP_DIR TO system;
QUIT

This worked, the files are generated.

IMPORT:
mkdir /u01/app/oracle/DUMP_DIR
chown -R /u01/app/oracle/DUMP_DIR
chmod 640 /u01/app/oracle/DUMP_DIR/*.dmp
chmod 644 /u01/app/oracle/DUMP_DIR/*.log

DUMP_DIR=/u01/app/oracle/DUMP_DIR
export=DUMP_DIR

/u01/app/oracle/product/11.2.0/xe/bin/sqlplus sys/<passwd> as sysdba @import_data.sql

/u01/app/oracle/product/11.2.0/xe/bin/impdp system/<passwd> full=Y directory=DUMP_DIR dumpfile=DB10G.dmp logfile=expdpDB10G1.log

/u01/app/oracle/product/11.2.0/xe/bin/impdp system/<passwd> directory=DUMP_DIR TABLE_EXISTS_ACTION=APPEND TABLES=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$ dumpfile=DB10G2.dmp logfile=expdpDB10G1b.log

/u01/app/oracle/product/11.2.0/xe/bin/sqlplus sys/<passwd> as sysdba @install.sql

import_data.sql:
CREATE DIRECTORY DUMP_DIR AS '/u01/app/oracle/DUMP_DIR';
GRANT read, write ON DIRECTORY DUMP_DIR TO system;
QUIT

After the two impdp commands i got two errors:
ORA-39006 internal error
ORA-39213 Metadata processing is not available

What's the solution?

Best regards
AK
«13

Answers

  • Udo
    Udo Member Posts: 1,987
    edited Sep 26, 2011 10:49AM
    Hello Achim,

    this has been a known problem for a while. Try the following workaround in the target instance:
    connect / as sysdba
    execute sys.dbms_metadata_util.load_stylesheets;
    ... and repeat the import afterwards.

    -Udo

    Edited by: Udo on 26.09.2011 16:49
  • 717136
    717136 Member Posts: 66
    edited Sep 26, 2011 11:25PM
    Hello,

    thanks for your fast reply.

    I got an error on missing "kudvrlm.xsl" and that's right,
    i don't have this file. I had zip-file from XE10, but this "kudvrlm.xsl" is missing.

    Where can i get this missing file(s)?

    best regards

    AK

    Edited by: Achim Klausmann on 26.09.2011 17:45

    Edited by: Achim Klausmann on 27.09.2011 05:24
  • Etore Schiavini
    Etore Schiavini Member Posts: 20 Blue Ribbon
    edited Sep 28, 2011 9:57PM
    You can get it (in fact, the entire xsl directory) from another 11gR2 installation on (doesn't matter which edition or OS):

    <ORACLE_BASE>\app\oracle\product\11.2.0\server\rdbms\xml\xsl
  • 717136
    717136 Member Posts: 66
    So i can install 11gR2 with a test installation on WIN7 64b without having a license?

    AK
  • Udo
    Udo Member Posts: 1,987
    edited Sep 26, 2011 11:57PM
    Hello Achim,

    I'm sorry I hadn't tested this before on XE - it was the workaround suggested by MOS to solve that problem. Unfortunately, I couldn't find any xsl on my 11.2 XEs either. It seems to be some missing part similar to a few others reported in the beta forum, e.g. {thread:id=2204216}, {thread:id=2217556}
    I had expected these missing parts to be there in the final release, but apparently, there are still some gaps.
    So the only option left for the moment would be, as suggested by Etore, to take it from some other 11.2 release.

    -Udo

    P.S.:
    So i can install 11gR2 with a test installation on WIN7 64b without having a license?
    The OTN license allows you to install any release for evaluation and development purposes.

    Edited by: Udo on 27.09.2011 05:56
  • orafad
    orafad Member Posts: 8,035 Silver Trophy
    Achim Klausmann wrote:
    ... without having a license?
    Of course, not without a license.

    Before downloading you may enter a license agreement, see e.g. Downloads index page:
    http://www.oracle.com/technetwork/indexes/downloads/index.html

    +"... most come with a _Developer License_ that allows you to ..."+

    Read the OTN Dev license to find out what you can and can't do with the software.
  • 717136
    717136 Member Posts: 66
    Hello,

    ok, i did that:
    Installation WIN7 prof 64b, Installation 11gR2 standard.
    Now i have 179 XSL-Files.

    Should they copied into the path before or after oracle-xe configure ?

    Best regards

    Achim
  • Udo
    Udo Member Posts: 1,987
    Hello,

    I'd try to put them into the path without running the configure again, but just issue the command to load the stylesheets. If this doesn't work something else is missing and it probably wouldn't be worth the effort to start over with the whole instance...

    -Udo
  • 717136
    717136 Member Posts: 66
    Hello,

    i tried to do it again:
    copy the xsl-files to $ORACLE_HOME/rdbms/xlm/xsl

    SQLPlus
    execute sys.dbms_metadata_util.load_stylesheets;

    and got an error on missing file "kupostdt.xsl"

    Where is this file located, i don't have it.

    Do i have to reinstall 11gR2 with enterprise option?
    I did a standard installation.

    Achim
  • 717136
    717136 Member Posts: 66
    edited Sep 28, 2011 4:35PM
    ii searched around the $ORACLE_HOME/rdbms/admin directory

    what about:

    @/u01/app/oracle/product/11.2.0/xe/rdbms/admin/catproc.sql <- this will call the next two ones, please read the comment in catproc.sql
    @/u01/app/oracle/product/11.2.0/xe/rdbms/admin/catdph.sql <- Datapump header
    @/u01/app/oracle/product/11.2.0/xe/rdbms/admin/catdpb.sql <- Datapump package body

    I will try that tomorrow.

    Achim

    Edited by: Achim Klausmann on 28.09.2011 22:33

    Edited by: Achim Klausmann on 28.09.2011 22:34
This discussion has been closed.