Contents
Documentation
Documentation
Updates
Documentation
Accessibility
Welcome
to ubTools
What
is ubTools
What
is ubSQL
Downloading ubSQL
Versioning
Support
System
Requirements
C Compilers
Hardware
and Operating Systems
Memory
and Disk Space Requirements
Pre-Installation
Backing
Up Existing Installations
Installation
Linking ubSQL
Post-installation
Verifying
installation
Production
License Key
Configuring
and Running ubSQL
De-installation
Change log
Copyright Notice
Documentation
This document contains installation instructions for ubSQL.
Documentation
Updates
| Documentation Version |
ubSQL Version |
Date |
| 6.0 |
6.0.2 |
April-29, 2012 |
| 5.1 |
5.1.0 |
Aug-14, 2011 |
| 5.0 |
5.0.1 |
July-03, 2011 |
| 4.2 |
4.2.2 |
February-11, 2008 |
| 4.0 |
4.0.10 |
September-08, 2007 |
Documentation
Accessibility
The latest version of this document is available at:
URL: http://www.ubtools.com/web/public/resources
Welcome to
ubTools
ubTools brings high-quality softwares and consultancy. We
believe
that you will find that the result with ubTools is truly more than
before.
What is ubTools
ubTools, a subsidiary of Unal Bilisim founded in 2001, is a
company develops and hosts Oracle database products.
What is ubSQL
ubSQL is a utiliy which unloads Oracle data to text/binary
format; runs DML/DDL statements.
URL: http://www.ubtools.com/web/public/products/ubsql
Downloading
ubSQL
ubSQL consists of 4 files:
- ubSQL.o: A compiled C object file.
- ubSQL.ini: Parameter file.
- ubSQL: Executable
- ubsql_installation.html: This file.
URL: http://www.ubtools.com/web/public/downloads
Versioning
The product version of a.b.c is defined as below:
- a: Major new feature additions.
- b: Minor new feature additions.
- c: Minor changes and bug fixes.
Support
If you encounter a problem, go to the following address at:
URL: http://www.ubtools.com/web/public/support
System
Requirements
C Compilers
If ubSQL executable works without a problem, it's not required to have
a C compiler. If ubSQL executable is not compatible with installed
operating system, genarate ubSQL executable.
See Oracle Note:43208.1 for certified C compilers. Uncertified
compilers will give error in linking.
ORACLE_HOME
ubSQL requires an ORACLE_HOME greater than Oracle 9i and onwards. It
doesn't require a database for its configuration.
Hardware
and Operating Systems
ubSQL is platform dependent C utility. Since it uses POSIX
system
calls, it's widely available to compile on many platforms. The
currently available platform dependent object and executable files are
available in their corresponding folders.
Memory
and Disk Space Requirements
ubSQL takes 300K on disk. Runtime memory allocation depends on
the configuration parameters.
Pre-Installation
If ubSQL executable works without a problem, skip this step and go to
the Post-installation
part.
Backing
Up Existing Installations
Don't generate ubSQL executable in the existing ubSQL
directory. If
you need the old installation, move old installation to a different
directory.
Installation
If ubSQL executable works without a problem, skip this step and go to
the Post-installation
part.
Linking ubSQL
Link ubSQL to generate ubSQL executable as
<oracle> user:
- make -f $ORACLE_HOME/rdbms/demo/demo_rdbms.mk build
EXE=ubSQL OBJS=ubSQL.o
The steps above will generate ubSQL executable. If you don't have a
certified C compiler, you get error.
Post-installation
Verifying
installation
If you want to evaluate ubSQL, set LICENSE_KEY=EVALUATION in ubSQL.ini
and run ubSQL. After running ubSQL, you should see the following
messages:
- $ ./ubSQL
ubSQL: Release 6.0.2 - Production - _POSIX_VERSION: 200112
Copyright (c) 2005, ubTools, Adana/Turkey. All rights reserved.
Not connected to an instance.
WARNING: This is an evaluation version.
Maximum unload rows target per thread set : <rowLimitPerThreadSet>
Maximum
thread
sets
: <threadSetLimit>
ubSQL>
Production
License Key
If you need a production license key, set LICENSE_KEY=NULL in ubSQL.ini
and run ubSQL. It will generate a pre-license key.
- $ ./ubSQL
ubSQL: Release 6.0.2 - Production - _POSIX_VERSION: 200112
Copyright (c) 2005, ubTools, Adana/Turkey. All rights reserved.
Not connected to an instance.
Contact Support with the pre-license key: <preLicenseKey>
ubSQL-7 [12] INFO: Pre-license key created.
$
Email this key to ubTools. Then, ubTools provides a production license
key.
Configuring
and Running ubSQL
To configure and run ubSQL, refer to Configuring and Running ubSQL
Documentation.
De-installation
To de-install ubSQL, remove ubSQL files.
Change log
All change logs URL: http://www.ubtools.com/jira/secure/BrowseProject.jspa?id=10050&subset=-1
Copyright
Notice
ubSQL is available in the 2 forms:
- Evaluation releases: Works with an evaluation license key.
- Production releases: Works with a production license key.
You can use the evaluation releases for free of charge. They
never expire.
The production releases can not be distributed. The evaluation
releases can be distributed.
ubSQL can't be modified except its configuration file.