Release 2.3 for Windows
The
precompiled
installer files for version 2.3 have been compiled from the following
source packages: TCL/TK 8.5.0, TCL Threads 2.6.5 Oratcl 4.4 and
MySQLTcl 3.05
For both the pre-compiled package and
building from source Hammerora requires the prior installation
of an Oracle Client at your preferred version and platform. This can be
the instant client, a full Oracle
database install or Oracle Express. Similarly for MySQL the MySQL
client libraries are required.
Pre-Installation
Troubleshooting
For both Oracle and MySQL it is essential that Hammerora can find the
correct libraries.
Oracle Libraries
For Oracle that means the presence of a symbolic link such as the
following on an Oracle 10g installation in the $ORACLE_HOME/lib
directory. In a standard successful Oracle install this link will
already exist and no further action is necessary.
lrwxrwxrwx 1 oracle
dba 57 2007-03-10 18:12
libclntsh.so ->
/u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
On an 11g install the symbolic link should point to
libclntsh.so.11. This is especially important to check
when using the Oracle instant client. If the link does not exist
then it must be created. For beginners looking for
an Oracle test
environment I strongly recommend installing Oracle Express in a 32-bit
environment before installing the pre-compiled package
MySQL Libraries
The pre-compiled packages have been compiled against
MySQL 5.0 which means if using a client of MySQL 5.1 or above you will
also need the client library libmysqlclient.so.15. This can
easily be downloaded from here and
installed as follows for example on 64-bit Red Hat.
MySQL-shared-compat-5.0.81-0.rhel5.x86_64.rpm
[root@dragonfly tmp]# rpm -ivh
MySQL-shared-compat-5.0.81-0.rhel5.x86_64.rpm
Preparing...
########################################### [100%]
1:MySQL-shared-compat
########################################### [100%]
Alternatively the files can be copied manually from a
MySQL 5.0 install
[root@dragonfly
/]# ls /usr/lib64/libmy*
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient_r.so.12
/usr/lib64/libmysqlclient.so.12
/usr/lib64/libmysqlclient_r.so.12.0.0
/usr/lib64/libmysqlclient.so.12.0.0
/usr/lib64/libmysqlclient_r.so.14
/usr/lib64/libmysqlclient.so.14
/usr/lib64/libmysqlclient_r.so.14.0.0
/usr/lib64/libmysqlclient.so.14.0.0
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient_r.so.15.0.0
/usr/lib64/libmysqlclient.so.15.0.0
Installing the
pre-compiled package
To start the installer on Linux make the
installer file executable
oracle@test:~> chmod u+x
hammerora-2.3-Linux-x86
and run the executable
oracle@test:~> ./hammerora-2.3-Linux-x86
On Windows double-click on the installer
file
The installer will
start giving you the
option of selecting the installation language
You
can then
choose whether to continue with the installation
At
the start of
the install wizard, click next
Choose
the
destination location and Click Next. To change the default location
Click Browse and select a new location
Click
next to
start copying the installation files
Hammerora
will
be installed in your selected location
On
the
completion screen click finish
If
you opt to
launch Hammerora and your Oracle client is successfully installed the
main application window is displayed
Installing from source
The primary development environment for
Hammerora is 32-bit Linux x86 with additional testing on 32-bit Windows
x86 and 64-bit Linux x86-64. Hammerora should compile and run on any
platform that supports both TCL and Oracle.
Important Notes:
TCL Version: From version 2.1 onwards TCL
and TK version 8.5.0 is a minimum requirement as version 8.5.0 includes
the Tile package used for the enhanced interface.
Threads: Standard pre-packaged TCL
binaries may
not
be thread-enabled, to check run the following command :
/usr/local/bin/tclsh8.4
%
parray tcl_platform
tcl_platform(byteOrder)
= littleEndian
tcl_platform(machine)
= i686
tcl_platform(os)
= Linux
tcl_platform(osVersion)
= 2.4.20-8custom
tcl_platform(platform)
= unix
tcl_platform(threaded)
= 1
tcl_platform(user)
= oracle
tcl_platform(wordSize)
= 4
If the
tcl_platform(threaded) element does not exist then TCL is not
thread enabled and cannot be used for Hammerora.
With standard file permissions on the /usr/local directory the following will need to be done as root except where stated.
Download the following packages from Sourceforge to your /usr/local/src directory and extract them using the tar and unzip commands.
tcl850-src.zip, tk850-src.zip,
thread265.zip, oratcl44.tar.tar and mysqltcl-3.05.tar.gz
Note
that for either Oracle or MySQL support only
Download the following package to a location of your choosing:
hammerora-2.2-src.tar.gz
and untar and unzip it using the command “tar zxvf” to produce the
following directory structure
oracle@test:~>
ls hammerora-2.2-src
ChangeLog COPYRIGHT hammerora.tcl readme
config.xml hammerora.license hora-components
TCL
cd tcl8.5.0/unix
./configure
--enable-threads
make
make
install
TK
Note: To compile TK on Linux the X development RPMS are required.
cd tk8.5.0/unix
./configure
--enable-threads
make
make
install
TCL
Threads
cd thread265/unix
sh
../configure
make
make
install
Oratcl
cd oratcl4.4
./configure
--enable-threads
make
make
install
MySQLTcl
Ensure that
the LD_LIBRARY_PATH environment variable is set to include the MySQL
client libraries
cd
mysqltcl-3.05
./configure
--enable-threads
make
make
install
to run Hammerora under Linux :
Change to the Oracle user with the correct environment variables set and make sure that the standard Oracle utilities such as tnsping and sqlplus can connect to the database.
Without the correct environment variable settings the following error will be given:
oralogon (Unknown OCI status) OCIInitialize. Check ORACLE_HOME setting!
eg tnsping mydatabase, sqlplus system/manager@mydatabase
make sure the DISPLAY variable is correctly set eg
export DISPLAY=myhost:0.0
As the Oracle user run hammerora from the chosen directory
./hammerora.tcl
Compiling all the TCL/TK packages required to run Hammerora on Windows using Microsoft Visual C++.
Download the following packages from Sourceforge to your chosen directory and untar and unzip them using Winzip. ( Winzip will recognise and unzip the tar.gz format )
tcl850-src.zip, tk850-src.zip, thread265.zip, oratcl44.tar.tar, mysqltcl-3.05.tar.gz
Download the following package to a location of your choosing:
hammerora-2.2-src.tar.gz and untar and unzip it using Winzip
TCL
cd tcl8.5.0\win
Create and run an example .bat file such as below specifying the correct location of vcvars32.bat the installation directory and to use the threads option.
if "%MSVCDir%" == "" call "C:\Program Files\Microsoft Visual
Studio\vc98\bin\vcvars32.bat"
set INSTALLDIR=C:\Program Files\hammerora-2.1
set path=%PATH%;C:\program files\microsoft visual studio\vc98\bin
set TCLDIR=..\..\tcl8.5.0
nmake -nologo -f makefile.vc hose OPTS=none
if errorlevel 1 goto error
nmake -nologo -f makefile.vc clean all install OPTS=threads
if errorlevel 1 goto error
goto end
:error
echo *** BOOM! ***
:end
title Building Tcl, please wait...DONE!
echo DONE!
pause
TK
cd tk8.5.0\win
Create
and run an example .bat file such as below specifying the correct
location of vcvars32.bat the installation directory and to use the
threads option.
if
"%MSVCDir%" == "" call "C:\Program Files\Microsoft Visual
Studio\vc98\bin\vcvars32.bat"
set
INSTALLDIR=C:\Program Files\hammerora-2.1
set
path=%PATH%;C:\program files\microsoft visual studio\vc98\bin
set
TCLDIR=..\..\tcl8.5.0
nmake
-nologo -f makefile.vc hose OPTS=none
if
errorlevel 1 goto error
nmake
-nologo -f makefile.vc clean all install OPTS=threads
if
errorlevel 1 goto error
goto
end
:error
echo
*** BOOM! ***
:end
title
Building Tk, please wait...DONE!
echo
DONE!
pause
Threads
cd thread265\win\vc
Create
and run an example .bat file such as below specifying the correct
location of vcvars32.bat and to use the threads option.
if
"%MSVCDir%" == "" call "C:\Program Files\Microsoft Visual
Studio\vc98\bin\vcvars32.bat"
set
path=%PATH%;C:\program files\microsoft visual studio\vc98\bin
set
TCLDIR=..\..\..\tcl8.5.0
nmake
-f makefile.vc all install OPTS=threads
pause
Oratcl
cd oratcl4.4\win
Create and run
an example .bat file such as below
specifying the correct location of vcvars32.bat
if "%MSVCDir%" ==
"" call "C:\Program Files\Microsoft Visual
Studio\vc98\bin\vcvars32.bat"
set path=%PATH%;C:\program files\microsoft visual studio\vc98\bin
set INSTALLDIR=C:\Program Files\hammerora-2.1
set TCL=C:\Documents and Settings\sshaw\My Documents\MUSTBACKUP\ORACLE
DOCS\TCLFILES\Hammeora-2.1-source\tcl8.5.0
nmake -f makefile.vc clean all OPTS=threads
pause
to run Hammerora under Windows :
Make
sure that the correct environment variables are set and that the
standard Oracle utilities such as tnsping and sqlplus can
connect to the database and double click on the icon:
hammerora.bat