Aleph Installation

Introduction

Perform all AIK steps in the order displayed in the AIK main menu - that is, first complete the functions under Step 1 in the order listed. When those functions are completed, proceed to Step 2, and so forth.

Note: Steps that should be performed by the root or oracle user have a corresponding note. All other steps should be performed as the aleph user.

You can exit the AIK at any stage of the installation. To restart the process, enter the following commands:

cd /exlibris/ftp_from_exlibris/aik ./ikit_menu

A single log file, containing confirmation and feedback on the installation, the status of each step, and reporting errors can be found under:

/exlibris/ftp_from_exlibris/aik/log/aleph_installation_kit.log

The AIK Main Menu

The AIK main menu is used throughout the Aleph installation, outlining the main steps of the installation. The main menu has a header that includes the current date and operating system used. The Aleph directory and the Oracle database fields are populated once the relevant components are installed.

Aleph Installation Kit --------------------------------------------------------------------- Date: Sun Feb 04 14:55:20 IST 2015 OS: Linux Aleph version: 24.00 Aleph directory: Oracle database: --------------------------------------------------------------------- - 0. Update kit parameters - 1. Download software from FTP server - 2. Pre-installation tasks - 3. Oracle database installation and configuration - 4. Third-party products installation - 5. Aleph software installation and configuration - 6. Post-installation tasks Enter key (q to quit)[q]:

Installation Properties

Enter 0 to update the AIK parameters. For example:

Installation Properties: ================================================================= [E]-mail = Avi.Bitter@HotSinger.com [D]ownload directory = /exlibris/ftp_from_exlibris [P]assive ftp = --passive-ftp [A]pplication properties: Installation copy = 1 [O]racle params : Oracle server = il-inst03 Oracle host = il-inst03 Oracle SID = aleph34 Oracle Home = /exlibris/app/oracle/product/19r1 DB Archiving disk = /exlibris DB Sys and Redo disk = /exlibris DB Data files disk = /exlibris Insert the letter in the square parentheses to update, 'q' to quit:

The file contains a list of the properties that you entered at the initial stage of the installation process. Editable options are marked with a letter in brackets. To edit a property, enter the letter of the property you want to edit.

Note: Changing the value of one property can affect the value of other properties.

Step 1: Download Software from FTP Server

The first step in the main menu is to download the software from the FTP site.

Enter 1 to display the Download software from FTP server menu.

Note: Root access is required to perform the download tasks.

Aleph Installation Kit --------------------------------------------------------------------- Date: Sun Feb 04 14:56:47 IST 2015 OS: Linux Aleph version: 24.00 Aleph directory: Oracle database: --------------------------------------------------------------------- 1. Download software from FTP server - 1. Download Aleph software - 2. Download Oracle software - 3. Check if the Aleph software was downloaded correctly - 4. Check if Oracle software was downloaded correctly Enter key (q to quit)[q]:

Download Aleph Software

This utility uses the wget client for downloading Aleph software from the Ex Libris MTP server.

An e-mail message is sent to the address you specify when the MTP download completes. (If you do not see the e-mail in your Inbox, check your spam folder.)

Enter 1 to download the Aleph software. The system prompts for the following:

• target download directory name — The default is/exlibris/ftp_from_exlibris.
• Press Y to use passive FTP.
• e-mail address for the download confirmation message — Enter your e-mail address.

Note: Ex Libris recommends using the suggested defaults wherever possible to avoid changes.

Download Oracle Software

This utility uses the wget client for downloading the Oracle software from the Ex Libris FTP server.

An e-mail is sent to the specified address when the FTP download is complete.

Enter 2 to download the Oracle software. The system prompts for the following:

• target download directory name — The default is /exlibris/ftp_from_exlibris.
• e-mail address for the download confirmation message — Enter your e-mail address. The default is the e-mail address you entered in the previous step.

Check if Aleph Software Was Downloaded Correctly

This utility checks whether or not the Aleph software was downloaded correctly. When complete, an e-mail is sent to the specified address.

This step prompts for the following information:

target download directory name – The default directory is /exlibris/ftp_from_exlibris.

e-mail address for the download confirmation message – The default is the e-mail address entered previously (see Download Aleph Software).

