Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Cleaning out your libraries for re-running Upgrade Express

    Cleaning out your libraries for re-running Upgrade Express

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph

    Description:
    Per KB 16384-21425, we know that we can run Upgrade Express a second time for our libraries without any problem, but we want to create a "clean" environment, with our libraries erased entirely.

    Note: The only situation we know of where this might be necessary is in a demonstration of Upgrade Express where you want to see what the target version looks like before UE has run at all.

    Resolution:
    Here is an example where we do that for the LAWnn libraries:

    aleph@aleph112(a20_2) LAW01> sqlplus ALEPH_DBA

    aleph_dba@A112_A20> select * from all_users;
    **** Hit return to continue ****

    USERNAME USER_ID CREATED
    ------------------------------ ---------- ---------------
    PWD50 162 05-MAY-09
    LAW60 161 05-MAY-09
    LAW50 160 05-MAY-09
    LAW30 159 05-MAY-09
    EXT02 107 16-FEB-09
    EXT01 106 16-FEB-09
    LAW10 158 05-MAY-09
    LAW01 157 05-MAY-09

    aleph_dba@A112_A20> drop user PWD50 CASCADE;
    aleph_dba@A112_A20> drop user LAW01 CASCADE;
    aleph_dba@A112_A20> drop user LAW10 CASCADE;
    aleph_dba@A112_A20> drop user LAW30 CASCADE;
    aleph_dba@A112_A20> drop user LAW50 CASCADE;
    aleph_dba@A112_A20> drop user LAW60 CASCADE;
    User dropped.

    PWD50 is the pw_library for the LAW libraries. You do *not* want to drop EXT01 or EXT02.

    aleph@aleph112(a20_2) LAW01> cd /exlibris/aleph/u20_2
    aleph@aleph112(a20_2) LAW01> cp -pr alephe alephe.old2
    aleph@aleph112(a20_2) LAW01> cp -pr alephe.orig alephe [This restores the original alephe.]
    aleph@aleph112(a20_2) LAW01> rm -r law50
    aleph@aleph112(a20_2) LAW01> rm -r law01
    aleph@aleph112(a20_2) LAW01> rm -r law10
    aleph@aleph112(a20_2) LAW01> rm -r law30
    aleph@aleph112(a20_2) LAW01> rm -r law60
    aleph@aleph112(a20_2) LAW01> rm -r pwd50


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Cleaning Out Initiator Information from Completed and Closed Order Records
      • Cleaning Temporary files more than x days old/Cleaning log files more than..."
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
      3. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved