The procedures in this document cover:
If there is already a LeasePak installation on the Application host, the installation procedure is as described here; if the database system is already installed on the DBMS host, it is recommended that the administrator review the preparation sections of this document to insure that all required items are in order.
Once LeasePak and the database system are installed, the administrator should consult LeasePak Server Configuration and Maintenance to complete the tasks to bring LeasePak to a usable level.
If there is an existing LeasePak installation on the same or different hosts, the document LeasePak Server Upgrade and Conversion should be consulted for the procedures for transferring the data and settings from the existing installation into the new installation of LeasePak v76a.
System Requirements
Procedure Overview
Application host Preparation
OS Verification
Groups, Users, Devices, and Filesystems
LeasePak and Queue Manager Installation Directories
LeasePak Uses Vanilla "C" locale
Temporary License file
DBMS Host Preparation
DBMS Installation Overview
SAP ASE 16.0 on Linux RHEL7
Additional Preparation
Linux Preparation Changes Required in RHEL7
Preparation Checklist
LeasePak License File
LeasePak SETUP Program
SETUP Options
SETUP Questions
- Instance Name
- Server Name
- Queue Manager
- DBMS configuration
- Oracle configuration
- Sybase configuration
- Required Leasepak & DBMS roles
- Leasepakd daemon configuration
- mPowerd daemon configuration
Running SETUP: Screen Output and Annotations
- Installation start
- Clean Up Previous Install - Queue Manager
- Clean Up Previous Install - System Areas
- Clean Up Previous Install - Top Directory
- Perform the Interview
- Installation of the Queue Manager
- Installation of the Build
- Auto deployment of LeasePak on server
- Installation of the license file(s)
- Securing the LeasePak Instance
- Spooler and Temporary Directories
- The Configuration Generator cfg_gen
- Registering the Release Instance
- Creating the init and internet services
- Creating the $SRVADM user
- Creating adm_syb and/or adm_ora
- Securing the LeasePak Instance (Final)
Post-SETUP Tasks
The administrator should review the System Requirements before beginning the installation process to ensure that the platform meets the minimum requirements for LeasePak 7.6a.
/tmp
directory.SETUP
program.Operating System |
Verification Command |
Required OS Version |
Additional Information |
Supported DBMS Versions |
---|---|---|---|---|
Linux | uname -r | Minimum kernel version 2.6.32 | RHEL 7.7 64-bit RHEL 6.8 64-bit |
Oracle 19c SAP ASE 16.0 |
Refer to the document User Accounts for a complete discussion of LeasePak Users, Groups, and related topics. The following tables only enumerate the accounts required for installation without much discussion, which instead may be found at the above link.
Parameter or Environment Variable – this refers to names by which some entities are referred to within the LeasePak environment, in this documentation and often by NETSOL staff and users, and in which the name of the entity is stored. Not every entity has an environment variable; in these cases this item is left blank.
Parameter | Description | Suggested Value |
---|---|---|
$NSTGROUP | LeasePak users' group; the OS group that all LeasePak users must have as their primary group. | nst |
Oracle DBMS primary installation group | orainv | |
Oracle DBMS secondary installation group | oradba | |
Sybase DBMS installation group | sybase |
Linux administrators: The primary group of all LeasePak users must be the
$NSTGROUP
group. By default, Red Hat will create an individual group for each user; the administrator must either turn this feature off before creating users or turn it off for each LeasePak user account created, or later change the primary group of the LeasePak users to $NSTGROUP
.
The OS file
/etc/group
stores the names of the OS groups. In the case of secondary groups, sometimes called supplemental groups, the membership of a user in a group as a secondary group is determined by the user's name being listed after the group name in /etc/group
. However, this is not so for primary groups; primary group membership is determined by placing the GID in the group field of the user's entry in the /etc/passwd file
.
Parameter | Description | Suggested Name | Group(s) |
---|---|---|---|
Oracle DBMS installation user; Oracle software owner |
oracle | orainv (primary)oradba (secondary) |
|
Sybase DBMS installation user; Sybase software owner |
sybase | sybase | |
$NSTADMIN | LeasePak Release Administrator | nsadm76a | $NSTGROUP |
$NSTDBA | LeasePak Database Administrator | nsdba76a | $NSTGROUP |
$NSTADMIN
and $NSTDBA
: These are highly specialized accounts. Their environment variables should always point to the administrative environment (adm_ora
or adm_syb
) where SETUP
initially placed them. Do not change the environment for either of these accounts manually or by using change_env or set either of them up as LeasePak users.
Because these accounts must remain as configured by SETUP
, NETSOL strongly recommends that separate $NSTADMIN
and $NSTDBA
users be set up for each LeasePak release, and that they follow a naming convention that embeds the LeasePak release version in the user names.
CD-ROM Device
NETSOL recommends that the CD-ROM device be attached directly to the application host (not over a network) to avoid problems where the directory paths might undergo unexpected case translation.
If the administrator prefers, the contents of the distribution CD or of the distribution archive downloaded from NETSOL may be copied into an application host directory, and that directory then used in lieu of using an actual CD, as a virtual CD or pseudo-CD, as it were.
OS Typical Path Linux /mnt/cdrom Virtual CD: Each platform
requires about 300MB of space/shipcd
mkdir /opt/shipcd
ln -s /opt/shipcd /shipcdFilesystem Sizes
The following filesystems should already exist on the Application host or on the DBMS host:
Home directory – standard part of all supported operating systems. Each LeasePak user has a directory under /home on the application host. Parameter Comments Values
(Path values not optional)Path /home Size Calculate from numbers and sizes of user-generated reports plus an allowance for leasepak_error.log
200 MB minimum;
4 GB normal
Temporary directories – standard parts of all supported operating systems. Parameter Comments Values
(Path values not optional)Path Used extensively by the NETSOL Utility Scripts, and by some LeasePak reports, and the Queue Manager. /tmp Size 1.2 GB minimum;
2 GB normalPath Potential extensive use by the Queue Manager on Linux, and by some LeasePak processes.
Part of the/var
filesystem/var/tmp Path Potentially used by the Queue Manager on Linux.
Part of the/var
filesystem/var/spool Size /var filesystem 1.2 GB minimum;
2 GB normal
Swap partition – this is part of the standard OS install. Not optional. Parameter Comments Values
(Path values not optional)Size 3 times physical memory is typical;
40MB per concurrent LeasePak connection
Beginning with v76a on Linux, NETSOL consolidated some of the directory structures used to install LeasePak and its Queue Manager. Where before two directories—indeed two filesystems—were recommended, NETSOL now recommends one.
The diagram below depicts this new structure. Bold items are shell environment variable references to the various directories or directory components. Dotted lines ... and / connect each reference to the component or directory it names:
/ | opt.......................$EFSDIR | nst.......................$NSTDIR | +--------------+--------+------+ | | | | | .........|........|......|........$QMPPATH | / | | | | / | .......|......|........$TOPDIR | / |/ | | qm_${INST_ID}76a v76a log cst.......$CSTDIR | | | .............................|........$QMDIR |/ | qm_3_32 +-----+-----+ | | 7.60.8765 7.60.7654
The rules for the layout are:
$NSTDIR
is central. NetSol suggests naming it nst
but that is
optional.
$NSTDIR
's parent directory is $EFSDIR
, the
External File System (meaning external to LeasePak)
$EFSDIR
cannot be /
(root
).
$TOPDIR
's parent directory is $NSTDIR
. $TOPDIR
must
still be the LeasePak release version, as it has always been.
$QMPURPOSE
$QMPURPOSE
is qm_
${INST_ID}
76a
, for example
qm_prod76a
$TOPDIR
is $QMPPATH
, the Queue Manager
Parent Path. $QMPPATH
consists of $NSTDIR/$QMPURPOSE
.
$QMRELS
is used frequently in this document and in the LeasePak
administration scripts, and is equal to qm_
+$QM_VERSION
. In
v64a and above, then, $QMRELS
will be qm_3_17
or qm_3_32
. See
LeasePak Server and Queue Manager Directories
$QMPPATH
is $QMDIR
, which is $QMPPATH/$QMRELS
.
$TOPDIR
is $CSTDIR
, which has a child directory for
each build attached to any of the $TOPDIR
s release instances under
$NSTDIR
.
$NSTDIR
must follow the
Queue Manager naming restrictions: lower case alpha, digits, and
underscore only are allowed. No directories with . (period) or
- (hyphen) in
their names are allowed.
Changes to the Queue Manager in v62a and Before: Beginning in Version 5.3a, Queue Manager self configures, leaving only the establishment of queues, printers, and print queues for the administrator.
The most immediate difference is that in the more recent releases, the SETUP
program, once the Queue Manager software is installed, calls a special version of the Queue Manager Config
file, which obtains parameters from the execution environment and fully parameterizes a clone of itself. There is no editing of the Config
file required to set parameters such as Config:SYSTEM
and Config:MAXDEV
, etc.
Beginning with Version 6.2a on Linux, the Queue Manager temporary directory and the Queue Manager spool directory are site-configurable; the administrator can select between two filesystem locations for each of these directories. The choices for location of the temporary directory are /var/tmp
(recommended) and /tmp
. The choices for location of the spool directory are /var/spool
(recommended) and $QMDIR/spool
. The final component after /var/tmp
, /tmp
, and /var/spool
is $QMPURPOSE, or qm_${INST_ID}76a
.
Being hierarchical, the
$NSTDIR
directory structures have many parent/child relationships, which complicate the documentation of the layout. The following tables attempt to explain the relationships and terminology of the directories. Six tables follow:
- Parameters and Paths – gives the parameter names for the directories and directory components as used in the NetSol Utility Scripts
- Queue Manager Versions by Platform – gives the supported Queue Manager version for each supported platform
- Standard Filesystems – gives the filesystem types to use for LeasePak for each supported platform
- Filesystem Layouts – provides guidance on how to map the $NSTDIR directory structures to several different-sized sets of filesystems
- Creating and Provisioning – provides details on how to set up the various directories, who is responsible for doing so, and whether the information needed is provided directly by the operator running the SETUP program
- Init and Internet Services – provides a summary of the services potentially installed by SETUP, their names, locations and purpose
Parameters and Paths
Parameter Purpose Suggested Name(s) Notes $EFSDIR A file system that holds non-OS-provided software packages /opt Cannot be /
$NSTDIR Holds NetSol Technologies products $EFSDIR/nst nst
is recommended$NSTDIR/log Holds log files associated with LeasePak's init services
$NSTDIR/log Used by all releases in $NSTDIR
$TOPDIR Holds the Server instance of a LeasePak release $NSTDIR/v76a v76a
is required$CSTDIR Holds the End-User Customized Code Objects $NSTDIR/cst cst
is recommended$QMPURPOSE A component in names describing the Queue Manager and connecting it to a LeasePak instance Linux: qm_${INST_ID}76aComponent value formation is fixed $QMRELS A component in path names for Queue Manager instances connected to LeasePak; specifically the final component of the path where the Queue Manager software and configuration is stored. Provides a clearly delineated division between different versions of the Queue Manager software qm_$QM_VERSION Component value formation is fixed $QMPPATH This is the path at which the $QMRELS
(see above) is located holding the Queue Manager softwareLinux: $NSTDIR/$QMPURPOSEMay be overridden by operator $QMDIR Holds the Queue Manager software and configuration $QMPPATH/$QMRELS Path formation is fixed $SYSTMPDIR System directory that holds temporary files for many applications Linux: /var/tmpor/tmpLinux: Choice between two system temporary directories$QMTMPDIR Directory used by the Queue Manager to hold its many temporary files $SYSTMPDIR/$QMPURPOSE path formation is fixed $QMSPOOLDIR Directory used by the Queue Manager to contain the filesystem components of the queues themselves, as well as the files that represent or contain jobs waiting for execution Linux: /var/spool/$QMPURPOSEor$QMDIR/spoolLinux: Choice between two approaches – under the system spooler directory or traditional under$QMDIR
Supported Queue Manager Versions
About
$QM_VERSION
:$QM_VERSION
is the supported version of the Queue Manager on the installation platform.$QMRELS
isqm_
plus$QM_VERSION
. The following table shows the currently supported versions of the Queue Manager software:
Platform Queue Manager Version
$QM_VERSION
Queue Manager Release
$QMRELS
Linux RHEL7 3_32 qm_3_32
Standard Filesystems
In the ensuing discussions, when the term standard filesystem (or "Std FS") is used, it is intended to mean the recommended type of filesystem for each platform as set forth below:
OS Standard Filesystem Linux RHEL7 ext3
Filesystem Layouts
NetSol recommends that
$NSTDIR
be on one filesystem. If the administrator prefers to use separate filesystems, then the following table should be consulted to guide the layout of the$NSTDIR
structure on different combinations of filesystems:
Number of
FilesystemsFilesystem 1:
Directories
Min Space Req
Filesystem TypeFilesystem 2:
Directories
Min Space Req
Filesystem TypeFilesystem 3:
Directories
Min Space Req
Filesystem TypeFilesystem 4:
Directories
Min Space Req
Filesystem Type1 $NSTDIR
$QMDIR
$TOPDIR
$CSTDIR
1.8 GB
Std FS2 $NSTDIR
$TOPDIR
$CSTDIR
1.5 GB
Std FS$QMDIR
300 MB
Std FS2 $NSTDIR
$QMDIR
$CSTDIR
400 MB
Std FS$TOPDIR
1.4 GB
Std FS3 $NSTDIR
$CSTDIR
100 MB
Std FS$QMDIR
300 MB
Std FS$TOPDIR
1.4GB
Std FS4 $NSTDIR
10 MB
Std FS$QMDIR
300 MB
Std FS$TOPDIR
1.4 GB
Std FS$CSTDIR
100 MB
Std FS
Installing LeasePak v76a across more than 4 separate filesystems is not recommended. The administrator should not relocate arbitrary parts of
$QMDIR
or$TOPDIR
to other filesystems without guidance from NetSol.
Creating and Provisioning
Parameter Path Owner:Group Access Mode Made By Cfg Input $EFSDIR /opt OS values OS values OS or admin No $NSTDIR $EFSDIR/nst root:${NSTGROUP} 0750 SETUP No (none) $NSTDIR/log root:sys 0755 SETUP No $TOPDIR $NSTDIR/v76a ${NSTADMIN}:${NSTGROUP} 0755 SETUP Yes $CSTDIR $NSTDIR/cst root:${NSTGROUP} 0775 SETUP Yes $QMPPATH $NSTDIR/$QMPURPOSE
or
$EFSDIR/$QMPURPOSE
root:sys 0777 SETUP Yes $QMDIR $QMPPATH/$QMRELS ${NSTADMIN}:${NSTGROUP} 0750 SETUP No $SYSTMPDIR Linux: /var/tmpor/tmpOS values OS values OS Yes $QMTMPDIR $SYSTMPDIR/$QMPURPOSE root:root 0777 SETUP No Config:LNMDIR
Config:SORTDIR
Config:MBXDIR
Config:TRACE$QMTMPDIR/lnm
$QMTMPDIR/sor
$QMTMPDIR/mbx
$QMTMPDIR/logroot:root 0777 SETUP No $QMSPOOLDIR Linux: /var/spool/$QMPURPOSEor$QMDIR/spool${NSTADMIN}:${NSTGROUP} 0777 SETUP Yes
- Parameter – the LeasePak environment variable that contains the path
- Path – absolute pathname of the directory
- Ower:Group – the owner and group of the directory; OS value means whatever value is the norm for the OS and the site
- Access Modes – the directory's access modes; OS values means whatever value is the norm for the OS and the site
- Made By – who is responsible for creating the directory; the OS, the System Administrator, or
SETUP
- Cfg Input – whether or not the path is the subject of a prompt in the Setup Interview
Internet and Init Services Installed by LeasePak
Parameter Service Location Service Name SETUP
PromptComments $QMINITFNAME $INITDIR nst_qm_${INST_ID}76a Install Queue Mgr startup/shutdown in rc1.d/rc3.d? Handles starting and stopping the Queues (none) $INITDIR nst_dbora Install Oracle startup/shutdown in rc1.d/rc3.d? Handles starting and stopping the Oracle instances listed in $DBMS_INSTANCES_LIST
(none) $INITDIR nst_dbsyb Install Sybase startup/shutdown in rc1.d/rc3.d? Handles starting and stopping the Sybase dataservers and possibly the backup server All of the above init services
log their important activities to log files in the$NSTDIR/log
directory.The nst_dbora
andnst_dbsyb
services should be installed only on a Combined Host. SinceSETUP
runs on the Application host, that is where these services will be installed. If the DBMS Host is separate under a Split System, then the services will be in the wrong place.$LPKD_SVC_ID /etc/services nst_lp76a${INST_ID}_$LEASEPAKD_PORT Install LeasePak TCP port in inet configuration? Handles dispatch of connection requests to leasepakd
$MPWD_SVC_ID /etc/services nst_mp76a${INST_ID}_$MPOWERD_PORT Install mPower TCP port in inet configuration? Handles dispatch of connection requests to mPowerd
The LeasePak server runs exclusively under the C locale. This is enforced through the LeasePak startup files. This locale is available on all supported platforms. The character set of this locale is ASCII with 8-bit extensions. Unicode, UTF8, and UTF16 are not compatible with LeasePak. See also below in the Interview, Oracle character set selection (this is discussed here because configuring LeasePak for Oracle requires providing the value of $NLS_LANG. Sybase is not discussed here as there is nothing that is obtained during the Interview in regards to this issue).
The Queue Manager used by LeasePak has a separate license file. This file is a text file obtained through the NetSol Help Desk. When the administrator is ready to install LeasePak for the very first time on the application host, they should contact the NetSol Help Desk, who will send a temporary license via email. The administrator should copy the file onto the application host as /etc/S7.license
and set its access modes to root:root 444
.
If a temporary license is issued, it must be replaced before expiration with a permenant license.
Obtaining the permanent license is not possible until the Queue Manager is installed with the rest of the LeasePak release. See below Obtaining the Permanent License.
The LLDBs of the LeasePak environments are supported and controlled by database systems, or DBMSes. LeasePak v76a supports two database systems, Oracle and Sybase; a site can run both database systems simultaneously if the client has purchased the proper licenses from the DBMS vendor and from NetSol. Or the site can run just one database system.
The following tables document directories connected in some way to both the database system(s) and the LeasePak server. They are by no means exhaustive or complete. See the Oracle Server SAG or the Sybase Server SAG for detailed information on the installation and configuration of the respective database systems and the hosts that support them.
The software for the two database systems should be segragated in separate directories. They do not necessarily need to be on separate filesystems, though of course they can be. The location of the database system software as appropriate does not have any bearing on the location of the disk storage segments used by either system to store the contents of databases. That is a matter for the Oracle and Sybase chapters of this Guide.
If the Application Host is separate from the DBMS Host, utilizing what is called the Split System, the recommended method for setting this up is to install LeasePak v76a and the database client software on the Application host and the database server software on the DBMS host. This is because the LeasePak server software acts as a client to the database servers and so requires the client libraries and other data that are part of the database system install. Contact the NetSol Help Desk for more information on setting up the Split System.
Name | Suggested Names Min Space Reqs |
Notes |
---|---|---|
/opt/oracle | The apex of the Oracle installation. This would be the mountpoint if a separate filesystem is used. | |
$ORACLE_BASE | /opt/oracle | Oracle's base directory for product installation |
$ORA_PRODSRV | product/19.0.0/dbhome_1 | With ORACLE_BASE becomes the value of $ORACLE_HOME . This is the location of the 64-bit Oracle Database Server, which must be installed on all machines that are to support an Oracle Instance, such as a Combined Host (serves as both an Application host and as a DBMS Host in a Unified System), or as a DBMS Host in a Split System. |
$ORA_PRODCLT | product/19.0.0/client_1 | This is the location of the 32-bit Oracle Database client, which is required for the LeasePak server processes to communicate with and utilize an Oracle database. It must be installed on all machnes that are to support LeasePak server processes, such as a Combined Host (serves as both an Application host and as a DBMS Host in a Unified System), or as an Application host in a Split System. When a machine serves as an Application host, the value of $ORACLE_HOME is $ORACLE_BASE/$ORA_PRODCLT . |
4.5 GB minimum 1.5 GB minimum |
Disk space for /opt/oracle (Oracle 64-bit server installation)Disk space for /opt/oracle (Oracle 32-bit client-only installation)
|
|
Additional disk space above the minimum is recommended to accomodate Oracle log and trace files. |
About the Oracle 19c directory structure: Oracle 19c requires there to be an
ORACLE_BASE
directory where various Oracle products may be installed. The default LeasePak name for this directory is /opt/oracle
. Products such as server or client database software are then installed in ORACLE_BASE
.
Oracle provides two versions of the 19c database system on RHEL7: a 64-bit and a 32-bit product. An Oracle instance runs only on the 64-bit server product. A 32-bit application such as LeasePak requires the 32-bit client product in order to interface with the Oracle instance.
Depending on the system topology chosen (that is, a Unified System or a Split System), the two products may occur in any of the following combinations:
System Topology |
Unified System | Split System | ||||
Host | Combined Host | Application Host | DBMS Host | |||
product/19.0.0 Directory |
dbhome_1 | client_1 | dbhome_1 | client_1 | dbhome_1 | client_1 |
Software | 64-bit server | 32-bit client | (not used on this host) | 32-bit client | 64-bit server | (not used on this host) |
Oracle Locale Settings (
NLS_LANG
): Oracle's NLS_LANG
environment variable contains locale information for the Oracle client processes. The Oracle server also has its locale information (see Oracle Server SAG). Locale information includes character set and language. If the client and server character sets do not match, then all data that passes between them (data and SQL) must be translated from one character set to the other. This is expensive and sometimes characters in one character set may have no equivalent in the other character set, leading to data corruption.
The LeasePak server supports only 7 and 8 bit character sets; in Oracle terms this means that Oracle NLS_LANG
is quite limited in its possible values. In LeasePak v76a, there are only three character sets that qualify available in Oracle: WE8ISO8859P1
, WE8ISO8859P15
, and US7ASCII
. The SETUP
interview program will require the operator to select one of these character sets. This will result in NLS_LANG
being set to American_America.$charset
. Contact the NetSol Help Desk for assistance on locale issues outside of this scope.
See the SAP ASE 16.0 SAG for complete details on the installation and configuration of the Sybase database system on the supported platforms.
About the SAP ASE 16.0 Directory Structure: For many releases, Sybase has used the Sybase major/minor version number in a ##_# format to name many of the directories within
$SYBASE
. For example, the Open Client software was found in OCS-12_5
on 12.5, in OCS-12_0
on 12.0, etc.
This was true up through at least Sybase 12.5.4. Despite Sybase's own version numbering, they have chosen to install the software in *-15_0 directories for all minor release versions of Sybase 15.
This being the case, LeasePak in v76a is behaving as if the Sybase version ($SYB_VERSION
) is 15.0, so that the customary naming conventions will lead to the correct directories.
Nevertheless, the compatible version of SAP for Linux RHEL6 is SAP ASE 16.0.
Edit the /etc/sysctl.conf
file on both the Application host and the DBMS host, add a definition for the kernel parameter listed below, and reboot the hosts.
Kernel Parameter | Description and Notes | Required Value |
---|---|---|
vm.overcommit_memory | Determines kernel strategy when free memory is running low | 0 |
There may be kernel parameter changes related to the database systems. See the Sybase Server SAG and the Oracle Server SAG for more information.
RedHat installs the MySql database system by default, including the executable /usr/bin/isql
. Being in the default PATH
value before LeasePak directories are added, /usr/bin
usually comes before any DBMS or LeasePak additions, so /usr/bin/isql
tends to be found before the Sybase isql
. This will cause errors in any LeasePak shell script using isql
.
Allowing a default installation of MySql on a LeasePak host is inherently incompatible with the operation of Sybase. NetSol strongly recommmends not installing MySql on the LeasePak host. Where MySql is installed alongside Sybase, the administrator must remove, rename, or relocate /usr/bin/isql
so that LeasePak shell scripts will not find the MySql version when searching for the Sybase isql
.
Do not directly edit the /etc/sudoers file
. Instead, create a new file under /etc/sudoers.d
NETSOL-specific SUDO
permissions for install:
NST ALL=NOPASSWD:/bin/chown,/bin/chgrp
User_Alias NST=test76a,dba76a
The RedHat xinetd
package must be installed on the Application host in order for leasepakd
or mpowerd
to properly function.
Use the RedHat yum
package manager to install the xinetd
package. The operator needs to log onto the Application host as root
and execute:
# yum install xinetd
The below table attempts to summarize all of the tasks that the Administrator must tend to before running SETUP to install LeasePak. This list does not and is not intended to replace careful reading and consideration of the information given in this Guide.
This table does not include some important implementation decisions that must be made prior to installation; please read the Setup Questions section carefully as well, and fill out the worksheet located there; there is some overlap between this worksheet and that one, but they are not equivalent.
Description | Value, Instruction, or Notes | Your Value or Notes | Done? |
---|---|---|---|
Application Host Preparation | |||
OS Verification | |||
64-bit Linux 2.6.32 minimum kernel |
Oracle 19c SAP ASE 16.0 |
||
Additional Application Host Preparation | |||
Changes Required in RHEL7 | |||
vm.overcommit_memory | 0 | ||
/usr/bin/isql | Remove, rename, or relocate | ||
Create new file under /etc/sudoers.d with |
NST ALL=NOPASSWD:/bin/chown,/bin/chgrp User_Alias NST=test76a,dba76a |
||
Application Host – Groups and Users | |||
Required OS Groups | |||
$NSTGROUP – LeasePak primary group |
nst | ||
Oracle DBMS primary installation group | orainv | ||
Oracle DBMS secondary installation group | oradba | ||
Sybase DBMS installation group | sybase | ||
Required OS Users | |||
$ORAINSTACCT – Oracle DBMS installation user; Oracle owner |
oracle (primary group=orainv ;secondary=oradba ) |
||
Sybase DBMS installation user; Sybase owner | sybase (primary group=sybase ) |
||
$NSTADMIN – LeasePak Release Administrator |
nsadm76a (primary group=$NSTGROUP ) |
||
$NSTDBA – LeasePak Database Administrator |
nsdba76a (primary group=$NSTGROUP ) |
||
DBMS Host Preparation | |||
Oracle 19c on Linux RHEL7 | |||
Mountpoint (if used) | /opt/oracle | ||
Size of /opt/oracle |
3.5 GB | ||
$ORACLE_BASE – Base directory for Oracle software products |
/opt/oracle/10 |
||
$ORA_PROD – Contain the Oracle database system and database client software |
product/19.0.0/dbhome_1 orproduct/19.0.0/client_1
|
||
$ORACLE_BASE/$ORA_PROD – The value of $ORACLE_HOME |
Mandatory | ||
SAP ASE 16.0 on Linux RHEL6 | |||
Mountpoint (if used) | /opt/sybase | ||
Size of /opt/sybase/16 |
2 GB | ||
$SYBDIR
$SYBASE
Contains the Sybase database system software |
/opt/sybase/16 | ||
Application Host – Devices and Filesystems | |||
CD-ROM | |||
CD-ROM Path | /SD-CDROM /mnt/cdrom /cdrom /shipcd |
||
Filesystem Sizes | |||
Size of /home ($HOME ) |
200 MB to 4+ GB | ||
Size of /tmp |
1.2 to 2+ GB | ||
Size of /var |
1.2 to 2+ GB | ||
Size of swap |
3 x physical memory | ||
LeasePak Server and Queue Manager Directories | |||
$EFSDIR – Contains LeasePak, Oracle and Sybase |
/opt (must already exist) |
||
$SYSTMPDIR – Temporary directory |
/var/tmp or /tmp (must already exist) |
||
$NSTDIR – Contains LeasePak |
$EFSDIR/nst (SETUP creates this) |
||
$NSTDIR/log – Contains init services log files |
$NSTDIR/log (SETUP creates this) |
||
$TOPDIR – Contains a LeasePak instance |
$NSTDIR/v76a (SETUP creates this) |
||
$CSTDIR – Contains end-user customized files |
$NSTDIR/cst (SETUP creates this) |
||
$QMPURPOSE – Common pathname component |
Linux: qm_${INST_ID}76a (component) |
||
$QMRELS – Common pathname component |
qm_$QM_VERSION (component) |
||
$QMPPATH – Contains the Queue Manager instance |
Linux: $NSTDIR/$QMPURPOSE (SETUP creates these) |
||
Location of the queues belonging to the Queue Manager instance | Linux: /var/spool/$QMPURPOSE (SETUP creates these) |
Each licensee of LeasePak receives a license file for each database system that they have purchased a license to use. The license file(s) are named:
lplicense.ora
– for Oraclelplicense.syb
– for SybaseWhere @@ is replaced by the licensee's two-letter client code. For example, My Leasing Company might have an Oracle license named MLlicense.ora
.
Normally these files are obtained from NetSol's ftp site, in coordination with the NetSol Help Desk.
It is possible for licenses to be provided on a standard double-density MS-DOS FAT12 format 3.5" diskette.
The goal of this step is to copy the license file(s) to the application host's /tmp directory and ensure that the files are named (renamed) lplicense.ora or lplicense.syb before SETUP
is run.
If ftp is used at any point to obtain the license file or to copy it onto the application host, the operator must make sure that the file is transferred in Binary mode each and every time.
Transferring the license file in Text mode thoroughly corrupts the file. This will not be detected until the first time someone attempts to run a LeasePak driver with it, when it will cause the driver to abort.
Install as
root
: It is critical that the installation be performed by root
(the system administrator).
It is equally critical that the shell session have NO LeasePak variables defined. If using the su
command, the administrator must use
su -
to prevent the shell session from being contaminated.
Executing SETUP is case-sensitive. The program executable SETUP may occur as upper or lowercase, depending on circumstances. If installing directly from the CD, it will typically be lowercase setup. If installing from a CD copy on local disk, it will typically be uppercase SETUP.
If unsure, list the files to determine the correct case from the filename.
What is db_add_srvadm
?
db_add_srvadm
is a NetSol Utility Script that is used to create or update the $SRVADM
DBMS user account under each installed DBMS. This account is granted privileges sufficient to administer all LeasePak-required aspects of the database system supporting LeasePak. It was designed to provide the system administrator a user account that can handle the administrative needs of LeasePak, but without divulging the database system root user (sysdba
or sa
) password.
However, creating this user involves someone wielding the database system root user (sysdba
or sa
) password during SETUP
. Also, some sites do not want the $SRVADM
to be able to create user accounts nor a number of other abilities that are assigned to $SRVADM
.
Therefore NetSol is providing a means by which the database system root user password is NOT prompted for, and the $SRVADM
user is not created. When the administrator choses to exercise this option, they then become responsible for the creation of $SRVADM
according to NetSol specifications, less any objectionable grants of privilege, and for the execution of any of $SRVADM
's functions according to NetSol specifications that they have not given privilege to $SRVADM
to do.
To engage this option, the administrator must use the -S
option of SETUP
; see SETUP
Command-Line Options.
The Administrator must read the sections below describing the responsibilities that they assume by engaging this option.
The method from v62a, using NSTOPT_CREATE_SRVADM=N
, is also still supported and is described below:
Shell | Commands to disable db_add_srvadm |
---|---|
sh ksh bash |
NSTOPT_CREATE_SRVADM=N export NSTOPT_CREATE_SRVADM |
csh tcsh |
setenv NSTOPT_CREATE_SRVADM N |
The interaction between using the environment variable method and the command line option method of disabling db_add_srvadm
db_add_srvadm
will run as a result) is shown in the following table:
Environment Variable Setting |
Command Line -
|
Command Line -S
|
---|---|---|
(not set) | Y | N |
Set to 'N' | N | N |
Set to 'Y' | Y | N |
Where the results are Y (Yes, db_add_srvadm
will run) or N (No, db_add_srvadm
will not run).
Choosing to not run db_add_srvadm
If the administrator chooses to not run db_add_srvadm
, they must instead separately fulfill a number of requirements. These are summarized as:
$uetc/physdb.msirc
Requirements for Creating the $SRVADM
user
$SRVADM
must be created by the DBMS administrator before SETUP
is run. The requirements for $SRVADM
vary by database system. See also Database Server Administrator.
DBMS | Commands used to create $SRVADM |
---|---|
Oracle |
SQL> CREATE USER $SRVADM IDENTIFIED BY $PWD_SRVADM; SQL> GRANT CREATE SESSION TO $SRVADM WITH ADMIN OPTION; SQL> GRANT ALTER SESSION TO $SRVADM WITH ADMIN OPTION; SQL> GRANT CREATE USER TO $SRVADM; SQL> GRANT ALTER USER TO $SRVADM; SQL> GRANT DROP USER TO $SRVADM; SQL> GRANT CREATE ROLE TO $SRVADM; SQL> GRANT DROP ANY ROLE TO $SRVADM; SQL> GRANT CREATE TABLE TO $SRVADM WITH ADMIN OPTION; SQL> GRANT CREATE VIEW TO $SRVADM WITH ADMIN OPTION; SQL> GRANT CREATE TRIGGER TO $SRVADM WITH ADMIN OPTION; SQL> GRANT CREATE PROCEDURE TO $SRVADM WITH ADMIN OPTION; SQL> GRANT CREATE TABLESPACE TO $SRVADM; SQL> GRANT ALTER TABLESPACE TO $SRVADM; SQL> GRANT SELECT_CATALOG_ROLE TO $SRVADM; SQL> GRANT ANALYZE ANY DICTIONARY, ANALYZE ANY TO $SRVADM; SQL> ALTER USER $SRVADM DEFAULT ROLE SELECT_CATALOG_ROLE; SQL> ALTER USER $SRVADM DEFAULT TABLESPACE $ORA_DFLTSEG; |
Sybase |
1> use master 2> go 1> exec sp_addlogin $SRVADM, $PWD_SRVADM 2> grant role sa_role to $SRVADM 3> grant role sso_role to $SRVADM 4> go |
Requirements for creating LeasePak Logical Databases, Logical Database Owners, and $uetc/physdb.msirc
If the LLDB and its owner are created by the DBMS administrator, it should be done according to the information below, which varies according to the database system. See also Creating LeasePak Logical Databases.
Oracle Requirements for Creating LLDBs and DBOs
- The Oracle LLDB and its owner are the same entity. These are the requirements for creating the owner/LLDB:
SQL> CREATE USER $MSIDB_DBNAME IDENTIFIED BY $PWD_MSIDB_DBNAME; SQL> CREATE ROLE msi_$MSIDB_DBNAME NOT IDENTIFIED; SQL> CREATE ROLE msir_$MSIDB_DBNAME NOT IDENTIFIED; SQL> GRANT CREATE SESSION TO $MSIDB_DBNAME; SQL> GRANT CREATE TABLE TO $MSIDB_DBNAME; SQL> GRANT CREATE VIEW TO $MSIDB_DBNAME; SQL> GRANT CREATE TRIGGER TO $MSIDB_DBNAME; SQL> GRANT CREATE PROCEDURE TO $MSIDB_DBNAME; SQL> GRANT ALTER SESSION TO $MSIDB_DBNAME; SQL> GRANT msi_$MSIDB_DBNAME TO $MSIDB_DBNAME WITH ADMIN OPTION; SQL> GRANT msir_$MSIDB_DBNAME TO $MSIDB_DBNAME WITH ADMIN OPTION; SQL> ALTER USER $MSIDB_DBNAME DEFAULT ROLE msi_$MSIDB_DBNAME, msir_$MSIDB_DBNAME; SQL> ALTER USER $MSIDB_DBNAME DEFAULT TABLESPACE $ORA_DFLTSEG SQL> QUOTA quota ON tablespace;
where where quota is either numberM if using a common storage segment (tablespace), or UNLIMITED if using a dedicated storage segment, and tablespace is the name of the storage segment.- The file
$uetc/physdb.msirc
must be updated, with ownership given to$NSTDBA
, and the contents:setenv MSIDB_SEG01 "tablespace,quota"where tablespace and quota must match the values used in creating the LLDB above.Sybase Requirements for Creating LLDBs and DBOs
- The Sybase LLDB is created as an actual Sybase database; its owner is created separately. Following are the requirements for creating the database:
1> use master 2> go 1> create database $MSIDB_DBNAME on datadev = datasize 2> log on logdev = logsize 3> go 1> exec sp_dboption $MSIDB_DBNAME 'trunc log on chkpt',true 2> go 1> use $MSIDB_DBNAME 2> go 1> checkpoint 2> go 1> exec sp_addgroup msi 2> exec sp_addgroup msir 3> go- The
'trunc log on chkpt'
option is NOT valid for production LLDBs and must be replaced with an option that will allow for proper database recovery in the event of failure or error. Click here for the Critical Note pertaining to'trunc log on chkpt'
.- The file
$uetc/physdb.msirc
must be updated, with ownership given to$NSTDBA
, and the contents:setenv MSIDB_SEG01 "datadev,datasize,DATA"setenv MSIDB_SEG02 "logdev,logsize,LOG"where the devices and sizes must match the values used in creating the LLDB above.- The Sybase database owner is created as shown below. If the
$SYB_AUTODBO SETUP
option is set to Y, then the database owner's name should be the same as the LLDB name ($MSIDB_DBNAME
):
1> use master 2> go 1> exec sp_addlogin $DBO, $PWD_DBO 2> exec sp_locklogin $DBO, 'lock' 3> exec sp_modifylogin $DBO, defdb, master 4> exec sp_locklogin $DBO, 'unlock' 5> go 1> use $MSIDB_DBNAME 2> go 1> exec sp_changedbowner $DBO 2> goLLDB and DBO Requirements for both Oracle and Sybase
- The NetSol Utility Script
db_setup_phys
may be run to update thephysdb.msirc
file. This interactive script requires the$SRVADM
account password, but does not modify the database system master tables.- Under this arrangement, the DBMS administrator will perform the functions handled by the
-b
and possibly the-p
options ofdb_create
; the$NSTDBA
may thereafter executedb_create -ocs
.db_create
will still require the$SRVADM
password; this, however, is not actually used for the-o
,-c
, and-s
options, so a dummy may be used. These three options are equivalent to using:db_load_objdb_load_codedb_set_security
Requirements for creating non-Administrative Users
If the $SRVADM
is not to create users, then the DBMS administrator will need to create all user accounts in the database system. A distinction is made between users who are to be LLDB owners and users who are not. The creation of all database system users except $SRVADM
may be deferred until after SETUP
has been run. See also LeasePak non-Administrative User Accounts. The NetSol Utility Script db_add_user
is used by the $NSTDBA
to enable a user to access a particular LLDB. See also Granting Access to LLDB to user.
DBMS | Commands used to create non-Administrative Users |
---|---|
Oracle |
SQL> CREATE USER $DBMS_USER IDENTIFIED BY $PWD_DBMS_USER; SQL> GRANT CREATE SESSION TO $DBMS_USER; SQL> ALTER USER $DBMS_USER DEFAULT ROLE NONE; SQL> ALTER USER $DBMS_USER DEFAULT TABLESPACE $ORA_DFLTSEG; |
Sybase |
1> use master 2> go 1> exec sp_addlogin $DBMS_USER, $PWD_DBMS_USER 2> exec sp_locklogin $DBMS_USER, 'lock' 3> exec sp_modifylogin $DBMS_USER, defdb, master 4> exec sp_locklogin $DBMS_USER, 'unlock' 5> go |
Oracle only: Requirements for tablespaces and datafiles
If the $SRVADM
is not to create or alter tablespaces, then the DBMS Administrator must manage these functions. Tablespaces and their datafiles used by LeasePak must be made with the following characteristics:
To create a tablespace:
To add a datafile:
Redefining the SYSDBA account name
Sometimes there is a need to redefine the sysdba
account name for Oracle. To accomplish this, the administrator would define the environment variable NSTOPT_REDEFINE_SYSDBA
prior to running SETUP
.
Shell | Commands to redefining the sys_dba account name |
---|---|
sh ksh bash |
NSTOPT_REDEFINE_SYSDBA=lpadmin export NSTOPT_REDEFINE_SYSDBA |
csh tcsh |
setenv NSTOPT_REDEFINE_SYSDBA lpadmin |
Option | Description |
---|---|
SETUP -h | Lists out the different options available. Does not install any software |
SETUP $TOPDIR | Installs all parts of the package (this is sometimes called "plain SETUP ") |
SETUP -b $TOPDIR | Installs just the build part of the package |
SETUP -l $TOPDIR | (Lowercase L) Installs a new license file |
SETUP -S $TOPDIR | (Uppercase S) Disables db_add_srvadm (see Disabling db_add_srvadm above) |
Plain SETUP
starts out with an interview, a series of questions tailored to the platform that allows the administrator to specify values for the site and hosts involved. Before running SETUP
, the administrator should review the section below on SETUP
Questions and have the answers prepared for the actual installation.
Only the output of SETUP -h is shown here. See the following sections for examples of installation:
# /shipcd/SETUP -h Usage: SETUP [-bhlS] LeasePak-top-directory options should be combined into single -... parameter; order is not important; duplicates are ignored. With no options, all install sections are performed: Basic, Config, QM, Build, and License Options that include 'h' display this help screen and then quit. With any options 'b' or 'l' present, Basic, Config, QM, Build and License are all turned off; the options b/l then each turn a particular section on again. Options that include 'b' turn on Build Options that include 'l' turn on License(s) Options that include 'S' turn off creation of SRVADM
The interview is conducted via simple Bourne-shell scripting. As such, it does not have line editing capabilities built in. Basically, when it needs a response from the operator, it suspends all other activities and waits until the operator (1) types zero or more characters and presses ENTER or (2) presses CTRL-C or some other key combination that interrupts the script, terminating the interview program, and possibly the SETUP
program.
The only way to go "backwards" in the interview is to stop the interview with CTRL-C and starting SETUP
over. Each time the interview is completed the input gathered is printed to the screen, allowing the operator to scroll back through the displayed responses to verify that they are as intended. Then the operator is given the opportunity to re-run the interview or to accept the input as it stands.
When each question is presented, it is printed such that the right margin is aligned in the same column throughout the interview. There is a colon and a space at the end of the question, where the operator is to type their response. Immediately before the colon is a pair of square brackets [ ], sometimes with a value in between such as [this]. This value is the default value. That is, this value represents the answer to the question that is used if the operator does not make any input of their own.
The operator cannot modify the default value, they can only accept it in its entirety, or can type a different value. Even if the operator wants to use 99% of the default value, they must type the entire input value in, or accept the default unchanged. To accept the displayed default value, the operator makes no input, not even a space, but simply presses ENTER. There is no attempt to display the accepted default in a way that looks as if it were typed in by the operator.
There are questions that have no default answers; these have either empty brackets [ ] or no brackets at all.
Some questions are multiple choice and will mention in their prompts what the choices are and what they signify. After the question, and before the default value in brackets, the possible choices are usually presented inside of parentheses in a /-separated list of values like this: (Y/N)
or (AB/CD/EF)
. These values are never case sensitive. In other words, the response to (Y/N)
may be Y, y, N, or n.
A few questions allow the operator to include the default value as part of their response, where the program will replace a plus (+) in their response with the default value. So, if the question were asked:
If the operator then types: orange grapefruit + blueberry, the results will be orange grapefruit banana blueberry
as if the word banana
had been typed as part of the response. This capability is accessible only when and as described in the prompts.
A few questions present default values, but also will accept a blank response as valid, as well as values typed in by the operator, and the default value if accepted by the operator. To distinguish between a blank response intended to accept the default value and a blank response intended to be blank, the operator is allowed to enter an asterisk (*) to indicate a blank response. So the prompt:
Can be responded to by:
love
)friendliness
)This capability is accessible only when and as described in the prompts.
In the following discussion of the interview questions, the prompts that contain variable values as their defaults are presented as:
And in the discussion of the defaults, possible defaults are likewise marked with the two asterisks (**) to indicate that they may appear in the default brackets in the question.
(Items 1a – 1e)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
1a |
A previous instance of LeasePak (v76a.$INST_ID)
exists at this location; overwrite? (Y/N) [N] This question appears only if there is already an instance of LeasePak already in the same Operator answers:
|
N | |
1b |
v76a previously installed at other location(s).
Is this to be a separate install? (Y/N) [Y] If another instance of the release was installed at another location on the Application host, and the registry entries describing it are intact, then this question is posed to the operator. Operator answers:
|
Y | |
1c |
Keep the identifier of the previous installation (prev ID)? (Y/N) [Y]
This question appears only if there was a previously installed LeasePak Instance in the same Operator answers:
|
Y | |
1d |
Short identifier for this instance (2 to 4 characters) [**]
Questions 1d and 1e appear only on a new install, or on an install in the same location where question 1c is answered No. This is the LeasePak Instance ID, and is not to be confused with the Oracle Instance name. The LeasePak Instance ID is used in the naming of some Queue Manager directories, and in the names of services connected directly to the LeasePak instance. |
** On a new install, there is no default value. On an install in the same location, the ID from the previous LeasePak instance will default. | |
1e |
Comment to accompany the Instance ID when needed (0 to 20 characters) [**]
The Instance ID Comment appears only in the entries in |
** On a new install, there is no default value. On an install in the same location, the ID Comment from the previous LeasePak instance will default. |
(Items 2a – 2b)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
2a |
Name of the LeasePak Application Host [**]
Hostname of server where |
** The result of the uname -n command |
|
2b |
Path of End User Customized Code directory [$NSTDIR/cst]
Must be a path outside of any specific release, yet should be within the NetSol area of the system. User-customized code, both SQL and shell script, is maintained here by the user for each build installed in an adjacent release instance.
|
(Items 3a – 3i)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
3a |
Accept default Queue Manager paths? (Y/N) [Y]
|
Y | |
3b |
Parent of Queue Mgr $QMRELS directory [**]
Asked only if question 3a is answered with N This becomes the value of the variable |
** $NSTDIR/$QMPURPOSE |
|
3c |
Select system directory for temporary v76a files: 1=/tmp 2=/var/tmp [**]
Asked only if question 3a is answered N
The Queue Manager makes extensive use of temporary files. This question allows the Linux administrator to select one of two supported system temporary directories, This selection (1 or 2) is stored in the variable In all cases, the temporary directory is formed by suffixing |
** /var/tmp |
|
3d |
Select directory for printer and batch queues: 1=$QMDIR/spool 2=/var/spool [**]:
Asked only if question 3a is answered N
The Queue Manager requires space to store the queue structures and the batch and print files pending and during their execution on the queue. This question allows the Linux administrator to select one of two supported spooler directories, This selection (1 or 2) is stored in the variable If the selection is 1, |
** /var/spool |
|
3e |
Install Queue Mgr startup/shutdown in rc1.d/rc3.d? (Y/N) [**]
The Installed using |
** If $INITDIR/$QMINITFNAME does not exist: YIf $INITDIR/$QMINITFNAME exists: N
|
|
3f |
Shared memory key for Queue Mgr IPC [76000]
The Queue Manager uses shared memory so that different processes running under it can communicate and avoid resource allocation conflicts. This key is the agreed upon identifier for that shared memory. It is also called |
76000 | |
3g |
Number of simultaneous jobs to allow for per queue[10]
This parameter is highly variable depending on type of hardware, the number of processors, LeasePak modules purchased, modules normally run in EOP, EOP scheduling. EOP is designed to run as many jobs in parallel as this parameter will allow, within the constraints of logical dependencies of the data. See Job Limit. |
10 | |
3h |
Number of Queue Mgr devices to configure in shared memory [150]
The number of Queue Manager device slots to allocate in this LeasePak instance, stored in |
150 | |
3i |
Number of Queue Mgr jobs to configure in shared memory [512]
The number of Queue Manager job slots to allocate in this LeasePak instance, stored in |
512 |
(Items 4a – 4c)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
4a |
DBMSs to support in this release[]
|
||
4b |
Primary DBMS in this release
Question asked only if answer to 4a is OS. Select:
The Primary DBMS becomes the one whose administrative environment is pointed to by the administrative accounts and thus is the database system accessible to |
||
4c |
Naming convention (S=strict, L=Loose, N=New strict) (S/L/N) [S]
NetSol recommends S, the Strict naming convention, and plans to make Strict the only and default choice starting in version v76a |
S |
(Items 5a – 5g)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
5a |
Oracle installation base path [/opt/oracle/10]
The base directory where Oracle software products in Oracle 19c are installed on the host; the name is stored in |
/opt/oracle/10 | |
5b |
Oracle server product subdirectory;
enter "*" to indicate this is an Application Host [product/19.0.0/dbhome_1]: The product sub-directory where the Oracle 64-bit database server software is installed; the name is stored in To support a local Oracle instance, either in a Unified System or in a Split System as the DBMS Host, the 64-bit database server should be installed in To support the LeasePak server, either in a Unified System or in a Split System as the Application Host, the 32-bit administrative Oracle Client software must be installed in If this is an Application Host of a Split System, then the operator should enter * to indicate this; there is no Oracle database server product required on the Application Host of a Split System. |
product/19.0.0/dbhome_1 | |
5c |
Oracle client product subdirectory;
enter "*" to indicate this is a DBMS Host [product/19.0.0/client_1]: The product sub-directory where the Oracle 32-bit administrative Oracle Client software is installed; the name is stored in To support a local Oracle instance, either in a Unified System or in a Split System as the DBMS Host, the 64-bit database server should be installed in To support the LeasePak server, either in a Unified System or in a Split System as the Application Host, the 32-bit administrative Oracle Client software must be installed in If this is the DBMS Host of a Split System, then the operator should enter * to indicate this; there is no Oracle database client product required on the DBMS Host of a Split System. |
product/19.0.0/client_1 | |
5d |
Install Oracle startup/shutdown in rc1.d/rc3.d? (Y/N) [**]
This will create the init service |
** If $INITDIR/nst_dbora does not exist AND the Oracle 64-bit database server product is installed, YElse, N |
|
5e |
Enter a plus sign (+) to include the default ** in your response ...
Oracle net service name(s) [**] The net service name by which the Oracle instance can be found on the network; it must be defined in The meaning of this prompt is that the operator can enter several Oracle net service names, as long as they exist in the file The first net service name is taken as the primary database server. It runs on the combined host of a Unified System, or on the DBMS host of a Split System, and any others run remotely elsewhere on the network. The database server name is copied into the variable Later on, this list of net service names is used to validate the database server entered with the |
** The first net service name in tnsnames.ora |
|
5f |
Oracle default no-allocate tablespace for LeasePak users [users]
Every Oracle database system user must have a default tablespace. The owner of the LLDB is granted the use of a tablespace on which to build the LLDB. LeasePak users are granted an Oracle role that permits them to access the objects in the LLDB. Therefore, LeasePak users do not require actual storage of their own on their default tablespaces. However, they must still each have a default. This question requires the name of the tablespace which will be assigned to the LeasePak users, and on which they will each have a quota of zero, meaning that they cannot create their own schema objects. This tablespace should already exist, though its existence is not validated by Oracle usually creates a |
users | |
5g |
Select Oracle character set: (a) WE8ISO8859P1 (b) WE8ISO8859P15 (c) US7ASCII (a/b/c) [a]
In order to properly set the value of Oracle's
|
a |
(Items 6a – 6f)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
6a |
Path of Sybase directory [**]
The path where SAP ASE 16.0 is installed on the application host; this becomes the value of |
** $EFSDIR/sybase/16 |
|
6b |
Install Sybase startup/shutdown in rc1.d/rc3.d? (Y/N) [**]
This will create the init service |
** If $INITDIR/nst_dbsyb exists, NOtherwise, Y |
|
6c |
Include Sybase backup server in startup/shutdown? (Y/N) [Y]
This question appears only if the operator answers Y to question 6b; if the Sybase Backup Server has been configured to run from the Application host, then it may be advisable to provide for its starting and stopping in conjunction with the dataservers |
Y | |
6d |
Enter a plus sign (+) to include the default ** in your response ...
Sybase Dataserver name(s) [**] The dataserver name by which the Sybase database system can be found on the network; it must be defined in The meaning of this prompt is that the operator can enter several Sybase dataserver names, as long as they exist in the file The first dataserver is taken as the primary database server. It runs on the combined host of a Unified System, or on the DBMS host of a Split System, and any others run remotely elsewhere on the network. The database server name is copied into the variable |
** The first dataserver name in $SYBASE/interfaces |
|
6e |
Sybase Backup Server name [**]
This question is asked only if the answer to question 6c was Y. |
** An apparent backup server name from $SYBASE/interfaces |
|
6f |
Automatically create Sybase database owner names? (Y/N) [Y]
As described in db_create, each LLDB requires an owner, or DBO. If the operator enters Y to this |
Y |
The numbering of the remaining sections of the interview depend on how many DBMSs were chosen for configuration. If only one was chosen, then the following is section 6; if two were chosen, then the following is section 7.
These roles are discussed in detail in User Accounts.
(Items 7a – 7d)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
7a |
Database server administrator name [srvadm]
The Database server administrator is a database server-only role. This role is granted authority to create new database system users, to grant them access to LLDBs, to create new LLDBs. The name of the Database server administrator is stored in the variable This question is asked regardless of the |
srvadm | |
7b |
NST Admin login name [nsadm76a]
The LeasePak release administrator is an OS user, responsible for managing the OS side of LeasePak. Often referred to as the |
nsadm76a | |
7c |
NST DBA login name [nsdba76a]
The LeasePak database administrator is an OS user, responsible for managing the DBMS side of LeasePak. Often referred to as the |
nsdba76a | |
7d |
NST group name [nst]
The primary group, or login group, for all LeasePak user and admin accounts. Stored in |
nst |
The numbering of the remaining sections of the interview depend on how many DBMSs were chosen for configuration. If only one was chosen, then the following is section 7; if two were chosen, then the following is section 8.
(Items 8a – 8c)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
8a |
TCP port assignment for leasepakd inet daemon [7600]
Any free TCP port available in |
7600 | |
8b |
Max bad logins before lockout (0=disabled) [0]
This parameter controls the bad-login lockout feature. The value must be 0 or greater. Zero disables the feature. Positive integers are taken to be the # of consecutive bad logins allowed before the system locks the user out. Only an administrator or administrative user can unlock such an account. |
0 | |
8c |
Install LeasePak TCP port in inet configuration? (Y/N) [**]
The administrator must enter Y in order for the port to be installed and to be accessible to LeasePak client connections. |
** If nst_lp76a${INST_ID}_$LEASEPAKD_PORT exists in /etc/services , then Nelse Y |
The numbering of the remaining sections of the interview depend on how many DBMSs were chosen for configuration. If only one was chosen, then the following is section 8; if two were chosen, then the following is section 9.
(Items 9a – 9d)
Item # |
Question and Explanation | Default Value | Your Value |
---|---|---|---|
9a |
Install mPowerd daemon (Y/N) [N]
If administrator enters Y, questions 9b, 9c, and 9d are asked, and the mPowerd service is installed with the service name |
N | |
9b |
TCP port assignment for mPowerd inet daemon [**]
Always defaults to |
** $LEASEPAKD_PORT + 6 |
|
9c |
Max bad logins before lockout (0=disabled) [0]
This parameter controls the bad-login lockout feature. The value must be 0 or greater. Zero disables the feature. Positive integers are taken to be the # of consecutive bad logins allowed before the system locks the user out. Only an administrator or administrative user can unlock such an account. |
0 | |
9d |
Install mPower TCP port in inet configuration? (Y/N) [**]
The administrator must enter Y in order for the port to be installed and to be accessible to mPower client connections. |
** If nst_mp76a${INST_ID}_$MPOWERD_PORT exists in /etc/services , then Nelse Y |
The following is the screen output from a sample run of SETUP
, broken down into sections with annotation for each section.
Sample input command to run SETUP
: /shipcd/SETUP -S /opt/nst/v76a
2011-11-03 14:38:48 SETUP /opt/nst/v76a: SRVADM creation turned off by presence of S option 2011-11-03 14:38:48 SETUP /opt/nst/v76a: This is a re-installation of this release in this location A previous installation of LeasePak (v76a.prod) exists at this location; overwrite? (Y/N) [N]: y 2011-11-03 14:38:57 SETUP /opt/nst/v76a: Loading setup VERSION file ... 2011-11-03 14:38:58 SETUP /opt/nst/v76a: Setting up top dir ...
SETUP
begins with loading the VERSION
file. This file is part of the CD image shipped by NetSol, and contains information that is universal to all LeasePak installations in v76a and information that is particular to the hardware platform for which the CD image is intended.SETUP
and $TOPDIR
are set.$TOPDIR
are searched for any previous installations of v76a on the Application host.Previous Installations of Release on Application host | Interview begins with question |
---|---|
LeasePak instance already in $TOPDIR |
1a (to confirm overwriting $TOPDIR ) |
Overwriting $TOPDIR confirmed |
1c (to reuse previous instance ID) |
LeasePak instance of same release elsewhere on Application host | 1b (to confirm setting up a new LeasePak instance) |
No LeasePak instance of same release detected on Application host, or question 1b confirmed | 1d (to obtain new instance ID) |
$TOPDIR
, then:
$TOPDIR
is deleted.clean_rels
is called to run the clean-script to clean-up the entire previous installation.The following 3 sections detail the actions of the clean-up processes.
2011-11-03 14:38:58 SETUP /opt/nst/v76a: Clearing /opt/nst/v76a ... 2011-11-03 14:38:58 SETUP /opt/nst/v76a: Checking for clean_v76a_prod.txt ... 2011-11-03 14:38:58 SETUP /opt/nst/v76a: Executing clean_v76a_prod.txt to clear /opt/nst/v76a ... 2011-11-03 14:38:58 clean_rels: Start - cleanscript is /opt/nst/v76a/etc/clean_v76a_prod.txt, NSTDBG_EX is N 2011-11-03 14:38:58 clean_rels: INFO SCRIPT:/opt/nst/v76a/etc/clean_v76a_prod.txt 2011-11-03 14:38:58 clean_rels: INFO HOST:darmok DATE:2011-10-25/17:50:36 TOPDIR:/opt/nst/v76a 2011-11-03 14:38:58 clean_rels: clean_v76a_prod.txt: SVCSTOP SVC:nst_qm_prod76a WAIT:15 Stopping v76a qm_prod76a Queue Manager ... Sector7 VX/DCL V3.3.2 (May 25 2011 21:06:43) Copyright (C) 1985-2011 Sector 7 USA Inc. All Rights Reserved Removing /var/lock/subsys/nst_qm_prod76a ... 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: completed: SVCSTOP SVC:nst_qm_prod76a WAIT:15 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: INITCLEAN INITF:nst_qm_prod76a 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: completed: INITCLEAN INITF:nst_qm_prod76a 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: CFGSAVE QMDIR:ATT QMCOM:start_queues.com QMLIB:DEVINIT QMLIB:Config~LP 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: completed: CFGSAVE QMDIR:ATT QMCOM:start_queues.com QMLIB:DEVINIT QMLIB:Config~LP: ; /opt/nst/qm_prod76a/qm_3_32/ATT: saved to $CFGDIR; /opt/nst/qm_prod76a/qm_3_32/com/start_queues.com: saved to $CFGDIR; /opt/nst/qm_prod76a/qm_3_32/library/DEVINIT: saved to $CFGDIR; /opt/nst/qm_prod76a/qm_3_32/library/Config:LP saved to $CFGDIR 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: IPCCLEAN KEY:76010 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: completed: IPCCLEAN KEY:76010 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: QMCLEAN QMTMP:/var/tmp/qm_prod76a QMSPOOL:/var/spool/qm_prod76a QMPPATH:/opt/nst/qm_prod76a 2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: completed: QMCLEAN QMTMP:/var/tmp/qm_prod76a QMSPOOL:/var/spool/qm_prod76a QMPPATH:/opt/nst/qm_prod76a
During Queue Manager clean-up, the program:
2011-11-03 14:39:23 clean_rels: clean_v76a_prod.txt: INETCLEAN LPKD:nst_lp76aprod_7601 MPWD:nst_mp76aprod_7607 2011-11-03 14:39:23 clean_rels: Removing nst_lp76aprod_7601 nst_mp76aprod_7607 from (x)inetd configuration ... 2011-11-03 14:39:23 clean_rels: Restarting (x)inetd ... Stopping xinetd: [ OK ] Starting xinetd: [ OK ] Reloading configuration: [ OK ] 2011-11-03 14:39:24 clean_rels: clean_v76a_prod.txt: completed: INETCLEAN LPKD:nst_lp76aprod_7601 MPWD:nst_mp76aprod_7607 2011-11-03 14:39:24 clean_rels: clean_v76a_prod.txt: REGCLEAN LP:v76a ID:prod 2011-11-03 14:39:24: reg_rels: Start: -ti /etc/netsol.conf v76a prod 2011-11-03 14:39:24: reg_rels: End 2011-11-03 14:39:24: reg_rels: Start: -d /etc/netsol.conf 31 2011-11-03 14:39:24: reg_rels: End 2011-11-03 14:39:24 clean_rels: clean_v76a_prod.txt: completed: REGCLEAN LP:v76a ID:prod
During system areas clean-up, the program:
2011-11-03 14:39:24 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial 2011-11-03 14:39:24 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - partial cleanup 2011-11-03 14:39:24 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - clearing bld 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - preserving user config data 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - preserving user datasets 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - preserving user environments 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - removing adm env adm_ora 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - preserving user config data 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - clearing live 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - preserving job.log 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial - preserving vertex data 2011-11-03 14:39:25 clean_rels: clean_v76a_prod.txt: completed: TOPCLEAN TOP:/opt/nst/v76a EXTENT:partial 2011-11-03 14:39:25 clean_rels: End cleanscript /opt/nst/v76a/etc/clean_v76a_prod.txt
Top directory is cleared out. Certain data is preserved from the previous LeasePak instance:
$TOPDIR/env
directories, except for adm_*
$datasets
relscfg.msirc
vertex
and boot
directoriesjob.log
2011-11-03 14:39:25 SETUP /opt/nst/v76a: Loading in base system image ... 2011-11-03 14:39:25 SETUP /opt/nst/v76a: Extending /shipcd/VERSION ... 2011-11-03 14:39:25 SETUP /opt/nst/v76a: Loading Queue Manager script library ... 2011-11-03 14:39:25 SETUP /opt/nst/v76a: Reading in extended version file ... 2011-11-03 14:39:25 SETUP /opt/nst/v76a: Running 'Configure Release' utility ... Configure Release -- Type Ctrl-C at any time to abort operation ==> 1. Instance Name <== The previous installation of v76a in this location has been cleared Keep the identifier of the previous installation (prod)? (Y/N) [Y]: ==> 2. Server Name <== Name of the LeasePak Application Host [darmok]: Path of End User Customized Code directory [/opt/nst/cst]: ==> 3. Queue Manager <== No existing Queue Manager found Accept default Queue Manager paths? (Y/N) [Y]: Install Queue Mgr startup/shutdown in rc1.d/rc3.d? (Y/N) [Y]: Shared memory key for Queue Mgr IPC [76010]: Number of Queue Mgr devices to configure in shared memory [150]: Number of Queue Mgr jobs to configure in shared memory [512]: Number of simultaneous jobs to allow for per queue[10]: ==> 4. DBMS configuration <== DBMS's to support in this release (O=Oracle S=Sybase OS=both): o Naming convention (S=strict, L=Loose, N=New strict) (S/L/N) [S]: ==> 5. Oracle configuration <== Oracle installation base path [/opt/oracle/11]: Oracle server product subdirectory; enter "*" to indicate this is an Application Host [product/11.2.0/dbhome_1]: Oracle client product subdirectory; enter "*" to indicate this is a DBMS Host [product/11.2.0/client_1]: Install Oracle startup/shutdown in rc1.d/rc3.d? (Y/N) [N]: Enter a plus sign (+) to include the default DARMOK in your response ... Oracle net service name(s) [DARMOK]: Oracle default no-allocate tablespace for LeasePak users [users]: Select Oracle character set: (a) WE8ISO8859P1 (b) WE8ISO8859P15 (c) US7ASCII (a/b/c) [a]: ==> 6. Required Leasepak & DBMS roles <== Database server administrator name [srvadm]: NST Admin login name [nsadm76a]: NST DBA login name [nsdba76a]: NST group name [users]: ==> 7. Leasepakd daemon configuration <== TCP port assignment for leasepakd inet daemon [7601]: Max bad logins before lockout (0=disabled) [0]: Install LeasePak TCP port in inet configuration? (Y/N) [Y]: ==> 8. mPowerd daemon configuration <== Install mPowerd daemon (Y/N) [N]: y TCP port assignment for mPowerd inet daemon [7607]: Max bad logins before lockout (0=disabled) [0]: Install mPower TCP port in inet configuration? (Y/N) [Y]: ==> 1. Instance Name <== Release Inst Mode: SAME Instance Id: prod Instance Id Cmnt: prod test Top Directory: /opt/nst/v76a NST Directory: /opt/nst External File Sys: /opt LPID: v76a.prod ==> 2. Server Name <== Unix OS type: Linux Server name: darmok Release path: /opt/nst/v76a Release sequence: 760 Custom code path: /opt/nst/cst Init directory: /etc/init.d ==> 3. Queue Manager <== Install type: clean Accept std paths? Y Queue Mgr path: /opt/nst/qm_prod76a/qm_3_32 QMID: 3_32.prod Queue Mgr in Rc? Y Queue Mgr shmemkey: 76010 Max Queue devices: 150 Max Queue jobs: 512 Queue Mgr systmp: 2 Queue Mgr tmp dir: /var/tmp/qm_prod76a Queue Mgr spool: 2 QueueMgr spool dir: /var/spool/qm_prod76a Queue Mgr purpose: qm_prod76a Queue job limit: 10 Queue job lim file: /opt/nst/qm_prod76a/qm_3_32/library/qjob_limit Calc QMgr params? N ==> 4. DBMS configuration <== DBMS's in use: ora Primary DBMS: ora Naming convention: S ==> 5. Oracle configuration <== Oracle major rev: 11 Oracle base: /opt/oracle/11 Unified host: Oracle srv product: product/11.2.0/dbhome_1 Oracle clt product: product/11.2.0/client_1 Oracle home: /opt/oracle/11/product/11.2.0/dbhome_1 Oracle library: /opt/oracle/11/product/11.2.0/client_1/lib Oracle utility pth: /opt/oracle/11/product/11.2.0/dbhome_1/bin Oracle in Rc? N Oracle services: DARMOK Oracle service nm: DARMOK Oracle def tblspc: users Oracle NLS_LANG: American_America.WE8ISO8859P1 ==> 6. Required Leasepak & DBMS roles <== DBMS server admin: srvadm NST Admin login: nsadm76a NST DBA login: nsdba76a NST group: users ==> 7. Leasepakd daemon configuration <== Leasepakd Port: 7601 Lockout Count: 0 Install Port? Y Port installtype: ni Port to replace: LPKID: 7601.prod ==> 8. mPowerd daemon configuration <== Mpowerd Port: 7607 Lockout Count: 0 Install Port? Y Port installtype: ni Port to replace: MPWID: 7607.prod Configuration complete 2011-11-03 14:41:03 SETUP /opt/nst/v76a: 'Configure Release' terminated normally Do you wish to [R]erun 'Configure Release' or to [C]ontinue with installation? (R/C): c 2011-11-03 14:42:31 SETUP /opt/nst/v76a: Response=c; continuing with installation ...
2011-11-03 14:42:31 SETUP /opt/nst/v76a: Loading the release configuration created by 'Configure Release' ... 2011-11-03 14:42:31 SETUP /opt/nst/v76a: Queue Manager installation type is clean 2011-11-03 14:42:31 SETUP /opt/nst/v76a: Setting up Queue Manager dir ... 2011-11-03 14:42:31 SETUP /opt/nst/v76a: Installing Queue Manager ... 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Attaching to Dedicated Queue Manager instance ... 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Setting up basic Queue Manager configuration; Administrator must handle print and batch queue setup 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Setting Queue Manager job limit ... 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Queue Manager configuration complete 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Restoring previously preserved Queue Manager data ... 2011-11-03 14:42:32 SETUP /opt/nst/v76a: start_queues.com restored 2011-11-03 14:42:32 SETUP /opt/nst/v76a: DEVINIT restored 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Printer configuration from prior installation's Config file preserved in /opt/nst/qm_prod76a/qm_3_32/library/PRIOR.QMLP 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Administrator must add this printer configuration to /opt/nst/qm_prod76a/qm_3_32/library/Config 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Queue Manager installed
After the operator types C to continue following the interview, the Queue Manager installation begins in the directory designated in the interview.
start_queues.com
, the printer mapping commands from Config
, and DEVINIT
ATT
attachment file$QMDIR
directory is cleared out and the image from the CD is laid down. A new ATT
attachment file is writtenConfig
file is now self-customizing. The self-modifying file is run and customizes itself to create the new Config
. However, the administrator must still enter the printer mapping commands.$QMDIR/library/PRIOR.QMLP
. DEVINIT
is restored, as is start_queues.com
.2011-11-03 14:42:32 SETUP /opt/nst/v76a: Setting up Customized Software directory /opt/nst/cst ... 2011-11-03 14:42:32 SETUP /opt/nst/v76a: Installing build 7.60.3034 ... 2011-11-03 14:42:40 SETUP /opt/nst/v76a: Build 7.60.3034 installed 2011-11-03 14:42:40 SETUP /opt/nst/v76a: syb not installed; removing components ... 2011-11-03 14:42:40 SETUP /opt/nst/v76a: Attaching build 7.60.3034 to live ... 2011-11-03 14:42:40 SETUP /opt/nst/v76a: Build attached
$NSTDIR
, then the $CSTDIR
is set up.$TOPDIR/live
to become the live build. A subtree for the build is created in $CSTDIR
.$live/exe/$DBTYPE
and $live/sql/$DBTYPE
directories for each uninstalled database system are removed.Users can auto deploy/redeploy LeasePak on server. Following are the steps to deploy/re-deploy LeasePak on server:
The variables/parameters defined in
.cfg
file have been explained in the above sections of Questions pertaining to Instance Name. Click here for sample .cfg
and .sh
files.
This is only applicable for Oracle platform. Sybase is not supported for auto deployment of LeasePak on server.
2011-11-03 14:42:40 SETUP /opt/nst/v76a: Fetch license(s) ... 2011-11-03 14:42:40 SETUP /opt/nst/v76a: Copying /tmp/lplicense.ora ... 2011-11-03 14:42:40 SETUP /opt/nst/v76a: Install license(s) ...
/tmp
directory before running SETUP
. If SETUP
cannot find them, it stops and prompts for the operator to get the file(s) in place. SETUP
will not proceed until a license for each installed database system has been found and retrieved.$CFGDIR
, and also to their respective $live/exe/${DBTYPE}
directories, where each is renamed to lplicense.dat
.2011-11-03 14:42:40 SETUP /opt/nst/v76a: Setting file protections on v76a 2011-11-03 14:42:40 set_access: Start: /opt/nst/v76a/boot/base_sys.prot 2011-11-03 14:42:40 set_access: End: /opt/nst/v76a/boot/base_sys.prot 2011-11-03 14:42:40 set_access: /opt/nst/v76a/boot/base_sys.prot: 46 Item(s); 0 Error(s) 2011-11-03 14:42:40 SETUP /opt/nst/v76a: Setting file protections on Build 2011-11-03 14:42:40 set_access: Start: /opt/nst/v76a/live/lib/bld.prot 2011-11-03 14:43:07 set_access: End: /opt/nst/v76a/live/lib/bld.prot 2011-11-03 14:43:07 set_access: /opt/nst/v76a/live/lib/bld.prot: 1803 Item(s); 0 Error(s) 2011-11-03 14:43:07 SETUP /opt/nst/v76a: Setting file protections on Queue Manager ... 2011-11-03 14:43:07 set_access: Start: /opt/nst/qm_prod76a/qm_3_32/library/qm_3_32_rt.prot 2011-11-03 14:43:08 set_access: End: /opt/nst/qm_prod76a/qm_3_32/library/qm_3_32_rt.prot 2011-11-03 14:43:08 set_access: /opt/nst/qm_prod76a/qm_3_32/library/qm_3_32_rt.prot: 116 Item(s); 0 Error(s) 2011-11-03 14:43:08 SETUP /opt/nst/v76a: Setting protections on /opt/nst/cst ...
set_access
command is run 3 times, once each for basic system, for the build, and for the Queue Manager.set_access
sets the owner, group and access modes of the files and directories in the list given to it.set_access
is designed to tolerate a certain number of errors, usually 50, before aborting in error. The errors are reported to the screen, but only if they exceed the limit in quantity do these errors cause SETUP
to abort.SETUP
to abort, then it is possible that the installation was still successful. However, check with the NetSol Help Desk if any errors are reported during SETUP
.2011-11-03 14:43:08 SETUP /opt/nst/v76a: Loading basic shell function libraries ... 2011-11-03 14:43:08 SETUP /opt/nst/v76a: Creating Queue Manager release tmp directory ... 2011-11-03 14:43:08 SETUP /opt/nst/v76a: Setting up bottom-most Queue Manager tmp directory ... 2011-11-03 14:43:08 SETUP /opt/nst/v76a: Marking Queue Manager install complete ... 2011-11-03 14:43:08 SETUP /opt/nst/v76a: Creating Queue Manager release spool directory ...
SETUP
creates the Queue Manager temporary directories, $QMTMPDIR/*
.$QMSPOOLDIR
, is also created at this time.2011-11-03 14:43:09 SETUP /opt/nst/v76a: Generating common configuration scripts ... Writing runtime msirc file... USEPKG boot vi.20 USEPKG unix rhes5 USEPKG ora 11g USEPKG dbms vi.20 USEPKG s7 3_32 USEPKG lprt vi.20 USEPKG vms vi.20 USEPKG msi vi.20 Writing lpkd file... USEPKG boot vi.20 USEPKG unix rhes5 USEPKG ora 11g USEPKG dbms vi.20 USEPKG s7 3_32 USEPKG lprt vi.20 USEPKG vms vi.20 USEPKG msi vi.20 Writing com file... USEPKG boot vi.20 USEPKG unix rhes5 USEPKG ora 11g USEPKG dbms vi.20 USEPKG s7 3_32 USEPKG lprt vi.20 USEPKG vms vi.20 USEPKG msi vi.20 File generation complete; installing new config files... Installation of config files is complete 2011-11-03 14:43:19 SETUP /opt/nst/v76a: Configuration generation is complete 2011-11-03 14:43:19 SETUP /opt/nst/v76a: Loading generated settings via boot environment ...
cfg_gen
is then run. This program takes the relscfg.msirc
created by the SETUP
interview, the extended VERSION
file now in $BOOTDIR/version.msirc
, plus the templates in $live/lib/*.mtx
and creates 3 files. These files define essentially the entire LeasePak release instance.${HOST}_v76a_rt.msirc
, and it contains setenv
commands to build up the environment. When a LeasePak user logs into the Application host, this file is executed via the user's .lplogin
or .lpprofile
start-up file, and then that session is fully LeasePak enabled.${HOST}_v76a_rt.lpkd
, and it contains simple assignments that can be interpreted by leasepakd
and mPowerd
. When a LeasePak user logs into the Application host through the LeasePak Windows Client, this file is executed to ensure that the user environent is fully set up.${HOST}_v76a_rt.com
and it contains assignments to the environment in the Queue Manager DCL scripting language. It is executed at the beginning of every EOP batch job to ensure that the environment is fully configured before running the EOP driver.2011-11-03 14:43:19: reg_rels: Start: -r /etc/netsol.conf /opt/nst/v76a 2011-11-03 14:43:19: reg_rels: End
With the completion of the configuration generation, the release instance can now be registered in the /etc/netsol.conf
registry. At this time, this file only associates the instance ID of the LeasePak instance with the top directory and thus also the release version of LeasePak.
2011-11-03 14:43:19 SETUP /opt/nst/v76a: Performing LeasePak System installation ... 2011-11-03 14:43:19 lp_sys_install: Start - YNNNYY 2011-11-03 14:43:19 lp_sys_install: Install Queue Manager in rc? Y 2011-11-03 14:43:19 lp_sys_install: Installing Queue Manager ... 2011-11-03 14:43:19 lp_sys_install: Creating /etc/rc.d/init.d/nst_qm_prod76a ... 2011-11-03 14:43:19 lp_sys_install: Queue Manager complete 2011-11-03 14:43:20 lp_sys_install: Install Oracle 11g startups in rc? N 2011-11-03 14:43:20 lp_sys_install: Install leasepakd port in xinetd configuration? Y 2011-11-03 14:43:20 lp_sys_install: Installing leasepakd xinetd config ... 2011-11-03 14:43:20 lp_sys_install: Installing service nst_lp76aprod_7601... 2011-11-03 14:43:20 lp_sys_install: Deleting any existing nst_lp76aprod_7601 or leasepakd_v76a_7601 from /etc/services and /etc/xinetd.d/nst_lp76aprod_7601 ... 2011-11-03 14:43:20 lp_sys_install: Removing nst_lp76aprod_7601 leasepakd_v76a_7601 from (x)inetd configuration ... 2011-11-03 14:43:20 lp_sys_install: Adding nst_lp76aprod_7601 to /etc/services ... 2011-11-03 14:43:20 lp_sys_install: Adding nst_lp76aprod_7601 to /etc/xinetd.d/nst_lp76aprod_7601 ... 2011-11-03 14:43:20 lp_sys_install: Restarting (x)inetd ... Stopping xinetd: [ OK ] Starting xinetd: [ OK ] Reloading configuration: [ OK ] 2011-11-03 14:43:20 lp_sys_install: leasepakd xinetd config complete 2011-11-03 14:43:20 lp_sys_install: Install mPowerd port in xinetd configuration? Y 2011-11-03 14:43:20 lp_sys_install: Installing mPowerd xinetd config ... 2011-11-03 14:43:20 lp_sys_install: Installing service nst_mp76aprod_7607... 2011-11-03 14:43:20 lp_sys_install: Deleting any existing nst_mp76aprod_7607 or mPowerd_v76a_7607 from /etc/services and /etc/xinetd.d/nst_mp76aprod_7607 ... 2011-11-03 14:43:20 lp_sys_install: Removing nst_mp76aprod_7607 mPowerd_v76a_7607 from (x)inetd configuration ... 2011-11-03 14:43:20 lp_sys_install: Adding nst_mp76aprod_7607 to /etc/services ... 2011-11-03 14:43:20 lp_sys_install: Adding nst_mp76aprod_7607 to /etc/xinetd.d/nst_mp76aprod_7607 ... 2011-11-03 14:43:20 lp_sys_install: Restarting (x)inetd ... Stopping xinetd: [ OK ] Starting xinetd: [ OK ] Reloading configuration: [ OK ] 2011-11-03 14:43:20 lp_sys_install: mPowerd xinetd config complete 2011-11-03 14:43:20 lp_sys_install: End
Next the program lp_sys_install
is run. It is in charge of setting up the services requested by the operator via the interview. lp_sys_install
does not start any of the init services; it only installs them.
nst_qm_${INST_ID}76a
, if requested.nst_dbsyb
, if requested.nst_dbora
, if requested.leasepakd
internet service nst_lp76a${INST_ID}_$LEASEPAKD_PORT
on the $LEASEPAKD_PORT
port, if requested.mpowerd
internet service nst_mp76a${INST_ID}_$MPOWERD_PORT
on the $MPOWERD_PORT
port, if requested. Because
SETUP
was called with -S
, $SRVADM
was not recreated in this example.
db_add_srvadm
has not been disabled (see Disabling db_add_srvadm), then for each installed database system:
$SRVADM
, recreates$SRVADM
if it does not exist$SRVADM
was disabled by using the -S
option of SETUP
. Failed Login/Bad Password Message for Oracle
srvadm
: If SETUP
created the $SRVADM
account successfully, yet attempts to use the account receive failed login/bad password messages, the administrator should check for the following Oracle initialization parameter:
2011-11-03 14:43:20 SETUP /opt/nst/v76a: Locating nsadm76a and nsdba76a home directories ... 2011-11-03 14:43:20 SETUP /opt/nst/v76a: Performing DBMS-specific setup tasks ... 2011-11-03 14:43:20 SETUP /opt/nst/v76a: Creating admin environment for ora DBMS ... 2011-11-03 14:43:20 setup_new_env: -tnfc TEST adm_ora ora DARMOK non_admora_76a live; Start 2011-11-03 14:43:20 setup_new_env: Creating environment directory structure... 2011-11-03 14:43:20 setup_new_env: Creating logdb.*... 2011-11-03 14:43:21 setup_new_env: Creating envdb.msirc... 2011-11-03 14:43:21 setup_new_env: Creating msidba placeholder ... 2011-11-03 14:43:21 setup_new_env: Creating .lp*... 2011-11-03 14:43:21 setup_new_env: Setting environment security... 2011-11-03 14:43:21 setup_new_env: End
$NSTADMIN
and $NSTDBA
adm_${DBTYPE}
administrative environment.lp*
from the newly created environment to the $NSTADMIN
and $NSTDBA
home directories2011-11-03 14:43:21 SETUP /opt/nst/v76a: Setting file protections on bootstrap files ... 2011-11-03 14:43:21 set_boot_prot: Start 2011-11-03 14:43:21 set_boot_prot: Setting protections on miscellaneous boot files ... 2011-11-03 14:43:21 set_boot_prot: End 2011-11-03 14:43:21 build_clean_script: Cleanscript for v76a.prod written to /opt/nst/v76a/etc 2011-11-03 14:43:21 SETUP /opt/nst/v76a: setup is finished #
Once LeasePak is installed, the administrator should log onto the application host as $NSTADMIN, and execute:
This produces output similar to the example below. This output should be emailed to the NetSol Help Desk, who will shortly email back the permanent license. The permenent license file should then replace the temporary license (see Temporary License File) in /etc/S7.license
.
% gid VX/RT 00 01 53 48 46 21 00 00 0000 0 VX/BASRT 00 01 53 48 46 21 00 00 0000 0 VX/SMG 00 01 53 48 46 21 00 00 0000 0 VX/DCL 00 01 53 48 46 21 00 00 0000 0 VX/BASIC 00 01 53 48 46 21 00 00 0000 0 VX/RMS 00 01 53 48 46 21 00 00 0000 0 VX/JSP 00 01 53 48 46 21 00 00 0000 0 VX/SOR 00 01 53 48 46 21 00 00 0000 0 VX/FMS 00 01 53 48 46 21 00 00 0000 0 VX/FLT 00 01 53 48 46 21 00 00 0000 0 VX/DATAX 00 01 53 48 46 21 00 00 0000 0 VX/VTWIN 00 01 53 48 46 21 00 00 0000 0 VX/FPP 00 01 53 48 46 21 00 00 0000 0 VX/QSORT 00 01 53 48 46 21 00 00 0000 0 B2/RMS 00 01 53 48 46 21 00 00 0000 0 B2/RT 00 01 53 48 46 21 00 00 0000 0 BP/RT 00 01 53 48 46 21 00 00 0000 0 B2/DATAX 00 01 53 48 46 21 00 00 0000 0 B2/QSORT 00 01 53 48 46 21 00 00 0000 0 BTRAN/BP 00 01 53 48 46 21 00 00 0000 0 B2/BTRAN 00 01 53 48 46 21 00 00 0000 0 BTRAN/QB 00 01 53 48 46 21 00 00 0000 0 BTRAN/CB 00 01 53 48 46 21 00 00 0000 0 QB/RT 00 01 53 48 46 21 00 00 0000 0 CB/RT 00 01 53 48 46 21 00 00 0000 0
After running SETUP
, the administrator must complete the Queue Manager setup by defining site batch queues, printers and print queues, and associated devices. See Queue Manager.
After running SETUP
to install LeasePak/Oracle, if the administrator chose to have the Oracle init service nst_dbora
installed, the file /etc/netsol_dbms_instances
may need to be maintained.
/etc/netsol_dbms_instances
contains an assignment to the variable ORA_INSTANCES
. The value assigned to ORA_INSTANCES
should be a quoted, space-separated list of the names of Oracle instances to be started or stopped on the Combined Host when the run level changes. These values are used by the service nst_dbora
to help manage these instances.