Check if Oracle Software Was Downloaded Correctly

This utility checks to see whether or not the Oracle software was downloaded correctly. When complete, an e-mail is sent to the specified address.

This step prompts for:

• target download directory name – The default directory is /exlibris/ftp_from_exlibris.
• e-mail address for the download confirmation message – The default is the e-mail address entered previously (see Download Aleph Software).
• If you encounter a problem with the download and cannot resolve it, contact your local support office.

Step 2: Pre-Installation Tasks

This menu contains the tasks that must be entered before installation.

Note: Root access is required to perform the pre-installation tasks.

Aleph Installation Kit --------------------------------------------------------------------- Date: Sun Feb 04 14:57:37 IST 2015 OS: Linux Aleph version: 24.00 Aleph directory: Oracle database: --------------------------------------------------------------------- 2. Pre-installation tasks - 1. Pre-installation checks - 2. Inserting listener definition to the /etc/services file as root user - 3. Change system parameters as root user - 4. Create oracle user and dba group as root user - 5. Create aleph user and exlibris group as root user - 6. Create Aleph and Oracle directories as root user - 7. Install COBOL software as root user - 8. Create system auto startup/shutdown script and links as root user - 9. Choose Regional settings Enter key (q to quit)[q]:

Pre-Installation Checks

This step checks whether the server meets the specifications required for Aleph version 24 installation described in the Requirements for Aleph 24 Installation document. Detailed operating system requirements can be found in Operating System Requirements for Red Hat Enterprise Linux.

Contact your local system administrator if the following message is displayed after running the pre-installation checks:

-------FAILED------- Error: The pre-installation checks has failed

Detailed information about faults found during the pre-installation checks are located in /exlibris/ftp_from_exlibris/aik/log/aleph_installation_kit.log and are also sent to you by e-mail. Review all lines marked as FAULT.

Inserting Listener Definition to the /etc/services File as root User

This step inserts the following string into the /etc/services file, if required:

listener 1521/tcp # Oracle listener

Change System Parameters as root User

This step checks the system parameters in the system configuration file.

Open a new session on your server as the root user and check that the system variables in the configuration file include the parameters below:

The following system parameters are a required minimum. They can be changed later according to the size of the DB on the server.

• Linux Servers — Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following. Include lines only for the kernel parameter values that you want to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the minimum value, then specify the larger value:

fs.file-max = 65536 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576

Enter the following command to change the current values of the kernel parameters:

# /sbin/sysctl -p

• Sun Solaris 10 and 11 – Add the following parameters:
  • projadd group.dba
  • projmod -s -K "project.max-shm-memory=(privileged,10GB,deny)" group.dba

Create Oracle User and DBA Group as root User

This step creates the dba group and Oracle 19c oracle user with the user home set to /exlibris/app/oracle/product/19r1 and user shell set to /bin/csh.

The name of new oracle user must contain only alphanumeric characters. Alphabetic characters must be lowercase. When creating the new user for Oracle 19c, the utility prompts for a new UNIX password. Set the password accordingly to your password policy on site.

Note: Due to the Oracle 12 security change, the Oracle's database passwords are now case sensitive. The upgrade of Aleph 24 version automatically changes the database passwords to uppercase. After the upgrade to Aleph 24 is completed, the passwords can either stay uppercase (as a result of the upgrade process) or be changed according to your security policy.

Create aleph User and exlibris Group as root User

This step creates the exlibris group and the aleph user with the user home set to /exlibris/aleph and the user shell set to /bin/csh.

If the aleph user already exists, make sure its home directory is set to /exlibris/aleph by running the following command:

echo ~aleph

If the home directory for this user is not /exlibris/aleph, delete the user and then re-run this step to recreate it with the correct definitions.

When creating the new aleph user, the utility prompts for a new UNIX password. Set the password accordingly to your password policy on site.

Create Aleph and Oracle Directories in the Disk /exlibris as root User

This step prompts you for the following:

