...
Code Block |
---|
|
Overview:
1. Verify / Install prerequisites
> Java Runtime 7.x or 8.x (only required for initial installation)
> Oracle Client - Database Utilities (impdp & expdp) (required to run deploymentPackager, not required for installation)
> zip, unzip
2. Create datical group & datical user (optional)
> Alternatively, install software using existing jenkins user
3. Download Datical Files (into tmp directory) & Setup Directories
> Installer: DaticalDB-linux.gtk.x86_64-x.y.z.jar
> Composite Repo: DaticalDBCompositeRepo-x.y.z.zip
> License File: filename-admin.lic
> Directory Structure: datical_install_files.zip
4. Install Datical
> Run installer
> Create symbolic link to versioned install directory (optional)
> Copy license to install directory & repl directory (optional)
> Modify logging-config.ini (optional)
> Modify repl/logging-config.ini (optional)
> Modify datical.ini (optional)
> Modify hammer-bin.ini (optional)
> Unzip reporttemplates.zip to $workspace/.reporttemplates
> Install Drivers
5. Verify install
6. Zip datical for distribution
7. Unzip /opt on other servers for replication.
8. Install DaticalDB Jenkins plugin (see Datical DB - Integrating Other Tools Systems.pdf, pg 11-13)
Create datical user & group?
Create sym link?
export $PATH (optional) in .bash_profile?
export DATICAL_DB_HOME in .bash_profile?
run ./~.bash_profile
Questions:
* How does the datical/jdbc_drivers directory get recognized? (See Full Access doc pg. 15)
* Which user / group on linux should install DaticalDB?
|
RedHat / CentOS
Code Block |
---|
CENTOS 7, Minimum Install:
Commands (RedHat Enterprise / CentOS7):
1. [root@localhost ~]# yum install zip unzip
[root@localhost ~]# yum install java-1.8.0-openjdk.x86_64
2. Create datical group & datical user
[root@localhost ~]# groupadd datical
[root@localhost ~]# useradd -d /opt/datical -g datical datical
[root@localhost ~]# passwd datical
3. Download Datical Files
[root@localhost ~]# su datical
[datical@localhost root]$ cd ~
[datical@localhost ~]$ mkdir tmp
[datical@localhost ~]$ cd tmp
[datical@localhost tmp]$ ftp SJC-FTP.thruinc.net
Name: software.datical.com\user@email.com
Password: password
ftp> cd COMMON/Datical_DB_Software/Datical_DB_4.18.3999
ftp> binary
ftp> get DaticalDB-linux.gtk.x86_64-4.18.3999.jar
ftp> get DaticalDBCompositeRepo-4.18.3999.zip
ftp> quit
[datical@localhost tmp]$ unzip datical_install_files.zip -d ~/
[datical@localhost tmp]$ mv DaticalDB-linux.gtk.x86_64-4.18.3999.jar ~/installers/daticaldb_4.18.3999/
[datical@localhost tmp]$ mv filename-admin.lic ~/license/
[datical@localhost tmp]$ mv DaticalDBCompositeRepo-4.18.3999.zip ~/installers/daticaldb_4.18.3999/
4. Install Datical
[datical@localhost tmp]$ cd ~/app/daticaldb_4.18.3999/
[datical@localhost daticaldb_4.18.3999]$ java -jar ~/installers/daticaldb_4.18.3999/DaticalDB-linux.gtk.x86_64-4.18.3999.jar -console
> Select target path [/opt/datical/app/daticaldb_4.18.3999]
> Do not install license in this step
[datical@localhost daticaldb_4.18.3999]$ cp ~/license/filename-admin.lic .
[datical@localhost daticaldb_4.18.3999]$ cp ~/license/filename-admin.lic repl/
[datical@localhost daticaldb_4.18.3999]$ sed -i -- 's/@user.home\/datical/\/opt\/datical\/workspace/g' datical.ini
[datical@localhost daticaldb_4.18.3999]$ sed -i -- 's/@user.home\/datical/\/opt\/datical\/workspace/g' repl/hammer-bin.ini
[datical@localhost daticaldb_4.18.3999]$ cd ~/app
[datical@localhost app]$ ln -s daticaldb_4.18.3999/ daticaldb
[datical@localhost app]$ cd ~/workspace
[datical@localhost workspace]$ unzip ~/tmp/.reporttemplates.zip -d .
[datical@localhost workspace]$ cd ~/app/daticaldb_4.18.3999/repl
[datical@localhost repl]$ ./hammer installDrivers jar:file:/opt/datical/installers/daticaldb_4.18.3999/DaticalDBCompositeRepo-4.18.3999.zip\!/
5. Verify Install
[datical@localhost daticaldb]$ cd ~/app/daticaldb/repl
[datical@localhost repl]$ ./hammer checkdrivers
[datical@localhost repl]$ ./hammer show version
[datical@localhost repl]$ ./hammer show license
6. Zip for Distribution
[datical@localhost datical]$ rm -rf installers
[datical@localhost datical]$ rm -rf tmp
[datical@localhost datical]$ rm -rf license
[datical@localhost datical]$ mkdir /tmp/datical
[datical@localhost datical]$ cd /opt
[datical@localhost opt]$ zip -r /tmp/datical/datical.zip datical
|
Ubuntu
Tested on Ubuntu 17.04 on May 22, 2017 by Former user (Deleted) with attached autoInstall.xml
...
Code Block |
---|
sudo apt-get install -y default-jre
sudo apt install -y unzip
sudo apt install -y xterm
sudo apt-get install build-essential
4. Install Datical
sudo mkdir /opt/DaticalDB_4.18.3999
sudo chmod 777 /opt/DaticalDB_4.18.3999
sudo ln -sf /opt/DaticalDB_4.18.3999/ /opt/DaticalDB
java -jar DaticalDB-linux.gtk.x86_64-4.18.3999.jar autoInstall.xml
cp *-admin.lic /opt/DaticalDB
cp *-admin.lic /opt/DaticalDB/repl
export PATH=$PATH:/opt/DaticalDB/repl
hammer installDrivers http://update.datical.com/drivers/updates
5. Verify Install
hammer checkdrivers
hammer show version
hammer show license
|
Oracle Full Client on Ubuntu (I don't think this works)
Code Block |
---|
~%> cd /usr/local/Datical/Installers/client
~%> /usr/local/Datical/Installers/client%> ./runInstaller
>> Custom Installation
>> Oracle Base: /usr/local/Datical/Oracle
>> Oracle Software Location: /usr/local/Datical/Oracle/product/11.2.0/client_1
>> Oracle Inventory Directory: /urs/local/Datical/oraInventory
>> Group: sudo
>> Product Components: Oracle Database Utilities
sudo ln -s /etc /etc/rc.d
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/basename /bin/basename
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64
sudo ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64
sudo ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64 |