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 |
|
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 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 200K 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 4.2.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.
Targeted unload rows per session thread: <rowLimitPerSessionThread>
Maximum session thread : <sessionThreadLimit>
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 4.2.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>
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.