• The installation type. Select SW_ONLY if the database already exists or will be installed on a remote server. Select DB_ONLY when Aleph 24 SW exists or will be installed on a remote server. If you select ALL or DB_ONLY, you are also prompted for database datafile locations.
• The database disk location for archiving [/exlibris]
• The database disk location for redo files [/exlibris]
• The database disk location for data files [/exlibris]
• For example:
• The database disk location for archiving [/exlibris] /exlibris1
• The database disk location for redo files [/exlibris] /exlibris2
• The database disk location for data files [/exlibris] /exlibris1

Note: Directories for DB installation can be installed on three different mount points.

This step creates the following directories:

Directories

Directory	Permissions
/exlibris1/oradata	oracle:dba permissions
/exlibris2/oradata	oracle:dba permissions
/exlibris1/oradata	oracle:dba permissions
/exlibris/app/oracle/product	oracle:dba permissions
/exlibris/aleph	aleph:exlibris permissions
/exlibris/aleph/ora_aleph	aleph:exlibris permissions
/exlibris/aleph/backup_temp	aleph:exlibris permissions
/exlibris/tmp	aleph:exlibris permissions
/exlibris/startup	aleph:exlibris permissions
/exlibris/product	aleph:exlibris permissions

Install COBOL Software as root User

This step prompts you to enter the location for the third-party product distribution package (default is /exlibris/ftp_from_exlibris).

Linux Servers — COBOL Server Express 5.0 is installed.

If Cobol 4.0.0 is already installed on the server, you are prompted to confirm the upgrade. Upgrading is highly recommended but not mandatory.

If another applications installed on the server is using Cobol 4.0.0, you need to link that application to the new Cobol version. For instructions, see Relink Other Products/Copies to New Cobol.

Create System Auto Startup/Shutdown Script and Links as root User

This step creates the main startup/shutdown script in /etc/init.d/exlibris, if required.

Required links for automatic startup and shutdown of Aleph and the database (when rebooting) are also created.

Note: If the startup mechanism already exists, AIK only updates files in the /exlibris/startup
directory and checks if relevant files and links in the system directories exist.

Choose Regional Settings

This step prompts you to enter information concerning additional languages to install (fre/ger/ita/dan/swe):

• Should the selected language be the main language [Y/n]
• Do you wish to install Aleph regions [Y/n]?
  • If you press y, you are asked to choose the region name:

    Please choose the region you wish to install:Insert e for elib (or q to quit)

  • If you press n, the elib region is deleted.

Note: The Aleph Region (ELIB) functionality is relevant for Swedish or Danish customers only. Press n if the installation is not for Swedish or Danish customers.

Step 3: Oracle Database Installation and Configuration

Note: You must run step Extract Oracle Software as root User as the root user. All later steps can use either the oracle11 user or the root user.

Aleph Installation Kit --------------------------------------------------------------------- Date: Sun Feb 04 14:57:50 IST 2015 OS: Linux Aleph version: 24.00 Aleph directory: Oracle database: --------------------------------------------------------------------- 3. Oracle database installation and configuration - 1. Extract Oracle software - 2. Create listener.ora and tnsnames.ora file * 3. Install database - 4. Check connection to the database via listener * 5. Create Oracle start/stop scripts(only on Dedicated Oracle Server) Enter key (q to quit)[q]:

Extract Oracle Software as root User

This step prompts you to enter the location of the Oracle 19c software distribution package files (default is /exlibris/ftp_from_exlibris).

This step extracts the Oracle software to the following directory:

/exlibris/app/oracle/product/19r1

Install Database

This step prompts you to enter the following parameters:

• location of the database installation script files — The default is

/exlibris/ftp_from_exlibris.

• location of the database media files — The default is

/exlibris/ftp_from_exlibris.

• name of the database you want to install —The default is aleph34.
• confirmation of the DB files distribution:
  • location of the database archive files [default is /exlibris]
  • location of the database system files [default is /exlibris]
  • location of the database data files [default is /exlibris]

The following is an example screen shot:

Install database Please enter the location of the db_copy scripts [/exlibris/ftp_from_exlibris] : Please enter the location of the db files [/exlibris/ftp_from_exlibris] : Please enter the name of the database, no longer than 8 chars [aleph34]: According to your info Data-Base will be installed on the following: for each value, enter new value or confirm Archiving [/exlibris] : Redo logs and System files [/exlibris] : Data files [/exlibris1] : Installing database ... please wait ...

Create listener.ora and tnsnames.ora Files

