Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Headless installation is difference from console mode by the fact it does not require any input from the user so it can be done by soe automation agent like Jenkins or ElectricFlow. However it requires an XML file passed as a parameter to the installer instead of the "-console" option) .


The autoInstalled.xml file used for the Ubuntu example and a version tailored for Windows are attached.


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

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


UBUNTU: 


1. Getting Software and license

~$> cd /tmp
/tmp$> ftp SJC-FTP.thruinc.net
   Name:  software.datical.com\bbrown@datical.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


Get your license.

ftp> quit

2. Get minimum OS setup


/tmp$> sudo apt-get install -y default-jre
/tmp$> sudo apt install -y unzip
/tmp$> sudo apt install -y xterm
/tmp$> sudo apt-get install build-essential


4. Install Datical
/tmp$> sudo mkdir /opt/DaticalDB_4.18.3999
/tmp$> sudo chmod 777 /opt/DaticalDB_4.18.3999
/tmp$> sudo ln -sf /opt/DaticalDB_4.18.3999/ /opt/DaticalDB
/tmp$> java -jar DaticalDB-linux.gtk.x86_64-4.18.3999.jar autoInstall.xml
/tmp$> cp *-admin.lic /opt/DaticalDB
/tmp$> cp *-admin.lic /opt/DaticalDB/repl
/tmp$> export PATH=$PATH:/opt/DaticalDB/repl
/tmp$> hammer installDrivers http://update.datical.com/drivers/updates

5.  Verify Install

/tmp$> hammer checkdrivers
/tmp$> hammer show version
/tmp$> hammer show license

Oracle Full Client on Ubuntu (I don't think this works)

~%> 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

 


  • No labels