Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    MetaLib
    Ex Libris Knowledge Center

    Incorrect parameter in Oracle DB installation on some of our customers' sites

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: MetaLib
    • Product Version: 4

    Description:
    Dear MetaLib customers,

    I would like to inform you that the Ex Libris DBA team recently found an incorrect parameter in the Oracle DataBase installation on some of our customers' sites.

    This parameter (log_archive_dest) might affect customers who use Archive backup mode. It should be configured as "/exlibris/oradata/meta4", but in some cases it's incorrectly configured as "@_LOG_ARCHIVE_DEST".

    In order to check whether the parameter is correctly configured on your system, please follow the simple instructions below. In case you see the parameter is incorrectly configured, please submit a Support Incident in the CRM, and we will handle it as soon as possible. Please note that the Oracle user/password will be needed if that parameter would indeed need correction.

    Here are the steps of the check:

    1) Login to your MetaLib server.

    2) In the command line, type the following 4 commands (pressing Enter after each):

    sqlplus $METALIB_ADMIN
    set pause off
    show parameters log_archive_dest
    quit

    3) Correct output looks as follows (note the value in the first line):
    log_archive_dest string /exlibris/oradata/meta4
    log_archive_dest_1 string
    log_archive_dest_10 string
    log_archive_dest_2 string
    log_archive_dest_3 string
    log_archive_dest_4 string
    log_archive_dest_5 string
    log_archive_dest_6 string
    log_archive_dest_7 string
    log_archive_dest_8 string
    log_archive_dest_9 string

    While incorrect output looks as follows:
    log_archive_dest string @_LOG_ARCHIVE_DEST
    log_archive_dest_1 string
    log_archive_dest_10 string
    log_archive_dest_2 string
    log_archive_dest_3 string
    log_archive_dest_4 string
    log_archive_dest_5 string
    log_archive_dest_6 string
    log_archive_dest_7 string
    log_archive_dest_8 string
    log_archive_dest_9 string

    We apologize for the inconvenience. Again, please open a Support Incident in the CRM in case you receive the incorrect output above.

    Resolution:

    • Article last edited: 10/8/2013