This step adds the created database definitions to the listener.ora and tnsnames.ora files.

If this is a remote DB, you are prompted for the following:

Enter the Oracle host [<FQDN>]

Enter the Oracle SID [aleph34]

Start Up Oracle Listener

This step starts up the Oracle 19c listener.

If the Oracle 19c listener is already running (for example, if other Ex Libris applications are running on this server), instructions for shutting down the running listener are provided.

Note: Shutting down the Oracle 19c listener results in a short downtime for all applications on this server that are running Oracle.

The following procedure should be used if there is a listener already running:

1. Log on to the server as the running listener user and type:

lsnrctl stop

The AIK menu takes you through the next steps:

2. Do not close the existing window. Open a new terminal window. In the second window, perform a shutdown of the other Ex Libris applications on the server that are using currently running listener (using a standard shutdown procedure for each application).
3. In this additional terminal window, shut down the currently running Oracle listener using UTIL O/2 or standard utility for listener shutdown (as oracle, lsnrctl stop).
4. In the first terminal window, re-run this procedure.
5. In the additional terminal window, start up the other Ex Libris applications on this server that were shut down (using the standard startup procedure for each application).

Note: Once Oracle 19c is started, all applications running Oracle on this server will operate on the new Oracle 19c listener.

Check Connection to the Database Via Listener

This step checks the connection to the created database via the listener.

Note: Listener status is available after at least two minutes have passed since the previous step was executed.

Create Oracle Start/Stop Scripts (Only on Dedicated Oracle Server)

Creating start/stop scripts should only be done on the Oracle server. If the server is both the Aleph server and the Oracle server, the Start/Stop scripts are supplied by the AIK and do not need to be created.

Increase Tablespace Size for Customer Databases

The Aleph Installation Kit provides databases with minimal tablespace sizes. Some of these tablespaces should be increased for normal Aleph functionality. The following table contains the recommended sizes for TEMP and UNDO tablespaces:

Tablespace Size Recommendations

DB Size	Tablespace Size
	UNDO	TEMP
DEMO	500MB	1GB
SMALL	1GB	2GB
LARGE	2GB	4GB

Increase the tablespace size with the Aleph UTIL O/13/2 utility. For more information on UTIL O, refer to the Aleph System Administration Guide.

Note: To increase the performance of the Oracle database, adjust the Oracle SGA size for the created database. For more information, see Oracle SGA Sizing.

Step 4: Third-Party Product Installation

Aleph Installation Kit --------------------------------------------------------------------- Date: Sun Feb 04 14:58:24 IST 2015 OS: Linux Aleph version: 24.00 Aleph directory: Oracle database: --------------------------------------------------------------------- 4. Third-party product installation - 1. Extract binary product package Enter key (q to quit)[q]:

Extract Binary Product Package

The utility installs all relevant third-party products under the /exlibris/product directory.

It first prompts you to enter the location of the third-party product distribution package files. The default location is /exlibris/ftp_from_exlibris.

Installing /exlibris/product directory Please enter the location of the Aleph software media files [/exlibris/ftp_from_exlibris] : Installing /exlibris/product ... please wait ... /exlibris/ftp_from_exlibris/aik INFO: Extracting files... INFO: relocating product dirs... INFO: apache-ant-1.6.1 INFO: apache-tomcat-5.5.25 INFO: db-4.5.2 2 INFO: gnu_ghostscript-8.15 INFO: httpd-2.0.61 INFO: ImageMagick-6.4.1 INFO: jakarta-tomcat-5.0.25 INFO: jasper-1.900.1 INFO: jdk1.5.0_14 INFO: jpeg2000.sdk.3.18 INFO: jpeg-6b …………. …………….. ……………….. …………………. INFO: libpng-1.2.18 INFO: libxml2-2.6.29 INFO: libxslt-1.1.21 INFO: linklist INFO: make-3.80 INFO: md5 INFO: openssl-0.9.8g INFO: patch-2.5 INFO: perl-5.8.8 INFO: saxon INFO: tar-1.15.1 INFO: tiff-3.8.2 INFO: wget-1.9 INFO: bin/shutdown.sh INFO: bin/startup.sh INFO: bin/tar INFO: bin/wget INFO: Fixing product permissions INFO: Erasing temporary product dir INFO: Third party product installation done The binary product package was extracted to the /exlibris/product Press any key to continue

