Incorrect parameter in Oracle DB installation on some of our customers' sites
- 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