2024年5月3日发(作者：行车记录仪十大品牌)

HammerDB v2.14 Installation and Troubleshooting Guide

This guide gives you an introduction to installing and troubleshooting HammerDB v2.14 on Linux and

Windows and compiling for UNIX platforms. Please read this guide carefully before raising support issues.

Hammerora to HammerDB Renaming ............................................................................................ 1

HammerDB v2.14 New Features ..................................................................................................... 1

Tested Platforms and Databases ....................................................................................................... 2

Understanding 32 and 64-bit installations ....................................................................................... 3

Linux ............................................................................................................................................. 4

Windows ...................................................................................................................................... 4

Verifying the Database Client Libraries ........................................................................................... 5

Oracle ........................................................................................................................................... 6

SQL Server .................................................................................................................................... 6

MySQL .......................................................................................................................................... 6

PostgreSQL ................................................................................................................................... 7

Redis ............................................................................................................................................. 7

Installing HammerDB on Linux 7

Starting HammerDB ...................................................................................................................... 12

Linux ........................................................................................................................................... 12

Windows .................................................................................................................................... 13

.................................................................................................................................. 13

Uninstalling HammerDB on Linux and Windows ......................................................................... 13

Troubleshooting ............................................................................................................................. 15

Troubleshooting Library Errors ................................................................................................... 15

Version `GLIBC_2.7' not found ................................................................................................... 18

Oracle on Windows Access blocked by UAC (User Account Control) ........................................ 19

DEP prevents command line execution in Windows Server 2012 ............................................. 20

Multithreaded OCI Applications Crash with Oracle 11g on Windows ....................................... 21

Building HammerDB on UNIX platforms ..................................................................................... 22

HammerDB source code ................................................................................................................ 23

Support and Questions ................................................................................................................... 23

Hammerora to HammerDB Renaming

Hammerora has been renamed to HammerDB in recognition of the wider number of databases supported

since the software’s first release. Whilst documentation is in progress existing document references to

Hammerora v2.11 and earlier can be used interchangeably with HammerDB with regards to functionality.

HammerDB v2.14 New Features

In HammerDB there are updated binaries in the precompiled packages to take advantage of the new

features of TCL 8.6 in future releases. All database packages have been recompiled to versions:

1

tcl8.6, tk8.6, thread2.7.0 (included with tcl8.6), oratcl4.5, mysqltcl3.052 pgtcl2.0.0 tclodbc2.5.1

All packages have been tested and verified against Linux x86 and x86-64 and Windows x86 and x86-64

Bug Fixes

[ #93 ] Oracle PL/SQL Schema Build Fails on Index Build

[ #94 ] SQL Server Transaction Counter reports Negative Number then Zero*

[ #95 ] pgsqlXXX is not a valid postgresql connection

*SQL Server Users should note that due bug #94 and an issue in SQL Server the transaction rate used for

TPM has changed from previous versions to Batches/Sec. This new value also coincides with the transaction

rate reported by SQL Server Management Studio.

Removed tclodbc builds on Linux releases and greyed out SQL Server benchmark option to make tclodbc

and SQL Server Windows only options

Added Order Line Tablespace option to Oracle Database TPC-C schema to enable partitioned Order Line

table to be placed in a separate cache with a different block size from the standard cache.

Implemented TimesTen TPC-C Partitioning Option

Implemented TimesTen TPC-H Workload

Added SQL Server TPC-C workload from schema and Stored Procedures provided by Thomas Kejser under

"updated" option. Regular schema remains available under "original" option

Tested Platforms and Databases

HammerDB has been built and tested on the following 32 and 64-bit Linux and Windows platforms.

Linux openSUSE 12.2

openSUSE 12.3

SUSE Linux Enterprise 11 SP2

Red Hat/Oracle Linux 6.2

Red Hat/Oracle Linux 6.3

Windows Windows 7

Windows Server 2008

Windows Server 2012

Databases SQL Server 2008

SQL Server 2012*

Oracle 9i

Oracle 10g

Oracle 11g

Oracle 12c

Oracle TimesTen 11.2.2.4.1**

MySQL 5.5

MySQL 5.6

PostgreSQL 9.1

PostgresQL 9.2

2