Step 5: Aleph Software Installation and Configuration

For a completely new installation of Aleph, you must run the first step (Extract Aleph software) as user root.

If the Aleph installation exists on the same server, this step can be performed as user aleph.

The rest of the steps can be performed as user aleph or continued as user root.

Aleph Installation Kit --------------------------------------------------------------------- Date: Sun Feb 04 14:58:39 IST 2015 OS: Linux Aleph version: 24.00 Aleph directory: Oracle database: --------------------------------------------------------------------- 5. Aleph software installation and configuration - 1. Extract Aleph Base - 2. Aleph software configuration - 3. Update license - 4. Install Service Pack - 5. Relocate alephe directory - 6. Update auto startup/shutdown script Enter key (q to quit)[q]:

Extract Aleph Base

This step has two phases:

• The first prompts you to enter the:
  • location of Aleph software files [default is /exlibris/ftp_from_exlibris]
  • copy number of Aleph installation [default 1]
• The second phase prompts for selecting cataloging formats. You can choose from the following [mab, uni, usm] or no default. At least one must be chosen. When installing more than one format, enter each one in a different line (with ENTER between formats). See the following example:

Please choose format, insert preferable one first, the available Formats are: mab,uni,usm,dan,swe:(q to quit) usm Please choose format, insert preferable one first, the available Formats are: mab,uni,usm,dan,swe:(q to quit) uni Please choose format, insert preferable one first, the available Formats are: mab,uni,usm,dan,swe:(q to quit) q

Selecting all three is also acceptable.

Important:The first format entered is the main format of the installation.

Aleph Software Configuration

This step prompts you to enter:

• The server WWW server name (FQDN)
• The Oracle server short hostname

Update License

This step asks the installer to update the Aleph 24 license files using the UNIX vi text editor.

The license files are located at:

• /exlibris/aleph/ a24_< slot>/alephe/tab/license
• /exlibris/aleph/a24_<slot>/alephe/tab/license.www_x

This is a mandatory step. If it fails, do not continue with the installation.

Install Service Pack

This step installs the Aleph 24 Service Pack (if applicable). It prompts you to enter the location of the Aleph Service Pack distribution package files. The default is /exlibris/ftp_from_exlibris.

A failure message may be displayed during SP installation if the installed version is equal or higher than the SP package. This is not actually an installation failure.

For example:

Error: Your Service Pack level is 2261. sp.utility not found. Exiting. Error: failed to install the service pack

Relocate alephe Directory

This step:

• deletes unnecessary language files
• deletes unused DB users, according to the selected formats
• relocates the alephe directory and creates the u tree

Update Auto Startup/Shutdown Script

This step creates the startup scripts and the init.dat file under the /exlibris/startup directory.

Step 6: Post-Installation Tasks

This menu contains the post-installation tasks.

Aleph Installation Kit --------------------------------------------------------------------- Date: Wed May 17 22:03:38 IDT 2017 Server: Operating system: Linux Aleph version: 24 Aleph directory: Oracle version: Oracle database: --------------------------------------------------------------------- - 1. Update aleph user login menu - 2. Run test compilation - 4. Startup Aleph software * 5. Install security fix Enter key (q to quit)[q]:

Update aleph User Logon Menu

This step adds the newly installed Aleph software to the aleph user login menu.

The files /exlibris/aleph/def_aleph.dat and /exlibris/aleph/def_versionare updated.

Run Test Compilation

This step checks if the installed Aleph software is configured correctly and is ready for future Aleph 24 Service Pack installations.

Startup Aleph Software

This step starts Apache and the Aleph 24 software.

Install Oracle Security Fix

This step installs the fix for Oracle Security Aleph CVE-2012-1675. For more infomration about the alert and the fix, refer to the Oracle Security Alert CVE-2012-1675 Implementation Clarifications for Automatic Fix document locates on the Documentation Center at Cross-Product > Technical Documentation > Oracle.

Consult the document before running this step.

Note: The fix implementation influences all applications and databases installed on the same server. Read the document carefully before implementing the fix.